Is there any way to do statistics on ONLY the data SHOWING in a filtered
spreadsheet and not the entire file (hidden data and all). I dont mean using
the SUBTOTAL function that only allows those specific ten or so I want to do
Regression, T-tests, etc.

In fact what is the point of filtering data if statistics applied to it are
going to be applied to all the data?