Not sure how to do part D. How do you plot the 7 independent variables versus power demand?

Obs	Day	Temp	Demand
1	1	92	57.7
2	2	96	71.5
3	3	96	73
4	4	89	68.6
5	5	95	71.2
6	6	94	67.2
7	7	99	62.7
8	1	96	64.6
9	2	96	68.5
10	3	91	68.8
11	4	93	65.8
12	5	88	61.5
13	6	90	57.6
14	7	92	54.2
15	1	98	61.1
16	2	94	64.5
17	3	99	68.6
18	4	94	67.1
19	5	98	76.2
20	6	94	65.7
21	7	97	60.9
22	1	88	54.5
23	2	92	69.7
24	3	89	68.3
25	4	96	68.8
26	5	92	70.8
27	6	90	67
28	7	99	58.3

18. Duque Power Company wants to develop a regression model to help predict its daily peak power demand. This prediction is useful in determining how much generating capacity needs to be available (or purchased from competitors) on a daily basis. The daily peak power demand is influenced primarily by the weather and the day of the week. The file Duque.xlsx contains data summarizing Duque's daily peak demand and maximum daily temperature during the month of July last year. Build a simple linear regression model to predict peak power demand using maximum daily temperature. What is the estimated regression equation? b. Prepare a line chartplotting the actual peak demand data against the values pre- dicted by this regression equation. How well does the model fit the data? c. Interpret the R statistic for this model. d. Build a multiple linear regression model to predict peak power demand using maximum daily temperature and the day of the week as independent variables. (Note: This model will have seven independent variables. What is the estimated regression equation? e. Prepare a line chart plotting the actual peak demand data against the values pre- dicted by this regression equation. How well does the model fit the data? f. Interpret the R statistic for this model. & Using the model you developed in part d, what is the estimated peak power demand Duque should expect on a Wednesday in July when the daily high tem- perature is forecasted to be 94? h. Compute a 95% prediction interval for the estimate in the previous question Explain the managerial implications of this interval for Duque