# Excel2 - Problem I May Ann Caballero mjc2659 9am Dollars...

This preview shows pages 1–4. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Problem I May Ann Caballero - mjc2659 9am Dollars Spent 6.1 40.8 28.6 3.11 34.7 8.88 9.26 10.81 12.69 =CONFIDENCE(.05, 22, 50) C1=B2+B1 D1=B2-B1 13.78 =AVERAGE(A2:A51) 15.23 15.62 17 17.39 18.36 18.43 19.27 19.5 19.54 20.16 20.59 22.22 23.04 24.47 24.58 25.13 26.24 26.26 27.65 28.06 28.08 28.38 32.03 34.98 36.37 38.64 39.16 41.02 42.97 44.08 44.67 45.4 46.69 48.65 50.39 52.75 54.8 59.07 61.22 70.32 82.7 85.76 86.37 93.34 A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Problem II May Ann Caballero - mjc2659 9am 18 1 22 21 28 26 14 Ho: μo=25 16 Ha: μa<25 20 B1=ZTEST(A1:A10,25,7) 20 B2=1-B1 24 A B C D E 1 2 3 4 5 6 7 8 9 10 Problem III May Ann Caballero - mjc2659 9am Scores Scores 40 26 Mean 35.09 1.83 39 Standard Error 1.69 0.07 14 Median 35 0.04 42 Mode 35 38.49 18 Standard Deviation 11.19 31.69 25 Sample Variance 125.2 43 Kurtosis-0.88 46 Skewness-0.23 27 Range 40 19 Minimum 14 47 Maximum...
View Full Document

{[ snackBarMessage ]}

### Page1 / 6

Excel2 - Problem I May Ann Caballero mjc2659 9am Dollars...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online