Activity 6MATH 250 Elements of StatisticsSummer 2016 DUE DATE: 07/13/2016 Score: ?? /60 General Instructions: Please place your name above, then complete the following questions. NO get a feel for the activity before continuing. Make sure to save this Excel file often using the filenam complete, submit your answers to this activity by attaching your Excel file through the completion l description in Blackboard. Use the area to the near right in this Excel worksheet when calculating Methods/work used to calculate values and reach conclusions must be shown in the spreadsheet in Overview: As discussed in the 8th Chapter of your text, one can use data from a random sample to test a claim or h might want to test the claim that the mean age of all FHSU Elements of statistics students is at least 30 y understanding of hypothesis testing to actual datathe data collected in Activity 1a of this course. This class data from Activity 4 to test some claims. This data is given again to the right. NOTE: In all three of these problems below, you are required to demonstrate your analysis p conclusion. Also, as stated in the resources, there are requirements to applying hypothesis te our collected data will actually fail to meet (for instance, the sample should be randomly sele for simplicity of the activity you MAY ASSUME that all requirements for hypothesis testing process. 1. Past enrollment data indicates that 22% of the students taking elementary statistics at FHSU h enrollment in this semester's virtual classes significantly more than this claim, as measured sta formal hypothesis testing procedure on proportions with a 5% level of significance. It is requir related statistical values below as well as statistical computations to the right (feel free to use guide for Unit 3). Then give a proper final interpretive conclusion below based on the statistic context given. H0: H1: Sample proportion (p-hat): Critical Value: Sample's Test Statistic: P-value: CONCLUSION: 2. It has been claimed that the mean age of all FHSU Virtual College statistics students is 26.52 from this summer's classes, test this hypothesis--that is does the collected data statistically su different from 26.52 years old? Justify your answer through a formal hypothesis testing proce Again, necessary claims, calculations, and values must be shown below and to the right. Give Since the population s.d. is not known, make sure to realize the need to use the t-distribution H0: H1: Sample's Mean (x-bar): Sample's S.D. (s): Critical Value: Sample's Test Statistic: P-value: CONCLUSION: 3. It has been claimed that the mean armspan of adults in the US is greater than 165 cm. Does t contradict this claim? Justify your answer through a formal hypothesis testing procedure with level of your choice. Calculation of and interpretation of the P-value is required on this problem H0: H1: Sample's Mean (x-bar): Sample's S.D. (s): Sample's Test Statistic: P-value: CONCLUSION: NAME: plete the following questions. NOTE: Read the entire document below to is Excel file often using the filename "yournameActivity6". Once Excel file through the completion link in the Unit 3 Activity 6 assignment Excel worksheet when calculating any statistics/parameters. ust be shown in the spreadsheet in order to receive full credit. from a random sample to test a claim or hypothesis about a population. For example one ments of statistics students is at least 30 years. In this activity, you will apply your llected in Activity 1a of this course. This activity is designed to have you use the cleaned en again to the right. re required to demonstrate your analysis process as described in the text, not just the final re requirements to applying hypothesis testing that should be checked--requirements that ance, the sample should be randomly selected from the population of interest). However, at all requirements for hypothesis testing have been met in regard to the data collection aking elementary statistics at FHSU have a family size of four people. Is the more than this claim, as measured statistically? Justify your answer through a a 5% level of significance. It is required that you give needed hypotheses and putations to the right (feel free to use the appropriate template from the Excel onclusion below based on the statistical measures calculated and related to the al College statistics students is 26.52 years old. Using the age data collected does the collected data statistically support this claim or is the mean age likely ugh a formal hypothesis testing procedure with a 0.05 level of significance. be shown below and to the right. Give your proper/final conclusion below. (Hint: ize the need to use the t-distribution for testing purposes.) he US is greater than 165 cm. Does the data of our statistics class support or mal hypothesis testing procedure with a P-value approach using a significance the P-value is required on this problem. Give your final conclusion below. MATH 250- Elements of Statistics Class Data, Summer Foot2015---CLEANED Student Data Individual# Gender Length (cm) Height (cm) Armspan (cm) Age (years) Number in Family 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Male Female Female Female Female Male Female Female Female Male Female Male Female Male Female Male Female 27 19 20.5 19 21 28.5 22 26 19.5 28 25 28 23.5 26 24.5 31 24.5 178 153 157.5 167.5 157 184.5 167.5 171.5 168 157 175 188 170 181.5 162.5 185.5 165 183 157 150 170.5 145 186.5 164.5 172.5 165.5 152.5 177 178 153.5 173.5 165 183 162.5 22 27 21 19 18 26 19 19 22 22 43 28 20 28 24 31 32 6 4 3 4 8 2 3 4 6 1 4 5 3 3 3 5 4 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Female Female Female Male Female Female Female Female Male Female Male Female Female Male 25 19 25 29 22.5 28 27 23 28 25 26.5 24 23.5 26.5 160 164.5 165 183 162.5 175 158 159 178 162.5 176 167.5 162.5 170 160 166 171 184.5 162 166 156 164.5 180.5 162 180.5 165 160 171 20 25 39 37 19 33 26 21 24 42 23 33 37 23 5 4 7 4 4 3 4 3 5 2 4 4 6 5 32 33 35 36 37 38 39 40 41 42 43 Female Female Male Female Female Female Female Female Male Male Male 24.5 29 28 25 24.5 29.5 24 23.5 27.5 25.5 26.5 161 163 180 161.5 165 170 162 160 186.5 177.5 165 160 158 182 165 165 175 160 167.5 183.5 166 162 29 29 30 36 45 21 32 44 24 38 54 3 4 2 5 3 8 4 4 3 3 6 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Female Female Female Female Female Female Female Male Female Female Female Female Male Female Female Female Female Female Male Female 26 28 22 27 22.9 23.5 24.5 26.5 24.5 23.5 23 23 29 23.5 24 20.5 24 23 27 24 164 182.9 173 172 160 171 167.5 185.5 170 173 175.5 152.5 188 167.5 157.5 157.5 170 167.5 182.5 160 164 182 164 171.5 168.5 167.5 170 181.5 170 175 155 158.5 179 167.5 172 147.5 170 162.5 192 160 30 19 43 31 29 41 18 57 21 31 36 37 22 32 34 24 27 25 29 22 3 3 4 3 3 2 4 4 4 5 5 5 4 5 2 3 6 4 3 5 64 65 66 67 68 69 70 71 72 73 74 75 76 Male Male Female Male Male Female Female Female Male Female Female Female Female 24 23 25 25 27 23.5 23 25 25 21.5 22 26 25.5 171.5 147 163 178 185 157.5 157.5 165 178 160 175.5 176 167.5 171 167.5 173 177 181 145.5 158.75 165 186 158.5 173 173 170 20 22 54 25 31 21 32 36 55 43 41 50 28 2 3 4 3 3 5 4 6 2 8 6 3 2 nt Data Hair Color Brown Black Brown Blonde Brown Brown Red Blonde Blonde Brown Brown Blonde Brown Blonde Blonde Brown Brown Brown Blonde Brown Brown Brown Brown Black Brown Brown Black Blonde Blonde Brown Brown Brown Brown Black Brown Black Blonde Brown Blonde Blonde Blonde Brown Brown Brown Red Blonde Black Brown Black Blonde Blonde Brown Brown Brown Brown Brown Brown Brown Brown Brown Brown Blonde Blonde Brown Brown Brown Brown Blonde Brown Brown Blonde Brown Brown Brown Blonde