Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOw do I set up Standard Error in a spreadsheet?
I need to set up standard error of mean in a spreadsheet that will be used on
a daily basis to calcuate figures. I could use the data analysis tool but I would have to select each column of numbers and that would take a long time. I am trying to work with the summation equation to enter it into the spreadsheet in the most logical manner. Please help me. |
#2
|
|||
|
|||
Since I haven't taken statistics in years, I had to look up the definition of
standard error. Apparently it's just the std. deviation divided by the square root of the number of observations. If your data were in column A, this would be written in Excel as: =STDEV(A:A)/SQRT(COUNT(A:A)) HTH Jason Atlanta, GA "Laela" wrote: I need to set up standard error of mean in a spreadsheet that will be used on a daily basis to calcuate figures. I could use the data analysis tool but I would have to select each column of numbers and that would take a long time. I am trying to work with the summation equation to enter it into the spreadsheet in the most logical manner. Please help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |