Activity 7MATH 250 Elements of StatisticsSpring 2017 DUE DATE: 04/21/2017 General Instructions: Please place your name above, then complete the following questions. NOTE: Read a feel for the activity before continuing. Make sure to save this Excel file often using the filename "yournameA submit your answers to this activity by attaching your Excel file through the completion link in the Unit 3 Acti Blackboard. Use the area to the near right in this Excel worksheet when calculating any statistics/parameters. values in Excel and reach conclusions must be shown in the spreadsheet in order to receive full credit. Overview: In this activity, you will first review graphing qualitative data from Unit 1 and then also review the issues population from sample data. Next you will apply your understanding of Correlation/Linear Regression, a to actual data. The clean class data is given to the right. (Notice that the data is \"paired/collated\" so if yo you must rearrange all the corresponding row values in the other columns in that same way so that you do age data with another person's height measure.) We will again assume this data came from a random sam we know this to not be true. As in all previous activities, use of Excel in calculating and producing statist 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 regard ONLY to t ignore all other variables in the data set except hair color). Next, extend the frequency table column. Finally, create a bar chart graphic from the frequency table. b. Directly below, create a statement about \"hair color\" that the statistical analysis from part a s statement is only to be made based on the sampled students' data for the online course as sho c. Next, create ANY new statement/claim about \"hair color\" in regard to all students at FHSU the information in the bar chart). Then briefly discuss whether the chart proves or disproves process would be required to measure statistically whether or not the claim you made here is evidence? Next, create ANY new statement/claim about \"hair color\" in regard to all students at FHSU the information in the bar chart). Then briefly discuss whether the chart proves or disproves process would be required to measure statistically whether or not the claim you made here is evidence? 2. Complete the following in regard to the height and footlength categories of the data set: a. In the region to the right, produce a scatterplot of the footlength versus height data (rememb horizontal axis as the independent variable and footlength along the vertical axis as the depe scatterplot, briefly discuss below your thoughts on whether the \"visual\" trend between the in 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 created in part a. explain within this context what the "x" and "y" variables represent in the equa ii. Below, explicitly state the slope of your trend line and discuss what the value o context. c. Determine the value of the correlation coefficient for this paired data. Explain what this valu implies that there is/is not statistically significant correlation between the two variables of he need to use table A:6 from the text in answering the last portion of this question.) d. Using the predicition equation from part bi. above, predict the footlength of an individual wh e. Finally, critique the statement \"since the correlation coefficient is statistically significant\" the one to have a longer footlength.\" Specifically address the issue of \"causation\" in relation to NAME: wing questions. NOTE: Read the entire document below to get using the filename "yournameActivity7". Once complete, mpletion link in the Unit 3 Activity 7 assignment description in ting any statistics/parameters. Methods/work used to calculate r to receive full credit. and then also review the issues of making a claim about a Correlation/Linear Regression, as covered in Chapter 10 of the text, data is \"paired/collated\" so if you rearrange the order in one column, in that same way so that you don't, for example, mix one person's is data came from a random sample of FHSU students even though calculating and producing statistical measures is required. ata set: quency table in regard ONLY to the hair color data (for this portion, Next, extend the frequency table to include a relative frequency cy table. e statistical analysis from part a supports or suggests. Remember this data for the online course as shown in your work in part a. regard to all students at FHSU (this claim does not have to match her the chart proves or disproves your statement. Finally, what r not the claim you made here is supported/discounted by the sample ories of the data set: ngth versus height data (remember this means height runs along the ong the vertical axis as the dependent variable.) Based upon your he \"visual\" trend between the individuals' height and footlength the scatterplot created in part a. Give the line's equation below and " variables represent in the equation. ine and discuss what the value of the slope signifies in terms of this ired data. Explain what this value tells you and determine if it n between the two variables of height and footlength. (Recall the tion of this question.) he footlength of an individual whose height is 165 cm. ent is statistically significant\" then this means that \"being tall causes sue of \"causation\" in relation to significant statistical correlation. MATH 250- Elements of Statistics Class Data, Spring 2017---CLEANED Student Data Individual ID# Gender Foot Length Height Age Armspan 1 2 3 4 5 6 7 Male Male Female Male Female Male Male 27 25.5 24.5 28 23.5 28.5 33 169 205.5 158.5 190.5 157.5 183 193 27 32 45 32 24 33 34 175 189 159 198 142 174.5 190.5 8 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Female Female Female Female Female Male Female Male Male Female Female Female Female Female Female Female Female Female Female Female Female Female Male Female Male Female Male Female Male 23 25 25.5 24 26 29 21.5 28.5 27.5 24 23.5 25.5 24 21 21.5 20 25 23.5 21 22 23 23.5 28 24 28 24 30 23 27.5 155 165.5 160 168 171 193 165 179 183 172 165 167 163 162 177.5 166 170 165 157.5 156 162.5 173 182 170 165 172 188 160 180.5 20 19 23 29 33 46 31 39 44 33 32 34 28 21 22 26 26 32 39 25 23 30 41 32 14 36 21 29 30 166 158.5 173 167.5 171.5 193 171 188 186.5 173 157 150.5 163 155 171.5 160 162 161 157.5 155 170 172.5 182.5 151.5 173 157 201 160 181 38 Female 24 162.5 25 164 39 Female 28 167.5 26 168 40 41 Female Female 23 21.5 163 154 19 39 152 160 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 75 76 77 78 Male Female Male Male Female Female Male Female Female Female Male Female Female Male Female Male Female Female Male Female Female Female Female Male Female Female Male Male Female Female Male Male Male Female Female Male Female 30.5 24.5 25.5 27.5 24 23.5 33.5 24.5 23 25 28 23.5 19 28 24 28 21 24.5 28 27 30 22 26 26 23 23 27 23 22.5 23.5 30.48 32 29 24.5 27.94 26.5 23.5 186 172.5 183 190.5 166 169 182.5 165 161.5 178 183 160 153 178 180 184 156 165 185.5 148 193 159 185 183 165 162.5 168 173 164 160 183 185.5 184 155 171.5 179.5 165 33 24 19 21 37 32 27 32 26 34 39 29 25 27 21 28 23 20 26 40 19 31 45 29 27 26 29 40 22 19 21 41 27 41 41 25 26 190.5 172.5 177 191.5 176 167.5 181.5 171 163 170 190.5 162 194 180 180 185.5 168 165 201 152 193 159 169 179 164 162.5 175 160 160 155 178 180.5 186 154 170 184.5 160 D Student Data Number in Family Hair Color 4 10 1 6 5 5 3 Blonde Brown Blonde Brown Black Blonde Black 5 3 8 3 4 5 4 3 1 5 5 5 4 4 3 9 1 2 4 3 4 3 8 4 4 5 2 3 3 Brown Brown Brown Brown Brown Brown Brown Brown Brown Red Brown Brown Brown Brown Blonde Black Brown Brown Brown Red Red Brown Brown Red Brown Blonde Brown Brown Brown 3 Blonde 4 Brown 4 4 Brown Blonde 7 6 5 12 4 5 3 6 12 4 4 6 4 5 4 1 3 9 7 4 3 4 4 3 5 2 4 5 4 3 3 6 4 4 6 7 4 Brown Brown Blonde Brown Brown Brown Brown Blonde Brown Brown Brown Brown Blonde Black Blonde Brown Blonde Brown Blonde Black Blonde Blonde Blonde Brown Blonde Red Black Black Blonde Blonde Blonde Blonde Blonde Brown Brown Black Brown