Math business statistics

I'll: luuuu... \"mu... ._._.- J .. [E \" eaggsnggia A A. A3 ., A0 - .. ....m,,,__ 2 PaStegl B I Uvabxzx AV'ZVAV Zlipboard El Font S -__.,_-___Psre9_raph Q1. The Wall Street Journal studied four National Football League games during a recent season to determine the number of minutes of actual playing time that occurred during a 3-hour game. Surprisingly (at least to me), the average playing time was only 10.7 minutes per game! Assume the actual playing time per game follows the normal distribution with a standard deviation of 0.8 minutes. Use SPSS or Excel PHStat or any open soware to answer the following question. . Determine the probability that the actual playing time for the next game Will be between a. 9.8 and 11.9 minutes I b. 11.0 and 12.1 minutes ' . c. 9.7 and 10.3 minutes ' 415 marks) Q2. During the winter of 20172018, the average utility bill for Delaware residents was $186 per month. A random sample of 40' customers Was selected during the winter of 201 82019, .and the average bill was found to be $178.10 with a sample standard deviation of $22.40. (15 marks) 3. Using alpha = 0.05, does this sample provide enough evidence to conclude that the average utility b. bill in Delaware was lower in the winter of 20182019 than it was in the Winter of 2017-2018? I). Does changing the value of alpha om 0.05 to 0.01 affect your conclusion? Why or Why not? c. Use SPSS/PHStat [any open software to validate these results and to determine the p-value for this test. Q3. Walmart has an interest in monitoring the average back to school spending for grade-school students year to year. (20 marks) The following. table shows the average back-toschoo-l spending of households randomly sampled in 2013 and 2014 along with the population standard deviations and sample sizes for each sample. 2013 2014 Sample mean $606.40 $543.72 Sample size 35 38 Population standard deviation $60 $150 a. Perform ahypothesis test using alpha. =-0.10 to determine if the average household back-to-school To. Reading in 2013 was different than it was'in 2014.. b. Determine the pvvalue and interpret the results. c. Verify your result using SP'SS or Excel PHStat. or any open software. ramn ________ 346 words. B; English (United States) rit",Accessibility: Good to go