- 1 Consider The Following Data Measuring Weekly Fuel Consumption In Tons Dependent Variable Y Vs The Average Hourly Te 1 (54.61 KiB) Viewed 67 times
- 1 Consider The Following Data Measuring Weekly Fuel Consumption In Tons Dependent Variable Y Vs The Average Hourly Te 2 (24.17 KiB) Viewed 67 times
1. Consider the following data measuring weekly fuel consumption in tons (dependent variable y) vs the average hourly temperature (independent variable x). The data is also given in the accompanying Excel file. (25 points) a. Plot the data points. (5 points) b. What kind of relationship exists between the dependent variable and independent variable? (5 points) c. Create a second independent variable (x2:x-squared) and fit a multiple linear regression model on the data. (5 points) d. Estimate the regression parameters using the regression feature in Excel. (5 points) e. What is the expected weekly fuel consumption when the average hourly temperature is 30, 50, 70, 90 or 100 F? (5 points)
Sample Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Wkly Avg Hrly Fuel Temp. Consum (x) p. (v) 28.0 12.4 28.0 11.7 32.5 12.4 39.0 10.8 45.9 9.4 57.8 9.5 58.1 8.0 62.5 7.5 65.0 7.9 68.0 6.1 70.0 4.0 75.0 4.5 73.0 6.4 85.0 9.0 95.0 10.0 90.0 12.0 87.0 10.2 96.0 18.0 105.0 22.0 97.0 16.0 80.0 14.0 90.0 17.0 97.0 15.0