Activity 7

B c D = B G H I J K L General Instructions: Please place yvour name above, then complete the following questions. NOTE: Read the entire document below to get a feel for the activity before continuing. Make sure to save this Excel file often using the filename "vournameActivity7." Once complete, submit vour answers to this activity by attaching your Excel file through the completion link in the Unit 3 Activity 7 assignment description in Blackboard. Use the area to the near right in this Excel worksheet when calculating any statistics/parameters. Methods/work used to calculate 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 of making a claim about a population from sample data. Next, you will apply your understanding of Correlation/'Linear Regression, as covered in Chapter 5 of the text, to actual data. The clean class data is given to the right. (Notice that the data is \"paired/collated\" so if vou rearrange the order in one column, you must rearrange all the corresponding row values in the other columns in that same way so that vou don't, for example, mix one person's age data with another person's height measure.) We will again assume this data came from a random sample of FHSU students even though we know this to not be true. As in all previous activities, use of the spreadsheet in calculating and oroducing statistical measures is required. r 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 the hair color data (for this portion, ignore all other variables in the data set except hair color). Next, extend the frequency table to include a relative frequency column. Use a fill handle to create the relative frequency column. Finally, create a bar chart graphic (NOT a histogram) from the frequency table, complete with title and labeled axes. b. Directly below, create a statement about \"hair color\" that the statistical analvsis from part a. supports or suggests. Remember this statement is only to be made based on the sampled students' data for the online course as shown in your Next, create ANY new statement/claim about \"hair color\" in regard to ALL students at FHSU (this claim does not have to match the information in the bar chart). Then, briefly discuss whether the chart proves or disproves vour statement. Finally, what process would be required to measure statistically whether or not the claim you made here is supported/discounted by the sample evidence? C D E E G H | J K L 2. Complete the following in regard to the Armspan and Height factors in the data set: 3. In the region to the right, produce a scatterplot of the Armspan versus Height data (remember this means Height nins 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 unon vour scatterolot. brieflv 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 vour trend line and discuss what the value of the slope signifies in terms of | _| this context. . Determine the value of the correlation coefficient () 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 vahe tells you regarding these two variables. 85 86 87 88 89 9 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 1na D E F G H | J | K L c. Determine the value of the correlation coefficient () for this paired data. Explain what this value tells you regarding these two variables. Next, determine the value of the coefficient of determination (r*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 em. 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. T U V W X Y Z AA Individual Foot Number Hair ID# Gender Length Height Age Armspan in Family Color A 1 Female 25.5 145.0 36 143.0 4 Brown Female 24.5 180.0 41 184.5 Red Female 23.5 161.5 29 163.0 3 Brown Female 24.5 160.0 48 161.5 8 Brown Female 24.0 170.0 36 172.0 5 Brown 6 Male 27.0 183.0 27 182.0 4 Brown Male 26.5 172.5 21 172.5 5 Blonde Female 25.5 142.0 23 145.0 5 Brown 9 Male 26.5 180.0 23 180.0 4 Brown 10 Male 25.0 172.5 50 179.0 10 Brown 11 Male 23.0 182.5 21 180.0 3 Black 12 Female 22.5 159.0 29 160.0 9 Blonde 13 Male 25.5 168.0 28 166.5 5 Brown 18 14 Female 23.0 159.0 33 157.5 4 Brown 19 15 Female 23.0 160.0 23 156.0 Brown 20 16 Male 26.0 179.0 42 184.0 5 Brown 21 17 Male 28.0 189.0 28 187.0 4 Brown 22 18 Female 23.0 162.5 37 163.0 6 Brown 23 19 Female 23.0 181.0 24 174.0 7 Red 24 20 Female 20.0 160.0 20 154.0 5 Brown 25 21 Female 22.0 157.5 34 162.0 2 Brown 26 22 Female 23.5 169.0 27 169.0 5 Red 27 23 Female 24.0 162.5 27 164.5 4 Blonde 28 24 Female 26.5 152.5 38 157.5 7 Brown 29 25 Female 23.0 163.0 32 165.0 2 Brown 30 26 Female 25.0 167.5 30 165.0 3 Brown 31 27 Female 24.5 157.5 26 153.0 3 Brown 32 28 Female 25.5 149.5 37 151.5 12 Blonde 33 29 Female 21.5 157.5 34 158.0 5 Brown 34 30 Female 25.5 165.0 19 169.0 7 Brown 35 31 Female 25.5 170.0 24 168.0 4 Purple 36 32 Female 21.0 167.0 24 156.0 4 Black 37 33 Female 24.0 170.0 20 170.0 3 Blonde 38 34 Male 29.5 188.0 34 189.5 4 Blonde 39 35 Female 25.0 177.0 41 173.0 5 Blonde 40 36 Male 30.0 185.5 31 183.0 1 Black 37 Male 26.5 179.5 31 177.5 3 Brown 42 38 Female 25.0 170.0 45 168.0 3 Blonde 43 39 Male 28.0 187.0 21 188.0 7 Black 44 40 Female 23.0 163.0 28 164.0 3 Red 45 41 Male 24.5 181.0 38 183.0 4 BrownU V W X Y AA TT 45 41 Male 24.5 181.0 38 183.0 Brown NN AN 46 42 Female 23.5 166.5 29 169.5 Brown 47 43 Male 24.5 178.0 34 176.5 Brown 48 44 Female 24.0 167.0 18 167.0 Brown 49 45 Female 25.5 150.0 24 153.0 5 Brown 50 46 Male 25.5 177.5 39 175.0 Black 51 47 Female 25.0 169.0 19 170.0 Red UNW A 52 48 Female 24.0 172.5 22 173.5 Blonde 53 49 Male 26.5 169.0 25 172.0 Brown 54 50 Female 24.0 160.0 27 160.0 6 Brown 55 51 Female 26.0 170.0 37 165.5 6 Blonde 56 52 Female 22.5 155.0 27 153.0 Brown 57 53 Female 23.0 155.0 20 157.5 Brown 58 54 Female 24.0 162.5 23 160.0 6 Black 59 55 Female 23.0 170.0 21 171.0 5 Blonde 60 56 Male 28.0 183.0 28 180.0 4 Brown 61 57 Female 23.0 154.0 33 154.0 4 Brown 62 58 Male 27.0 172.5 18 173.0 Brown 63 59 Female 20.0 160.0 32 165.0 Blonde 64 60 Male 26.5 172.5 21 175.5 5 Brown 65 61 Female 23.0 159.0 19 160.0 Brown 66 62 Male 25.0 168.0 25 170.0 Black 67 63 Male 28.0 170.5 36 178.0 Black 68 64 Female 22.0 160.0 49 156.0 Red 69 65 Female 28.5 161.5 41 157.0 IN Blonde 70 66 Male 26.0 175.0 20 179.5 Brown 71 67 Female 23.0 156.0 22 160.0 3 Blonde 72 68 Male 25.0 175.0 26 177.0 4 Brown 73 69 Male 27.5 184.0 18 191.5 A Blonde 74 70 Female 23.0 161.0 25 165.0 8 Blonde 75 71 Female 24.0 160.0 27 156.0 A Brown 76 72 Female 25.5 164.0 25 172.5 11 Brown 77 73 Male 26.0 178.0 48 180.0 4 Brown 78 74 Male 28.0 186.0 21 183.0 5 Brown 79 75 Female 23.0 161.0 26 161.5 Brown 80 76 Male 23.5 162.5 42 162.5 4 Blonde 81 77 Female 27.0 169.0 31 170.0 Brown 82 78 Female 23.5 165.0 28 165.0 Blonde 83 79 Male 28.0 180.0 25 172.0 5 Red 84 80 Female 25.5 176.0 21 172.0 9 Blonde 85 81 Male 25.5 183.0 18 186.0 3 Brown 86 82 Female 26.0 171.0 25 172.0 12 BrownT U V W X Y Z AA 78 74 Male 28.0 186.0 21 183.0 5 Brown 79 75 Female 23.0 161.0 26 161.5 4 Brown 80 76 Male 23.5 162.5 42 162.5 4 Blonde 81 77 Female 27.0 169.0 31 170.0 Brown 82 78 Female 23.5 165.0 28 165.0 1 Blonde 83 79 Male 28.0 180.0 25 172.0 5 Red 84 80 Female 25.5 176.0 21 172.0 9 Blonde 85 81 Male 25.5 183.0 18 186.0 3 Brown 86 82 Female 26.0 171.0 25 172.0 12 Brown 87 83 Female 24.0 175.5 38 176.0 6 Blonde 88 84 Female 22.0 165.0 24 167.0 11 Brown 89 85 Male 28.0 175.0 39 182.0 3 Black 90 86 Male 28.0 188.0 33 189.0 7 Brown 91 87 Female 24.0 167.5 18 163.5 5 Blonde 92 88 Female 20.5 167.5 36 153.5 5 Black 93 89 Female 22.0 171.0 19 174.0 4 Red 94 90 Female 25.0 167.5 22 165.0 3 Brown 95 91 Female 25.5 154.0 23 155.5 7 Brown 96 92 Female 21.0 158.0 25 157.0 2 Brown 97