Statistics Case Study Assignment

profilemasob7
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