Statistical Funtion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pedro Mestre - 11 Sep 2007 15:06 GMT

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

Reply to this Message

bj - 11 Sep 2007 15:16 GMT

I do not understand your question. please explain more.

> Dear all,
>
[quoted text clipped - 12 lines]
> Thanks in advance,
> Pedro Mestre

Reply to this Message

Dave Peterson - 11 Sep 2007 15:32 GMT

Maybe you're thinking of =subtotal().

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

> Dear all,
>
[quoted text clipped - 12 lines]
> Thanks in advance,
> Pedro Mestre

Signature

Dave Peterson

Reply to this Message

Pedro Mestre - 11 Sep 2007 16:04 GMT

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

> Maybe you're thinking of =subtotal().
>
[quoted text clipped - 16 lines]
> > Thanks in advance,
> > Pedro Mestre

Reply to this Message

bj - 11 Sep 2007 17:02 GMT

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

> I am sorry,
>
[quoted text clipped - 39 lines]
> > > Thanks in advance,
> > > Pedro Mestre

Reply to this Message

David Biddulph - 11 Sep 2007 17:03 GMT

Tools/ Data Analysis/ Descriptive Statistics.

Signature

David Biddulph

>I am sorry,
>
[quoted text clipped - 41 lines]
>> > Thanks in advance,
>> > Pedro Mestre

Reply to this Message

Pedro Mestre - 11 Sep 2007 17:14 GMT

Ok, we will try it.

Thanks a lot.

Kind regards,
Pedro Mestre

> Tools/ Data Analysis/ Descriptive Statistics.
> >I am sorry,
[quoted text clipped - 42 lines]
> >> > Thanks in advance,
> >> > Pedro Mestre

Reply to this Message

Dave Peterson - 11 Sep 2007 17:04 GMT

Maybe you mean Tools|Data Analysis?

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

> I am sorry,
>
[quoted text clipped - 43 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message