General Instructions: Please place your name above, then complete the following questions a feel for the activity before continuing. Make sure to save this Excel file often using the filen submit your answers to this activity by attaching your Excel file through the completion link i Blackboard. Use the area to the near right in this Excel worksheet when calculating any statis values in Excel and reach conclusions must be shown in the spreadsheet in order to receive fu Overview: In this activity, you will first review graphing qualitative data from Unit 1 and then also population from sample data. Next you will apply your understanding of Correlation/Lin to actual data. The clean class data is given to the right. (Notice that the data is \"paired you must rearrange all the corresponding row values in the other columns in that same w age data with another person's height measure.) We will again assume this data came fro we know this to not be true. As in all previous activities, use of Excel in calculating and 1. Complete the following in regard to the hair color category of the data set: a. In the region to the right, make an appropriately labeled frequency table in ignore all other variables in the data set except hair color). Next, extend th column. Finally, create a bar chart graphic from the frequency table. b. Directly below, create a statement about \"hair color\" that the statistical ana this statement is only to be made based on the sampled students' data for th c. Next, create ANY new statement/claim about \"hair color\" in regard to all s the information in the bar chart). Then, briefly discuss whether the chart p process would be required to measure statistically whether or not the claim evidence? Next, create ANY new statement/claim about \"hair color\" in regard to all s the information in the bar chart). Then, briefly discuss whether the chart p process would be required to measure statistically whether or not the claim evidence? 2. Complete the following in regard to the height and armspan variables of the data a. In the region to the right, produce a scatterplot of the armspan versus heigh horizontal axis as the independent variable and armspan along the vertical scatterplot, briefly discuss below your thoughts on whether the \"visual\" tre appears linear, curvilinear, or has no general trend at all. b. Complete the following: i. Include the trend line's graph and equation on the scatterplot explain within this context what the "x" and "y" variables rep ii. Below, explicitly state the slope of your trend line and discuss context. c. Determine the value of the correlation coefficient (r) for this paired data. E variables. Determine the value of the coefficient of determination (r^2) for regarding these two variables. d. Using the predicition equation from part bi. above, predict the armspan of a e. Finally, critique the statement \"since the correlation coefficient is moderate one to have a longer armspan.\" Specifically address the issue of \"causation NAME: mplete the following questions. NOTE: Read the entire document below to get Excel file often using the filename "yournameActivity7". Once complete, through the completion link in the Unit 3 Activity 7 assignment description in et when calculating any statistics/parameters. Methods/work used to calculate adsheet in order to receive full credit. data from Unit 1 and then also review the issues of making a claim about a understanding of Correlation/Linear Regression, as covered in Chapter 5 of the text, (Notice that the data is \"paired/collated\" so if you rearrange the order in one column, he other columns in that same way so that you don't, for example, mix one person's again assume this data came from a random sample of FHSU students even though , use of Excel in calculating and producing statistical measures is required. ategory of the data set: ately labeled frequency table in regard ONLY to the hair color data (for this portion, cept hair color). Next, extend the frequency table to include a relative frequency from the frequency table. air color\" that the statistical analysis from part a. supports or suggests. Remember the sampled students' data for the online course as shown in your work in part a. ut \"hair color\" in regard to all students at FHSU (this claim does not have to match efly discuss whether the chart proves or disproves your statement. Finally, what stically whether or not the claim you made here is supported/discounted by the sample armspan variables of the data set: plot of the armspan versus height data (remember this means height runs along the and armspan along the vertical axis as the dependent variable.) Based upon your ghts on whether the \"visual\" trend between the individuals' height and armspan al trend at all. and equation on the scatterplot created in part a. Give the line's equation below and hat the "x" and "y" variables represent in the equation. pe of your trend line and discuss what the value of the slope signifies in terms of this ficient (r) for this paired data. Explain what this value tells you regarding these two icient of determination (r^2) for this paired data. Explain what this value tells you . above, predict the armspan of an individual whose height is 170 cm. rrelation coefficient is moderately significant\" then this means that \"being tall causes y address the issue of \"causation\" in relation to statistical correlation. MATH 250- Elements of Statistics Class Data, Fall 2017---CLEANED Student Data Individual ID# Gender Foot Length Height Age 1 2 3 4 5 6 7 Female Male Female Male Female Female Female 24.0 25.0 25.5 29.0 28.0 23.0 24.5 160.0 172.5 170.5 185.0 174.5 168.0 157.0 31 20 28 27 38 38 21 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Female Male Female Female Female Female Female Female Male Female Female Male Male Female Female Male Male Male Female Male Male Female Female Female Female Female Male Female Female 21.0 30.5 23.5 23.0 23.0 23.0 24.0 20.0 26.0 24.0 24.0 26.0 27.5 23.5 24.5 25.5 27.0 26.0 25.5 25.5 29.0 23.0 25.0 24.0 24.0 24.0 30.5 24.0 25.0 152.0 187.5 157.5 165.0 166.0 152.5 165.0 163.0 178.0 162.5 164.5 184.0 183.5 161.5 157.5 179.5 175.0 185.0 170.0 186.0 180.0 148.0 172.5 167.5 168.0 159.0 185.5 164.0 166.0 21 29 22 21 32 35 34 20 34 23 22 40 32 29 22 33 40 31 40 20 47 39 23 22 20 32 33 27 26 37 Female 24.5 164.0 26 38 Male 24.0 179.0 33 39 40 Male Female 26.5 27.0 177.0 170.0 37 31 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 Female Female Female Female Female Female Female Female Female Male Female Male Female Male Female Female Female Male Female Female Female Female Female Male Female Female Male Male Female Female Male Female Female Male 24.0 22.5 25.5 25.0 30.5 26.0 23.5 25.0 27.0 27.0 26.0 28.5 23.0 28.0 23.5 25.5 23.5 24.0 25.0 22.0 24.0 26.0 25.5 28.0 22.0 24.0 26.0 26.0 24.0 26.5 31.0 26.0 23.0 28.0 170.0 161.0 171.5 158.0 176.5 158.0 152.5 182.0 167.5 180.0 178.0 178.0 165.0 183.0 170.5 170.0 170.0 160.0 169.5 151.5 159.0 162.5 170.0 181.0 154.0 180.0 178.5 178.0 162.5 165.0 178.0 176.0 160.0 177.0 29 39 24 44 36 22 21 24 27 37 26 31 31 27 22 27 42 46 22 34 40 21 28 27 23 31 35 37 31 48 21 21 23 38 istics ANED Student Data Number Armspan in Family Hair Color 159.0 177.5 174.0 192.5 183.0 168.0 153.0 3 2 4 3 5 3 4 Red Blonde Brown Brown Brown Red Blonde 151.0 190.0 160.0 163.0 160.0 160.0 165.0 153.0 175.5 170.5 160.5 169.0 183.0 157.5 150.0 184.5 175.0 179.0 169.0 188.0 180.0 150.0 170.5 162.5 169.0 157.0 193.5 168.5 169.0 8 5 5 2 3 6 6 4 2 4 5 3 2 5 3 6 4 3 5 4 7 5 6 3 3 8 4 5 3 Brown Black Blonde Red Brown Brown Blonde Blonde Black Brown Red Brown Brown Brown Brown Brown Brown Brown Brown Brown Black Brown Brown Brown Red Brown Brown Blonde Brown 165.0 3 Brown 160.0 3 Black 180.0 166.0 6 6 Brown Red 155.0 165.5 142.0 167.0 198.0 160.0 152.5 177.0 167.0 173.0 175.0 185.5 167.0 193.0 172.0 170.0 150.0 165.0 164.5 156.5 161.5 162.5 165.5 182.5 142.0 178.0 186.0 176.5 162.5 169.0 152.0 160.5 150.0 184.0 5 4 3 2 1 3 2 4 4 4 4 5 2 3 5 3 3 4 8 4 7 4 6 4 3 4 6 3 4 2 5 3 2 3 Brown Blonde Brown Brown Brown Brown Brown Brown Brown Black Brown Brown Brown Black Brown Brown Brown Black Blonde Brown Brown Black Brown Red Blonde Brown Brown Brown Blonde Brown Brown Brown Brown Black