Posted to microsoft.public.excel.worksheet.functions

sgreene

external usenet poster

Posts: 11

Standard Deviation do I use 520 (20x26) inputs or avg of each

We have 520 inputs...20 categories x 26 participants
For the Standard Deviation do we use the average of the 20 categories or the
520 inputs? We used stdevp on the 520 and got 1.1 When we used the stdevp
on the averages of the 20 categories we got .3
Can you help we are not sure which one is correct?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
standard deviation	Arne Hegefors	Excel Discussion (Misc queries)	7	August 6th 06 01:12 PM
Standard Deviation	Stan Banner	Excel Worksheet Functions	1	March 12th 06 12:54 AM
Standard Deviation	Stan Banner	Excel Worksheet Functions	1	March 11th 06 09:11 PM
Standard Deviation	Carlos	Excel Worksheet Functions	10	January 2nd 06 09:17 AM
standard deviation	Chris	Excel Discussion (Misc queries)	1	October 13th 05 04:52 AM

All times are GMT +1. The time now is 03:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us