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) |