A power company located in southern Alabama wants to predict the peak
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

A power company located in southern Alabama wants to predict the peak

Assignment 3

40. A power company located in southern Alabama wants to predict the peak power load (i.e., the maximum amount of power that must be generated each day to meet demand) as a function of the daily high temperature (X). A random sample of summer days is chosen, and the peak power load and the high temperature are recorded each day. The file P10_40.xlsx contains these observations.

a. Create a scatterplot for these data. Comment on the observed relationship between Y and X.

b. Estimate an appropriate regression equation to predict the peak power load for this power company. Interpret the estimated regression coefficients.

c. Analyze the estimated equation’s residuals. Do they suggest that the regression equation is adequate? If not, return to part b and revise your equation. Continue to revise the equation until the results are satisfactory.

d. Use your final equation to predict the peak power load on a summer day with a high temperature of 100 degrees.

Hint
Statistics"b) Coefficients Standard Error t Stat P-valueIntercept -47.39350416 15.66766046 -3.024925404 0.0060267Daily High Temperature 1.97645819 0.177619152 11.12750605 9.81686E-11 Regression equaiton: peak load = -47.3935 + 1.9764*daily high temperature "...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.