Excel Data and Worksheet for Assignment 9- Due 11192023

Assignment # 9 - For full credit, submit BOTH this template worksheet ( worth # 2 ( Chi-square, Goodness-of-Fit test ( similar to the Try-It problem # 11.2 of the Open St a) Hypotheses: Null: Students do homework equally throughout the week, and they fit a uniform distr Alternative: Students do not do homework equally throughout the week, and they do not fit if n =105 and uniform, Differences Day Observed Values ( O ) Expected Values ( E ) O-E Number Sunday 32 15 17 per day Monday 4 15 -11 Tuesday 7 15 -8 Wednesday 9 15 -6 df = 6 Thursday 12 15 -3 Friday 16 15 1 Saturday 25 15 10 and then your p-value use the CHISQ.DIST.RT function NOTE: "X" is your Sum from the table above NOTE: Deg_freedom = n-1 p-value = would expect = 105/7 = 15 per day b) Calculate your chi-square X 2 statistic

c) Make a Decision ( compare your p-value with your pre-set alpha value ) d) Make a Conclusion, ( as a sentence, in regard to students doing their homework equa use the CHISQ.DIST.RT function NOTE: "X" is your Sum from the equation above NOTE: Deg_freedom = n-1 p-value = c) Make a Decision ( compare your p-value with your pre-set alpha value ) d) Make a Conclusion, ( as a sentence, in regard to the variance of waiting times in a doc # 8, Extra-Credit ( up to + 2 points ) Data: number of pages cost of textbook # 3 Test of a Single Variance ( refer to section 11.6 and as similar to practice problems # 6 a) Using the test of a single variance equation, b) From your chi-square X 2 statistic value, now find your p-value:

140 $85.87 256 $123.55 45 $8.52 613 $275.75 350 $112.25 194 $43.45 75 $45.21 585 $178.69 158 $35.68 b) Graph a Scatterplot 600 $201.25 209 $65.75 450 $132.89 500 $145.87 731 $242.58 315 $99.99 824 $236.34 710 $257.54 365 $135.33 167 $41.75 430 $177.56 268 $135.20 585 $215.36 378 $175.68 647 $225.89 341 $150.00 430 $190.23 175 $55.49 243 $88.69 648 $185.24 186 $85.99 235 $87.68 753 $254.21 450 $167.99 386 $155.62

280 $118.49 100 $63.15 225 $212.50 123 $47.83 550 $190.24 462 $185.24 675 $228.69 845 $275.25 524 $194.23 430 $75.32 715 $213.89 803 $263.24 684 $218.25 758 $275.36 112 $22.71 475 $175.29 x y ( new y ) ( new y ) number of pages cost of textbook x 2 Std dev x 2 std dev ( - ? ) ( + ? ) 140 $85.87 256 $123.55 G) Graphical Process for Identifying\Removing 3 Outliers

45 $8.52 613 $275.75 350 $112.25 194 $43.45 75 $45.21 585 $178.69 158 $35.68 600 $201.25 209 $65.75 450 $132.89 500 $145.87 731 $242.58 315 $99.99 824 $236.34 710 $257.54 365 $135.33 167 $41.75 430 $177.56 268 $135.20 585 $215.36 378 $175.68 647 $225.89 341 $150.00 430 $190.23 175 $55.49 243 $88.69 648 $185.24 186 $85.99 235 $87.68 753 $254.21 450 $167.99 386 $155.62 280 $118.49 100 $63.15 225 $212.50 123 $47.83