For full credit, show all Excel outputs (such as tables and charts). You will need the Excel Add-in, the Data Analysis ToolPak. See instructions in video in the unit's D2L under the Excel homework assignment. The Environmental Protection Agency (EPA) wants to determine whether there is a difference in mean mileage for heavy-duty trucks driven on highways versus trucks driven in town. The EPA believes that mean highway mileage will be greater than town mileage (miles per gallon). To test this theory, the EPA gathers data from 30 randomly selected trucks to drive on the highway and another 30 trucks to drive in town. Volunteers are asked to drive the trucks and calculate miles per gallon. Answer the following questions to test the EPA's hypothesis using the data in Table 1. City and Highway Mileage for Heavy Duty Trucks1. What is the null and alternative hypothesis for this problem? If you can type the equations, great! If not, you can use words such as null, alternative, less than, greater than and equal to, and mu, and muz. 2.a Run Descriptive Statistics. Column1 Column2 Click on Data Click on Data Analysis (top, right-hand side of your screen. You might have to add it in, Excel Add-ins. Mean 19.9785 Mean 17.220267 Click on Descriptive Statistics Standard Er 0.7080017 Standard Er 0.666715 Click on Input Range (Do not include column headings) Median 20.3335 Median 16.9105 Click on Summary Statistics Mode #N/A Mode 16.5 Specify that the output goes into cell S21. Standard Di 3.8778853 Standard Di 3.6517484 Click OK Sample Var 15.037994 Sample Var 13.335266 Kurtosis -0.0642173 Kurtosis -0.340009 2.b What is the mean of highway mileage? In two decimal places. 19.98 Skewness 0.2387795 Skewness -0. 109962 Range 15.51 Range 14.652 2.c What is the mean of city mileage? In two decimal places. 17.22 Minimum 13.497 Minimum 9.053 Maximum 29.007 Maximum 23. 705 3. Make a Box and Whisker Plot of your Data. Sum 599.355 Sum 516.608 Highlight your 2 columns, including the headings. Count 30 Count 30 Click on Insert Click on Recommended Charts under Chart Group Click on All Charts (top row tab) Click on Box and Whisker Click OK More your chart: Put the top left corner of your Box and Whisker plot in cell S30. Right-click on your chart to access the editing functions denoted by a + on the outside of chart, to the right. Give your chart a title. Give your chart a legend, that say which box is which, the highway mileage or city mileage. Label your y-axis.Table 1. City and Highway Mileage for Heavy: Dug! Trucks Highway (2.) City Mileage Mileage 1 21.78 16.50 2 17.48 20.51 3 24.18 18.54 4 21.66 14.85 5 25.30 9.05 6 27.52 15.47 7 13.50 18.28 8 16.50 18.50 9 22.50 13.75 10 18.32 15.21 1 1 20.06 12.10 12 15.66 18.25 13 14.63 1 1.00 14 18.80 15.58 15 19.70 23.05 16 13.78 19.44 17 20.60 20.45 18 21.32 23.65 19 18.90 14.77 20 21.49 23.71 21 21.66 17.28 22 21.47 21.24 23 29.01 20.60 24 22.73 13.60 25 22.29 16.50 26 17.35 19.80 27 13.75 14.30 28 17.05 16.54 29 17.82 19.80 30 22.55 14.30 Maximum 29.007 3. Make a Box and Whisker Plot of your Data. Sum 599.355 Highlight your 2 columns, including the headings. Count 30 Click on Insert Click on Recommended Charts under Chart Group Click on All Charts (top row tab) Click on Box and Whisker Click OK More your chart: Put the top left corner of your Box and Whisker plot in cell $30. Right-click on your chart to access the editing functions denoted by a + on the outside of chart, to the right. Give your chart a title. Give your chart a legend, that say which box is which, the highway mileage or city mileage. Label your y-axis. The Box and Whisker plot should show that each data set has about equal variances, distance between Q1 to median, and median to Q3 are about equal. See page 422, the box and whisker plots should show that the distributions are not skewed, so we can assume that the populations are normally distributed and therefore you can use the following hypothesis test. In actuality, variances of the two datasets are not equal, but close enough! 4. Run a t-Test in Excel. Click on Data Click on Data Analysis Click on t-Test: Two-Sampled Assuming Equal Variance Fill in data for 2 data sets, do not include column headings. Specify a alpha = 0.10 Specify output for cell $50. 4.a. What is the t Stat? (test statistic) Answer in 2 decimal places. 4.b. What is the t Critical one-tail? (t critical value) Answer in 2 decimal places. 4.C. What is your decision rule? Reject or Do not reject your null hypothesis? 4.d. Explain why you rejected or did not reject the null hypothesis (in your own words).4.e. What conclusion can you make about the population means of city vs. highway mileage (in your own words)