2. Complete the following in regard to the Armspan and Height factors in the data set: a. In the region to the right, produce a scatterplot of the Armspan versus Height data (remember this means Height runs along the horizontal axis as the independent variable and Armspan along the vertical axis as the dependent variable.) Adjust your horizontal and vertical scaling to keep the primary focus of the graph to the region in which the points lie. Label the axes and make a descriptive title to the display. For help, see Unit 3 Excel Guide (Part 2) and the video entitled: Chapter 5: How to Create and Analyze Scatterplots. Based upon vour scatterplot briefly discuss below vour thoughts on whether the "visual" trend between the individuals' b. Complete the following: i. Include the graph's trend line and equation (least squares line) on the scatterplot created in part a. Give the line's equation below and explain within this context what the "x" and "y" variables represent in the equation.ii. Below, explicitly state the slope of your trend line and discuss what the value of the slope signifies in terms of this context. c. Determine the value of the correlation coefficient (r) for this paired data. Explain what this value tells you regarding these two variables. Next, determine the value of the coefficient of determination ( 2) for this paired data. Explain what this value tells you regarding these two variables.d. Using the least squares linear prediction equation from part bi. above, predict the armspan of an individual whose height is 195 cm. Show work to the right. e. Finally, critique the statement "since the correlation coefficient is strong positive correlation" then this means that "being taller causes one to have a longer armspan." Specifically address the issue of "causation" in relation to statistical correlation.Height Age Armspan 145.0 36 143.0 180.0 41 184.5 161.5 29 163.0 160.0 48 161.5 170.0 36 172.0 183.0 27 182.0 172.5 21 172.5 142.0 23 145.0 180.0 23 180.0 172.5 50 179.0 182.5 21 180.0 159.0 29 160.0 168.0 28 166.5 159.0 33 157.5 160.0 23 156.0 179.0 42 184.0 189.0 28 187.0 162.5 37 163.0 181.0 24 174.0160.0 20 154.0 157.5 34 162.0 169.0 27 169.0 162.5 27 164.5 152.5 38 157.5 163.0 32 165.0 167.5 30 165.0 157.5 26 153.0 149.5 37 151.5 157.5 34 158.0 165.0 19 169.0 170.0 24 168.0 167.0 24 156.0 170.0 20 170.0 188.0 34 189.5 177.0 41 173.0 185.5 31 183.0 179.5 31 177.5 170.0 45 168.0 187.0 21 188.0163.0 28 164.0 181.0 38 183.0 166.5 29 169.5 178.0 34 176.5 167.0 18 167.0 150.0 24 153.0 177.5 39 175.0 169.0 19 170.0 172.5 22 173.5 169.0 25 172.0 160.0 27 160.0 170.0 37 165.5 155.0 27 153.0 155.0 20 157.5 162.5 23 160.0 170.0 21 171.0 183.0 28 180.0 154.0 33 154.0 172.5 18 173.0 160.0 32 165.0\f180.0 25 172.0 176.0 21 172.0 183.0 18 186.0 171.0 25 172.0 175.5 38 176.0 165.0 24 167.0 175.0 39 182.0 188.0 33 189.0 167.5 18 163.5 167.5 36 153.5 171.0 19 174.0 167.5 22 165.0 154.0 23 155.5 158.0 25 157.0