Share
Explore BrainMass

steps on performing simple regression

A uranium mining company has recorded its monthly profit and the average price of uranium for each month over a period of 24 months. The recorded data is in the attached file.

It is assumed that a simple linear regression will determine the relationship between the average monthly uranium price and monthly profit. The following values have been calculated:

SSxx= 707.1967 SSxy= 8435.9392 SSyy= 114003.8333
SSE= 13374.02264 x= 46.4496 y= 55.9167

Using the calculations given above:

i) Derive the simple linear regression for this data and explain the equation in
words.

ii) Assuming that the model is correct calculate the predicted monthly profit next
month if the average uranium price is assumed to be $59.

iii) Calculate the value r2 and explain what this value represents.

Please do not use excel functions - I would like to see clear workings and commentary for calculations

Attachments

Solution Preview

i) Derive the simple linear regression for this data and explain the equation in words. ...

Solution Summary

The solution gives detailed steps on conducting simple regression. All formula and calculations are shown and explained.

$2.19