Data Analysis for Business

profilemom166
Assignment1Examples.xlsx.pdf

Score

Actual

Point

Margin x-xi (x-xi) 2

Sorted Data

Auburn 38 Northwestern 35 3 -8 64 2

Florida State 33 West Virginia 21 12 1 1 3

Penn State 19 LSU 17 2 -9 81 7 ∑(x-xi) 2

Ohio State 26 Oregon 17 9 -2 4 9 458

Florida 51 Cincinnati 24 27 16 256 10

Mississippi State 21 Oklahoma State 7 14 3 9 10

Texas Tech 41 Michigan State 31 10 -1 1 12 ∑(x-xi) 2 /(n-1)

Boise State 17 TCU 10 7 -4 16 14 variance 50.88889

Iowa 24 Georgia Tech 14 10 -1 1 16

Alabama 37 Texas 21 16 5 25 27 (*∑(x-xi) 2 /(n-1))^.5

st dev 7.133645

∑xi

mean 11 110

median 10 ∑xi/n

mode 10 11

standard deviation 7.13364

variance 50.8889 3 above the menamean

Lx=8.0

72.7272727

90th percentile 25.9 17.1 72.72 percentile standardized scores

27th percentile 6.88 Raw z

9 -0.28

percentile of the 8th above the median N/A 1 below the mean 14 0.42

percentile of the 12 below the median N/A Lx=5 16 0.70

45.4545455 3 -1.12

percentile of 3 above the median 0.727 45.45 percentile 10 -0.14

percentile of 1 below the median 12 0.14

Frequency realative frequency Cumulative Frequency midpoints

2-6 2 0.2 2 4

7-11 4 0.4 6 9

12-16 3 0.3 9 14

17-21 0 0 9 19

22-27 1 0.1 10 24.5

∑fi 10

90th

L90 9.9 25.9

L27 2.97 6.88

Frequency Chart

0

0.5

1

1.5

2

2.5

3

3.5

4

4.5

2-6 7-11 12-16 17-21 22-27