Math 20900 - Assignment 2 Instructions Please upload a report of your solutions (as .pdf or .docx file) AND the excel file(s) you used to Blackboard > Assignment 2. Do not email me your assignment. 1. The file bivar.xls (see math209files/data folder) contains 400 computer generated bivariate data points labeled x and y. (a) Construct a scatter plot of the data. Include the regression line and R2 value. (b) Fill in the second row of the following table using the regression equation. Carry out the computations in Excel using suitable formulas. x 1 2 3 4 5 6 7 8 9 empirical estimate for (c) Fill in the third row by computing average y values using only data points whose x value is near the number in row 1. For example, for x = 1 you might estimate the regression value y from the data using the average of all y values for which the corresponding x is between 0.5 and 1.5. (Note: You may want to copy the data set onto a blank worksheet before manipulating it.) (d) Should the values in row 3 be close to the values in row 2? Explain. Would you consider your results in line with these expectations? Hint: Use Regression Property 9.1 and Regression Property 9.2 on pages 161 and 162