1. Thirteen students entered the undergraduate business program at a certain college 2 years ago. The following table indicates what their grade-point ayerages lGPAs] were after being in the program for 2 years and what each student scored on the SAT maximum [highest score is 2400] when he or she was in high school. GPA \"-_ 1443 - - - -_\" a. Show the scatter plot for this set of data. Does the scatter plot show a linear pattern? b. Obtain the estimated linear regression equation by computing b1 and be. Show your solution. Interpret the regression equation. c. Using the estimated linear regression equation obtained in part b, predict a student's GPA if the SAT score is 125D. What about a student who scores 23?5? d. Perform regression analysis in Excel. Paste a snippetfscreenshot of the output. e. What is the value of the coefficient of determination? Interpret this yalue- 2. The operations manager of a musical instrument distributor feels that demand for a particular type of guitar may be related to the number of YouTube views for a music video by a popular group during the preceding month. The data collected is presented in the table. YouTube views . . I r | 30 T0 50 a. Graph the data to check if a linear equation might describe the relationship between the views in TouTube and guitar sales. Find the least squares regression for this data. Using the regression equation, predict guitar sales if there were 45,000 views last month. d. Compute SST, SSE, SSH and R squared using the equations presented in Module 2 part 1. Interpret the value of Ft squarecl. e. Check if the assumptions of linearity, normality and equality of variances are satised using the residual plots generated from Excel. Interpret. in?"