Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Deviation do I use 520 (20x26) inputs or avg of each
What is the population for which you want to calculate the standard
deviation? If the population is the set of all observations, then it sounds like your population is the 520 observations. As for taking the average of categories--I'm not sure what you mean by that.' Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "sgreene" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Deviation do I use 520 (20x26) inputs or avg of each
Thank you Dave, All total we have 520 responses Each response fits under a certain category..there are 20 categories We take and total the responses (numeric value) add them up to get a final average for the column. When I said that we took the averages I meant that we took the "final averages" for each category and got the .3 standard deviation The total population (20x26) standard deviation comes out to be 1.1 I hope this explains it more. Thank you, Sharon "Dave F" wrote: What is the population for which you want to calculate the standard deviation? If the population is the set of all observations, then it sounds like your population is the 520 observations. As for taking the average of categories--I'm not sure what you mean by that.' Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "sgreene" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Deviation do I use 520 (20x26) inputs or avg of each
Well again I think you need to determine what your population is. Is the
population the average of the categories or is the population the 520 observations? I don't know why you would take the standard deviation of the former, but there may be a reason for it. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "sgreene" wrote: Thank you Dave, All total we have 520 responses Each response fits under a certain category..there are 20 categories We take and total the responses (numeric value) add them up to get a final average for the column. When I said that we took the averages I meant that we took the "final averages" for each category and got the .3 standard deviation The total population (20x26) standard deviation comes out to be 1.1 I hope this explains it more. Thank you, Sharon "Dave F" wrote: What is the population for which you want to calculate the standard deviation? If the population is the set of all observations, then it sounds like your population is the 520 observations. As for taking the average of categories--I'm not sure what you mean by that.' Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "sgreene" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Deviation do I use 520 (20x26) inputs or avg of each
Which one you should use depends on which one you need for your next set of
calculations. You may need both depending. Both are valid statistics, but have different uses The issue is not an EXCEL issue. You need to go to a statistician and describe your needs and he will be able to determine which one you need "sgreene" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) |