Question

1. You are the owner of a floral delivery company and the fuel for your delivery vehicles is one of your biggest expenses. At the beginning of 2014 you introduced a new set of driving instructions to your drivers in the hopes of increasing the average MPG of your vehicles. The gas_example.xlsx file contains a sample of MPG observations for your fleet of vehicles from 2013 and 2014. Now you would like to know if your new driving instructions actually made a difference in average MPG. At the .05 level, is there a difference in the mean MPG between 2013 and 2014?

a. State the null and alternate hypotheses

b. Select alpha.

c. Select the test statistic.

d. Formulate the decision rule.

e. What is the value of the test statistic?

f. Determine and interpret the effect size and p-value.

g. Draw conclusions based on statistical and practical significance.

Here is the data you need

Fiscal Year 2013	Fiscal Year 2014
27.11	27.13
26.69	33.04
29.15	30.98
27.23	30.71
22.87	28.03
28.70	23.23
28.18	26.23
28.14	25.17
27.05	30.68
29.90	25.09
26.13	33.36
30.02	25.88
28.56	24.22
28.21	23.49
29.87	20.66
24.37	31.38
31.20	29.12
27.18	30.44
25.72	30.62
27.00	26.46
30.07	27.97
32.43	33.50
27.04	24.56
29.23	33.60
25.76	32.98
28.60	29.06
30.64	35.10
28.30	29.17
29.70	25.56
29.19	26.94
28.39	33.18

This is only part of the data it would not let me paste all of it but a solution is still possible with this snippet, Thanks!

Answer 1