Excel Exercise
The standard deviation is a measure of how much variation is present in a sample or population. Refer to the Descriptives table in the spreadsheet and identify the standard deviation for the weights of the three groups. Enter the standard deviation next to the variable names below.
B. Wt_Grp_2 = _____
C. Wt_Grp_3 = _____
For the three histograms below enter the letter corresponding to the Wt_Grp with a standard deviation most consistent with the shape of the histogram.
Letter ______ (1 pt)
Letter: ______ (1 pt)
Letter ______ (1 pt)
Refer to the TwoSampleTTest tab in the assignment spreadsheet.
Answer the following questions:
Which group of subjects is least alike with regard to weight? ____ (1 pt)
Do the two groups have significantly different mean weights? (Yes/No)_____ (1 pt)
Refer to the PairedTTest tab in the assignment spreadsheet.
Answer the following questions:
Which group of subjects are least alike with regard to blood pressure? ____ (1 pt)
Do the two groups have significantly different mean blood pressures? (Yes/No)______ (1pt)
To answer the question: Is the 2nd diastolic blood pressure significantly different between Groups
1, 2, and 3—refer to the ANOVA tab in the assignment spreadsheet.
Which group is most alike with respect to blood pressure? ____ (1 pt)
Is there a significant difference in mean blood pressure between the groups? ______ (1 pt)
Page 1 of 2