Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need statistical help DTTODGG Excel Worksheet Functions 2 October 9th 06 08:17 PM
If Funtion David Excel Worksheet Functions 4 November 29th 05 08:09 PM
IF funtion viddom Excel Discussion (Misc queries) 2 June 30th 05 02:53 PM
Statistical add-ins David Crane Excel Discussion (Misc queries) 0 June 29th 05 10:35 PM
Can I "CORREL" statistical funtion with three or more Arrays? juanes Excel Worksheet Functions 3 May 5th 05 01:17 AM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"