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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
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

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 Right Arrow Icon
Ask a homework question - tutors are online