LAB 5: REGRESSION ANALYSIS (ASSIGNMENT) NAME Note: you will need to complete both written work on this assignment in addition to work on your Excel template file. Be sure you turn in both after finishing your lab for full credit. Problem 1. (In Excel, 12 points) Be sure you have followed along and completed the work in the Excel template during the examples covered in lab. Problem 2. The college GPAs of 20 mathematics majors and their score received on the mathematics portion of the ACT are listed in the Problem 2 tab of your Excel template. a) (In Excel, 2 points) Make a scatter plot for GPA vs. ACT scores for these 20 students. Be sure to label your axes and title your chart. Additionally, change the minimum values on the axes to 20 for ACT score and 1.5 for GPA to get a better view of the data. b) (In Excel, 2 points) Add a (linear) trendline to your data. Be sure to display both the R2 value and equation for the trendline on your graph. c) (2 points) According to our model, wha