| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need statistical help | Excel Worksheet Functions | |||
| If Funtion | Excel Worksheet Functions | |||
| IF funtion | Excel Discussion (Misc queries) | |||
| Statistical add-ins | Excel Discussion (Misc queries) | |||
| Can I "CORREL" statistical funtion with three or more Arrays? | Excel Worksheet Functions | |||
Hybrid Mode
