AutoSave OFF @ E. Chapters 10-11 Summer 2021 Homework Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share 0 Comments X NIT Calibri (Body) v 11 AA == V ab Wrap Text General F CE ILX AYO WE Paste BIU a Av E Merge & Center v $ % ) ) Insert .00 000 Delete v Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data v Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No C16 fx A B D E F G H 1 K K L M N O P 2 R s 10.2 Part A 1 1 2 3 Null Hypothesis Alternative Hypothesis 10.2 You have data on the Ph levels of samples from two different rivers (located in cells A12:B24) You want to see if the Phlevels are different between the two rivers. Perform an hypothesis to test if the PH levels are different. 4 5 6 7 8 type of test test Statistic Value p-value Decision State your decision Relative to the Problem 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 River A 8.968 9.120 9.413 8.666 9.937 8.280 7.864 7.510 9.181 7.676 8.000 8.300 River B 6.670 4.000 10.000 8.000 7.500 7.422 6.563 8.500 8.000 9.000 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Hints Ch10 Answers Ch11 Ans. 10.1 10.2 10.3 10.4 11.1 11.2 11.3 Paired Paired Low Paired_Upper Pooled Pooled LOWE + Ready 100%