Submit one Excel file and one word/pdf file:

oYour word or pdf file should include all answers and StatTools reports that are specifically asked for.

oYou Excel file should include all the StatTools reports.

Question 1 (14 points) A marketing company reported that the typical American spends a mean of 144 minutes per day accessing the Internet via a mobile device. In order to test the validity of this statement, you select a random sample of 30 individuals. The results for the time spent per day accessing the Internet via mobile device (in minutes) are stored in Times . xlsx. At the 5% significance level, is there evidence that the population mean time spent per day accessing the Internet via mobile device is greater than 144 minutes? a) b) d) (3 points) Specify the null hypothesis and the alternative hypothesis. Define the parameter of your interest and write the mathematical expressions of your hypotheses in terms of your parameter. (1 point) What test should be run? One or two-sample test? One or two tailed g? t- or 2 test? I: )sample,( )tailed, ( )- test. (6 points) Determine your decision using two methods: the critical value and the avalue approach. Conduct calculation by hand to compute the critical value and pvalue of the test. Please specify the Excel functions you use. (2 points) Use StatTools to conduct the hypothesis test. Copy and paste the report generated by StatTools. . (2 points) Provide the results of the test in \"plain English\" including the meaning of the p-value. 13 Times AutoSave OFF Data Tell me Insert Draw Page Layout Formulas Review View Home X Calibri (Body) 11 A A ab General $ ~ % 9 Paste BI UV v Av K6 X V fx K C D E F G H B 1 Minutes 72 144 48 72 36 360 8 44 9 30 10 432 11 24 12 288 13 144 14 144 15 240 16 432 17 144 18 144 19 144 20 576 21 216 22 72 23 72 24 144 25 288 26 144 27 36 28 288 29 48 30 288 31 144 32 33 Min +