HOw do I set up Standard Error in a spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
comparing columns in two spreadsheets 1
VLookup multiple spreadsheets 2
How do I match 3 different workbooks information for similar data? 2
Lookups - how to obtain data from a master spreadsheet into another 5
error with countif formula on when adding linked spreadsheets 0
how do i set up a horizontal spreadsheet? 2
how do i make a cell a search cell for a spreadsheet 5

Back
Top