Height 157.5 163.0 167.0 170.0 183.5 161.0 174.5 159.5 167.0 179.0 180.0 166.5 180.0 163.0 185.0 158.0 161.5 163.5 165.0 176.5 172.5 152.5 164.0 188.0 170.0 162.5 170.0 152.5 170.0 156.0 162.0 161.5 163.0 164.0 173.0 173.0 166.0 183.0 179.0 168.0 182.0 167.0 172.0 164.0 170.0 167.5 171.5 188.0 168.0 168.0 157.5 178 166.5 170.0 178.0 166.0 157.5 176.0 167.0 174.0 163.0 160.0 169.0 168.5 178.0 152.5 162.5 188.0 175.0 183.0 178.0 162.0 174.0 167.0 167.5 164.0 188.0 175.0 162.5 175.5 174.0 160.0 163.0 170.0 171.5 173.0 163.0 157.0 163.0 149.0 190.5 170.0 152.5 157.5 182.0 174.0

Armspan 158.0 158.5 170.0 159.0 188.5 159.0 180.0 155.0 160.0 180.5 188.5 172.5 178.0 158.5 185.6 155.0 157.5 161.5 162.0 159.0 177.5 155.0 170.0 175.0 178.0 162.5 162.0 154.0 177.5 171.5 162.0 148.0 159.0 166.0 171.0 174.0 166.5 185.0 181.0 162.0 195.5 163.0 172.0 162.5 170.0 167.5 181.0 190.0 167.0 170.5 142.0 183.0 162.5 164.0 178.0 176.0 150.0 176.0 167.0 176.0 170.0 159.0 169.0 172.5 177.0 146.0 153.0 188.0 180.0 183.0 183.0 162.0 176.0 170.0 167.5 178.0 185.5 177.0 165.0 160.0 169.0 163.0 162.0 170.0 156.0 169.0 167.5 156.0 160.0 158.0 191.0 162.0 154.0 165.0 190.0 167.0

2. We wish to be able to see if we can reasonably predict an adult's height by knowing armspan measurement. Complete the following in regard to the Height and Armsnan factors in the data set: a. In the region to the right, produce a scatterplot of the Height versus Armspan data (remember this malls Armspan runs along the horizontal axis as the independent variable and Height along the vertical axis as the dependent variable.) Adjust your horizontal and vertical scaling to keep the primary.r focus of the graph to the region in which the points he. Label the axes and make a descriptive title to the display. For help, see Unit 3 Excel Guide (Part 2). Based upon your scatterka-t, briey discuss below your thoughts on whether the 'Wl'isual" trend between the individuals' height and armspan appears linear, curvilinear, or has no general trend at all. h. Complete the following: i_ Inchlde the trend line's graph and equation (least squares line) on the scatterpbt created in part a. Give the line's equation below and explain within this context what the "I " and "y " variables represent in the equation. ii_ Below, explicitly state the slope ofyour trend line and discuss what the value ofthe slope signies in terms ofthis context