Statistical Funtion
 

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

Statistical Funtion
 

I do not understand your question. please explain more.

"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

Statistical Funtion
 

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

Statistical Funtion
 

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

Statistical Funtion
 

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

Statistical Funtion
 

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

Statistical Funtion
 

Maybe you mean Tools|Data Analysis?

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

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


--

Dave Peterson

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