closer photo

Excel

DATAfile: 2012FuelEcon A statistical program is recommended. The Department of Energy and the U.S. Environmental Protection Agency's 2012 Fuel Economy Guide provides fuel efficiency data for 2012 model year cars and trucks. The file named 2012FuelEcon provides a portion of the data for 309 cars. The column labeled Mar column labeled Fuel shows the required or recommended type of fuel (regular or premium gasoline); the column labeled Drive Identifies the type of drive (F for front wheel, R for rear wheel, and A for all-wheel); and the column labeled Hwy MPG shows the fuel efficle (a) Develop an estimated regression equation that can be used to predict the fuel efficiency (in mpg) for highway driving given the engine's displacement. (Let x, represent the engine's displacement and y represent fuel efficiency. Round your numerical values to o Test for significance using a = 0.05. (Use an F test.) State the null and alternative hypotheses OHO P , 20 OHOP, SO Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value - State your conclusion. O Do not reject Ho. There Is Insufficient evidence to conclude that there is a significant relationship. Do not reject Ho. There Is sufficient ev conclude that there Is a significant relationship. O Reject Ho. There Is Insu ude that there is a significant relationship. Reject Ho. There Is sufficient evidence to that there is a significant relationship. (b) Consider the addition of the dummy variable Fue remlum, where the value of FuelPremium is 1 If the required or recommended type of fuel is premium gasoline and 0 if the type of fuel is regular gasoline. Develop the estimated regression equation that can be used the engine's displacement, x, represent emlum, and y represent fuel efficiency. Round your numerical values to one decimal place.) (c) Use a = 0.05 to determine whether the dummy variable added in part (b) Is significant. State the null and alternative hypotheses Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value- State your conclusion. Do not reject Me. There Is Insufficient evidence to conclude that FuelPremium Is a significant factor. Reject Ho. There is surf alum is a significant factor. Do not reject Ho- There is sufficient lude that FuelPremium is a significant factor. O Reject Ho. There Is Insumde um is a significant factor. Consi addition of the dummyx Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check A1 4 X V fx | Manufacturer R B C D E F G 18 Ford Motor Compa 2.0 Regular F 38 19 Ford Motor Compa 20 Regular F 37 20 Ford Motor Compa 2.0 Regular F 36 21 Ford Motor Compar 2.0 Regular F 38 22 Ford Motor Compa 2.0 Regular F 36 23 Ford Motor Compa 2.0 Regular F 40 24 Ford Motor Compai 2.0 Regular F 40 25 General Motors 2.4 Regular F 32 26 General Motors 1.4 Regular F 37 27 General Motors 1.4 Regular F 40 28 General Motors 1.8 Regular F 35 29 General Motors 1.8 Regular F 35 30 Honda 2.4 Regular F 33 31 Honda 2.4 Regular F 32 32 Honda Regular F 39 33 Honda 1.8 Regular F 36 34 Honda 1.8 Regular F 41 35 Honda 1.5 Regular F 44 36 Honda 1.3 Regular F 44 37 Honda 1.3 Regular F 44 38 Honda 2.4 Premium F 31 39 Honda 2.4 Premium F 29 40 Honda 2.4 Premium F 31 41 Hyundai Regular F 40 42 Hyundai 1.6 Regular F 40 43 Hyundai 1.6 Regular F 38 44 Hyundai 1.6 Regular F 40 45 Kia 2.0 Regular F 34 46 Kia 2.0 Regular F 33 47 Kia 2.4 Regular F 31 48 Kia Regular F 32 49 Kia 1.6 Regular F 40 50 Kia 1.6 Regular F 40 51 MAZDA 1.5 Regular F 34 $2 MAZDA Regular F 35 53 MAZDA 2.0 Regular F 33 54 MAZDA 2.0 Regular F 33 $5 MAZDA 2.5 Regular F 29 56 MAZDA Regular F 28 $7 MAZDA 2.0 Regular F 40 58 MAZDA 2.0 Regular F 39 59 Mercedes-Benz Premium R 31 60 Mitsubishi Motors 2.0 Regular F 34 61 Mitsubishi Motors 2.0 Regular F 34 62 Mitsubishi Moto Regular F 30 63 Mitsubishi Motors Regular F 31 64 Mitsubishi Motors Regular A 29 65 Mitsubishi Motors 2.0 Premium A 66 Mitsubishi Motors 2.0 Premium A 67 Mitsubishi Motors Premium A 68 Nissan 1.6 Regular F 38 69 Nissan 1.6 Regular F 36 70 Nissan 1.8 Regular F 32 71 Nissan 1.8 Regular F 72 Nissan 1.8 Regular F 31 73 Subaru 2.0 Regular A 36 74 Subaru 2.0 Regular A 34 75 Subaru Premium A 25 76 Subaru 2.5 Premium A 77 Suzuki 23 2.4 Regular F 30 78 Suzuki 2.4 Regular F 79 Suzuki 29 2.4 Regular F 31 80 Suzuki 2.4 Regular F 81 Suzuki 31 2.0 Regular F 82 Suzuki 32 2.0 Regular F 83 Suzuki 33 2.0 Regular F 84 Suzuki 30 2.0 Regular F 85 Suzuki 32 Regular A 86 Suzuki 29 2.4 Regular A 30 87 Toyo Drive Sheet2 Sheet3 + Ready