The Edison uses MAX temperature in fahrenheit (oF) day of forecast local daytime consumption electricity in 1000 KWH. Research manager gather information these 2 variables over 20 day period

a. Give the least square regression line: Y= bo+ b1X

b. What proportion of the variation in the electricity consumption is explained by temperature? Is the model significant at 0.05 level significance

C. Describe assumption regard the error term in the regression model. Explain why

D. Provide 95% confident interval b1, the slope of the regression line. What its meaning?

E. Provide 95% confident interval average daytime consumption of electricity in the area on the days MAX temperature 80 oF

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 A A ab % " Conditional Formatting v Format as Table Paste BIUV OvAv Number Cells Editing Analyze Cell Styles v Data C2 X V fx |71 A B C D E F G H K L M N O P Day Electricity Usage Temperature 1 10.9 71.0_ 11.4 73.0 12.1 74.0 12.8 74.0 13.6 80.0 13.4 31. 15.2 90.0 14.1 87.0 13.0 75.0 12.8 76.0 12.5 72.0 12.2 71.0 15.6 87.0 13.4 85.0 13.9 83.0 16 12.5 4. 17 2.4 71.0 18 13.0 75.0 19 11.3 73.0 20 12.8 78.0 35 36 38 39 40 41 42 43 44 Q1-Edison Q2-TV News Q4-Six-pack Q5-Statistics Q6-Facebook + Ready 12 Accessibility: Good to go - + 100%