Statistics Case Study Assignment
masob7
Week4CaseStudyData.xlsx
Data Set Method 1-Yardstick
| Entries | Inches | Feet |
| 1 | 72 | 6.00 | | Convert inches to feet |
| 2 | 71 | 5.92 | | 1foot =12 inches |
| 3 | 70 | 5.83 |
| 4 | 71 | 5.92 |
| 5 | 74 | 6.17 |
| 6 | 77 | 6.42 |
| 7 | 72 | 6.00 |
| 8 | 73 | 6.08 |
| 9 | 79 | 6.58 |
| 10 | 74 | 6.17 |
| 11 | 77 | 6.42 |
| 12 | 72 | 6.00 |
| 13 | 69 | 5.75 |
| 14 | 72 | 6.00 |
| 15 | 72 | 6.00 |
| 16 | 70 | 5.83 |
| 17 | 72 | 6.00 |
| 18 | 70 | 5.83 |
| 19 | 70 | 5.83 |
| 20 | 70 | 5.83 |
Data Set Method 2-Tape Measure
| Entries | Inches | Feet |
| 1 | 71 | 5.92 | | Convert inches to feet |
| 2 | 72 | 6.00 | | 1foot =12 inches |
| 3 | 73 | 6.08 |
| 4 | 77 | 6.42 |
| 5 | 72 | 6.00 |
| 6 | 72 | 6.00 |
| 7 | 70.5 | 5.88 |
| 8 | 72.5 | 6.04 |
| 9 | 72 | 6.00 |
| 10 | 72.5 | 6.04 |
| 11 | 72.5 | 6.04 |
| 12 | 72.5 | 6.04 |
| 13 | 77 | 6.42 |
| 14 | 72 | 6.00 |
| 15 | 72.5 | 6.04 |
| 16 | 72.5 | 6.04 |
| 17 | 79 | 6.58 |
| 18 | 72.5 | 6.04 |
| 19 | 73 | 6.08 |
| 20 | 73 | 6.08 |
Mean & Stand. Dev. Calculation
| Method 1 - Yardstick | | | Method 2 -Tape Measure |
| Observation | Measurement | | Observation | Measurement |
| 1 | 6.00 | | 1 | 5.92 |
| 2 | 5.92 | | 2 | 6.00 |
| 3 | 5.83 | | 3 | 6.08 |
| 4 | 5.92 | | 4 | 6.42 |
| 5 | 6.17 | | 5 | 6.00 |
| 6 | 6.42 | | 6 | 6.00 |
| 7 | 6.00 | | 7 | 5.88 |
| 8 | 6.08 | | 8 | 6.04 |
| 9 | 6.58 | | 9 | 6.00 |
| 10 | 6.17 | | 10 | 6.04 |
| 11 | 6.42 | | 11 | 6.04 |
| 12 | 6.00 | | 12 | 6.04 |
| 13 | 5.75 | | 13 | 6.42 |
| 14 | 6.00 | | 14 | 6.00 |
| 15 | 6.00 | | 15 | 6.04 |
| 16 | 5.83 | | 16 | 6.04 |
| 17 | 6.00 | | 17 | 6.58 |
| 18 | 5.83 | | 18 | 6.04 |
| 19 | 5.83 | | 19 | 6.08 |
| 20 | 5.83 | | 20 | 6.08 |
| Calculate | | | Calculate |
| Average | 6.03 | | Average | 6.09 |
| Standard Deviation | 0.22 | Standard Deviation | | 0.18 |