PART 2 4Use Excel to estimate a simple regression model with

PART 2

4)Use Excel to estimate a simple regression model with happiness as the response variable and age as the explanatory variable.

5)Construct the simple regression model (the equation) and round to two digits after the decimal for the y intercept and slope.Use the estimates to predict happiness when age equals 25,50,75.(Show Work)

6)Construct another scatter plot using Excel with happiness against age. Discuss why your predictions might not be accurate ( this should be typed under the scatter plot print out).

Link to previous post:

http://www.chegg.com/homework-help/questions-and-answers/firstpart-thisquestion-answered-need-answer-second-part-comment-ll-add-links-pictures-coul-q9940605

Solution

(4)

(5)

(6)