USING EXCEL..

4.2 Consider the following scatterplot: 7 6 5 4 y 3 2 1 0 0 1 2 3 4 5 6 4.3 Using simple linear regression analysis, the equation for a line through the data is estimated to be = 1.9 + 0.55x. For each of the x values, calculate the observed y, the predicted y, and the residual. For the following four regression equations, explain what the slope and intercept mean. a. wage == 2.05 + 1.32education, where wage is dollars earned per hour and educa- tion is number of years the person went to school. b. GPA 1.14 + 0.23hours study, where GPA is measured in points and hours study is the number of hours spent studying in a week. c. sleep 10.33 - 0.44work, where sleep is hours spent sleeping per night and work is the number of hours worked per day. d. savings = 586 + 0.15 salary, where savings is dollars saved in the bank and the salary is the number of dollars earned in a year. 4.5 For the following four regressions, predict the value of the y variable for the value of the x variable given. a. wage 2.05 + 1.32education, where wage is dollars earned per hour and educa- tion is number of years the person went to school. Predict the wage if a person has 15 years of education. b. GPA 1.14 + 0.23hours study, where GPA is measured in points and hours study is the number of hours spent studying in a week. Predict the GPA for a student who studies 11 hours a week. c. sleep = 10.33 - 0.44work, where sleep is hours spent sleeping per night and work is the number of hours worked per day. Predict the amount of sleep a person gets a night if they work 7 hours a day. 4.2 Consider the following scatterplot: 7 6 5 4 y 3 2 1 0 0 1 2 3 4 5 6 4.3 Using simple linear regression analysis, the equation for a line through the data is estimated to be = 1.9 + 0.55x. For each of the x values, calculate the observed y, the predicted y, and the residual. For the following four regression equations, explain what the slope and intercept mean. a. wage == 2.05 + 1.32education, where wage is dollars earned per hour and educa- tion is number of years the person went to school. b. GPA 1.14 + 0.23hours study, where GPA is measured in points and hours study is the number of hours spent studying in a week. c. sleep 10.33 - 0.44work, where sleep is hours spent sleeping per night and work is the number of hours worked per day. d. savings = 586 + 0.15 salary, where savings is dollars saved in the bank and the salary is the number of dollars earned in a year. 4.5 For the following four regressions, predict the value of the y variable for the value of the x variable given. a. wage 2.05 + 1.32education, where wage is dollars earned per hour and educa- tion is number of years the person went to school. Predict the wage if a person has 15 years of education. b. GPA 1.14 + 0.23hours study, where GPA is measured in points and hours study is the number of hours spent studying in a week. Predict the GPA for a student who studies 11 hours a week. c. sleep = 10.33 - 0.44work, where sleep is hours spent sleeping per night and work is the number of hours worked per day. Predict the amount of sleep a person gets a night if they work 7 hours a day