View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pedro Mestre Pedro Mestre is offline
external usenet poster
 
Posts: 9
Default Statistical Funtion

Ok, we will try it.

Thanks a lot.

Kind regards,
Pedro Mestre

"David Biddulph" escreveu:

Tools/ Data Analysis/ Descriptive Statistics.
--
David Biddulph

"Pedro Mestre" wrote in message
...
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