Statistical Funtion

[Pedro Mestre]

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

 

[bj]

I do not understand your question. please explain more.

 

[Dave Peterson]

Maybe you're thinking of =subtotal().

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

 

[Pedro Mestre]

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:

 

[bj]

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

 

[David Biddulph]

Tools/ Data Analysis/ Descriptive Statistics.

 

[Dave Peterson]

Maybe you mean Tools|Data Analysis?

(Only if Tools|Addins|Analysis toolpak is installed)

 

[Pedro Mestre]

Ok, we will try it.

Thanks a lot.

Kind regards,
Pedro Mestre

"David Biddulph" escreveu: