There is no one function which will do what you are asking. you probably
would need to write a macro to do so.

"Pedro Mestre" wrote:

I am sorry,

I will make the questions with other words:

I know that Excel has a functionality that gives us all the statistical
information from a group of data.

Its as fuctionality where you choose the data and this function gives us in
a table information like:
Average
Median
Mode
Standard Deviation,
Variance
Covariance
Correlation
etc.
Do you know how to use it?

Thanks a lot.
Regards,
Pedro Mestre

"Dave Peterson" escreveu:

Maybe you're thinking of =subtotal().

But it doesn't do all of what you wrote.

Pedro Mestre wrote:

Dear all,

I think that there is one statistical funtion that does the same of this
formulas report:
Average
Median
Mode
Standard Deviation,
Variance
Covariance
Correlation

Could you help me please?

Thanks in advance,
Pedro Mestre

--

Dave Peterson