Mathematics Homework Solutions
Problem
#60448

The following table shows the daily high temperature and maximum market price for electricity during 7 days this last summer. Using the data in the table calculate the regression equation, including the slope and intercept terms, R squared, and the SE of

The following table shows the daily high temperature and maximum market price for electricity during 7 days this last summer.  Using the data in the table calculate the regression equation, including the slope and intercept terms, R squared, and the SE of the regression (SE of the estimate).  Based on your results, how well does temperature explain changes in price?  How are the two variables mathematically related?  How might you use your regression to forecast the price for electricity?
Temp. Prices
70 45
75 48
80 42
85 55
90 63
95 94
100 105


Solution Summary

The solution provides detailed explanations and calculations, including plots in Excel format. It also includes step-by-step instructions for the problem.

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
  • Plain text response
  • Attached file(s):
    • regression-price of electricity -temperature.xls
    • regression - standard error.doc
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Linear Regression - Hello. I am having problems with the Table questions. I was able to accomplish half of the work. I was able to do it on excel, but I want to be able to do them manually, and show how I was able to get ...
  • Equation of the Regression Line - Find the equation of the regression line. X|12 14 10 9 15 8 _____________________ Y|29 35 28 23 36 18
  • Regression Analysis and Correlation Coefficient - An electric utility wishes to examine the relationship between temperature and electricity use in its service region during the summer months. The bivariate data below give the maximum temperature (de ...
  • Linear Regression Equations : 3 Equations, 3 Unknowns - How do you go mathamatically from eq. 12.4 to eq. 12.5 when solving three equations with three unknowns given the summation rules on page 460? Please show all steps of the mathamatical work by hand wi ...
  • Equations of Regression Lines - Find the equation of the regression line. X|10 8 7 12 14 5 ___________________ Y|20 19 17 25 28 9
Browse