In: Statistics and Probability
WHAT IS THE
A. MEAN
B. THE VARIANCE
C. THE STANDARD DEVIATION
Respondent | QUESTION 1 | QUESTION 2 | QUESTION 3 | QUESTION 4 | QUESTION 5 | QUESTION 6 | QUESTION 7 | QUESTION 8 | OBESE? |
A | 2 | 1 | 2 | 1 | 3 | 4 | 3 | 2 | N |
B | 1 | 2 | 1 | 5 | 3 | 1 | 3 | 5 | N |
C | 2 | 5 | 3 | 3 | 3 | 3 | 4 | 2 | N |
D | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 5 | N |
E | 2 | 4 | 4 | 1 | 5 | 3 | 4 | 2 | N |
F | 2 | 1 | 2 | 2 | 3 | 2 | 2 | 2 | N |
G | 4 | 3 | 4 | 1 | 3 | 4 | 4 | 3 | Y |
H | 1 | 1 | 3 | 1 | 3 | 5 | 4 | 1 | N |
I | 2 | 1 | 2 | 1 | 3 | 2 | 3 | 5 | N |
J | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | N |
K | 1 | 3 | 1 | 3 | 3 | 3 | 3 | 5 | N |
L | 1 | 4 | 2 | 1 | 2 | 2 | 3 | 5 | N |
M | 1 | 5 | 1 | 1 | 1 | 3 | 5 | 1 | N |
N | 1 | 3 | 1 | 1 | 3 | 4 | 2 | 3 | Y |
O | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 3 | Y |
Calculated mean, variance and standard deviation for each questions level and also the overall level
Respondent | QUESTION 1 | QUESTION 2 | QUESTION 3 | QUESTION 4 | QUESTION 5 | QUESTION 6 | QUESTION 7 | QUESTION 8 | OBESE? |
A | 2 | 1 | 2 | 1 | 3 | 4 | 3 | 2 | N |
B | 1 | 2 | 1 | 5 | 3 | 1 | 3 | 5 | N |
C | 2 | 5 | 3 | 3 | 3 | 3 | 4 | 2 | N |
D | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 5 | N |
E | 2 | 4 | 4 | 1 | 5 | 3 | 4 | 2 | N |
F | 2 | 1 | 2 | 2 | 3 | 2 | 2 | 2 | N |
G | 4 | 3 | 4 | 1 | 3 | 4 | 4 | 3 | Y |
H | 1 | 1 | 3 | 1 | 3 | 5 | 4 | 1 | N |
I | 2 | 1 | 2 | 1 | 3 | 2 | 3 | 5 | N |
J | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | N |
K | 1 | 3 | 1 | 3 | 3 | 3 | 3 | 5 | N |
L | 1 | 4 | 2 | 1 | 2 | 2 | 3 | 5 | N |
M | 1 | 5 | 1 | 1 | 1 | 3 | 5 | 1 | N |
N | 1 | 3 | 1 | 1 | 3 | 4 | 2 | 3 | Y |
O | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 3 | Y |
A. MEAN | 1.87 | 2.93 | 2.40 | 1.93 | 2.87 | 3.07 | 3.33 | 3.27 | |
B. THE VARIANCE | 1.41 | 2.35 | 1.54 | 1.50 | 0.70 | 1.35 | 0.95 | 2.50 | |
C. THE STANDARD DEVIATION | 1.19 | 1.53 | 1.24 | 1.22 | 0.83 | 1.16 | 0.98 | 1.58 | |
Overall: | |||||||||
A. MEAN | 2.71 | ||||||||
B. THE VARIANCE | 1.74 | ||||||||
C. THE STANDARD DEVIATION | 1.32 |
Formula Ref:
Respondent | QUESTION 1 | QUESTION 2 | QUESTION 3 | QUESTION 4 | QUESTION 5 | QUESTION 6 | QUESTION 7 | QUESTION 8 | OBESE? |
A | 2 | 1 | 2 | 1 | 3 | 4 | 3 | 2 | N |
B | 1 | 2 | 1 | 5 | 3 | 1 | 3 | 5 | N |
C | 2 | 5 | 3 | 3 | 3 | 3 | 4 | 2 | N |
D | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 5 | N |
E | 2 | 4 | 4 | 1 | 5 | 3 | 4 | 2 | N |
F | 2 | 1 | 2 | 2 | 3 | 2 | 2 | 2 | N |
G | 4 | 3 | 4 | 1 | 3 | 4 | 4 | 3 | Y |
H | 1 | 1 | 3 | 1 | 3 | 5 | 4 | 1 | N |
I | 2 | 1 | 2 | 1 | 3 | 2 | 3 | 5 | N |
J | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | N |
K | 1 | 3 | 1 | 3 | 3 | 3 | 3 | 5 | N |
L | 1 | 4 | 2 | 1 | 2 | 2 | 3 | 5 | N |
M | 1 | 5 | 1 | 1 | 1 | 3 | 5 | 1 | N |
N | 1 | 3 | 1 | 1 | 3 | 4 | 2 | 3 | Y |
O | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 3 | Y |
A. MEAN | =AVERAGE(C2:C16) | =AVERAGE(D2:D16) | =AVERAGE(E2:E16) | =AVERAGE(F2:F16) | =AVERAGE(G2:G16) | =AVERAGE(H2:H16) | =AVERAGE(I2:I16) | =AVERAGE(J2:J16) | |
B. THE VARIANCE | =VAR(C2:C16) | =VAR(D2:D16) | =VAR(E2:E16) | =VAR(F2:F16) | =VAR(G2:G16) | =VAR(H2:H16) | =VAR(I2:I16) | =VAR(J2:J16) | |
C. THE STANDARD DEVIATION | =STDEV(C2:C16) | =STDEV(D2:D16) | =STDEV(E2:E16) | =STDEV(F2:F16) | =STDEV(G2:G16) | =STDEV(H2:H16) | =STDEV(I2:I16) | =STDEV(J2:J16) | |
Overall: | |||||||||
A. MEAN | =AVERAGE(C2:J16) | ||||||||
B. THE VARIANCE | =VAR(C2:J16) | ||||||||
C. THE STANDARD DEVIATION | =STDEV(C2:J16) |