I need help with d and e please. 2. Given the following data:X number of inventorsin companyY number of patents5.08.012.015.017.019.021.01.42.75.67.17.88.38.8a.Use Excel to make a scatter plot and include the trend line. Tape your diagram below.Remember to add title and axis labels.b. Use Excel to calculate the correlation coefficient r.Ans.c.Find the equation of the least squares line.Ans.d. Use Excel to find the coefficient of determination r?.Ans.e. What % of the variation can be a) explained by the variation between the y values and thevalues of the least squares line? b) What % is unexplained?Ans. aAns. b

We are given with the data from that we can calculate R2 i.e. Coefficient of determination The Explained Variation is given by the value of and the unexplained variation is given by (1-R2) Therefore for finding the coefficient of determination R2 first find 'r' i.e. correlation coefficient then square that and multiply it by 100 so as to convert it into percentage. For finding r we use the following formula r=n×∑xy-∑x∑yn×∑x2 -∑x2-n×∑y2 -∑y2 Putting the values of X and Y we get the following table X Y X*Y X2 Y2 4 1.4 5.6 16 1.96 5 2.7 13.5 25 7.29 8 5 40 64 25 12 5.6 67.2 144 31.36 15 7.1 106.5 225 50.41 17 7.8 132.6 289 60.84 19 8.3 157.7 361 68.89 21 8.8 184.8 441 77.44 SUM=101 SUM=46.7 SUM=707.9 SUM=1565 SUM=323.19 Therefore from the above table we see that ∑X=101∑Y=46.7∑XY=707.9 ∑X2=1565∑Y2=323.19 Now putting all the values into the formula we get r=8*707.9-10146.78*1565-1012-8*323.19-46.72 r=0.977105r2=0.954734 Therefore R2=100×r2=95.47 which is the answer for part (d). For (e) part: The Explained Variation is 95.47% And unexplained variation is 1-r2=0.045266 which is 4.52% Therefore answer for (e) part (a) is 95.47%. And for (e) part (b) is 4.52%. Hence the final answer are as follows: Answer for (d) is 95.47. And for (e) is (a)95.47% and (b)4.52%.