MATH Elements of Statistics

vng225
Activity6Fall2017.xlsx

Activity 6

Activity 6—MATH 250
Elements of Statistics—Fall 2017 MATH 250- Elements of Statistics
DUE DATE:  11/16/2017 Class Data, Fall 2017---CLEANED Student Data
NAME: Individual ID# Gender Foot Length Height Age Armspan Number in Family Hair Color
1 Female 24.0 160.0 31 159.0 3 Red
General Instructions: Please place your 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 "yournameActivity6". Once complete, submit your answers to this activity by attaching your Excel file through the completion link in the Unit 3 Activity 6 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 and reach conclusions must be shown in the spreadsheet in order to receive full credit. 2 Male 25.0 172.5 20 177.5 2 Blonde
3 Female 25.5 170.5 28 174.0 4 Brown
4 Male 29.0 185.0 27 192.5 3 Brown
5 Female 28.0 174.5 38 183.0 5 Brown
6 Female 23.0 168.0 38 168.0 3 Red
7 Female 24.5 157.0 21 153.0 4 Blonde
8 Female 21.0 152.0 21 151.0 8 Brown
9 Male 30.5 187.5 29 190.0 5 Black
Overview: 10 Female 23.5 157.5 22 160.0 5 Blonde
As discussed in the 11th & 12th chapters of the text, one can use data from a random sample to test a claim or hypothesis about a population. For example, one might want to test the claim that the mean age of all FHSU Elements of statistics students is over 26 years. In this activity, you will apply your understanding of hypothesis testing to actual data—the data collected in Activity 1a of this course. This activity is designed to have you use the cleaned class data to test some claims. This data is given again to the right, and you are encouraged to use the templates given in the Unit 3, Part 1 Excel Guide. If you use a template, just copy & paste the template next to the problem, then make changes to the values, and this will serve as your "work" for that particular problem. 11 Female 23.0 165.0 21 163.0 2 Red
12 Female 23.0 166.0 32 160.0 3 Brown
13 Female 23.0 152.5 35 160.0 6 Brown
14 Female 24.0 165.0 34 165.0 6 Blonde
15 Female 20.0 163.0 20 153.0 4 Blonde
16 Male 26.0 178.0 34 175.5 2 Black
17 Female 24.0 162.5 23 170.5 4 Brown
NOTE: In all three of these problems below, you are required to demonstrate your analysis process as described in the text, not just the final conclusion. Also, as stated in the resources, there are requirements to applying hypothesis testing that should be checked--requirements that our collected data will actually fail to meet (for instance, the sample should be randomly selected from the population of interest). However, for simplicity of the activity you MAY ASSUME that all requirements for hypothesis testing have been met regarding the data collection process. 18 Female 24.0 164.5 22 160.5 5 Red
19 Male 26.0 184.0 40 169.0 3 Brown
20 Male 27.5 183.5 32 183.0 2 Brown
21 Female 23.5 161.5 29 157.5 5 Brown
22 Female 24.5 157.5 22 150.0 3 Brown
23 Male 25.5 179.5 33 184.5 6 Brown
24 Male 27.0 175.0 40 175.0 4 Brown
25 Male 26.0 185.0 31 179.0 3 Brown
26 Female 25.5 170.0 40 169.0 5 Brown
1. It has been claimed that the average family size of all FHSU Virtual College statistics students is more than 4 people. Using the family size data collected from this year's classes, test this hypothesis--that is does the collected data statistically support this claim? Justify your answer through a formal hypothesis testing procedure with a 0.05 level of significance. Again, necessary claims, calculations, and values must be shown below and to the right. Give your proper/final conclusion below. (Hint: Since the population s.d. is not known, make sure to realize the need to use the t-distribution for testing purposes.) 27 Male 25.5 186.0 20 188.0 4 Brown
28 Male 29.0 180.0 47 180.0 7 Black
29 Female 23.0 148.0 39 150.0 5 Brown
30 Female 25.0 172.5 23 170.5 6 Brown
31 Female 24.0 167.5 22 162.5 3 Brown
32 Female 24.0 168.0 20 169.0 3 Red
33 Female 24.0 159.0 32 157.0 8 Brown
H0: 34 Male 30.5 185.5 33 193.5 4 Brown
H1: 35 Female 24.0 164.0 27 168.5 5 Blonde
Sample's Mean (x-bar): 36 Female 25.0 166.0 26 169.0 3 Brown
Sample's S.D. (s): 37 Female 24.5 164.0 26 165.0 3 Brown
Critical Value: 38 Male 24.0 179.0 33 160.0 3 Black
Sample's Test Statistic: 39 Male 26.5 177.0 37 180.0 6 Brown
P-value: 40 Female 27.0 170.0 31 166.0 6 Red
CONCLUSION: 41 Female 24.0 170.0 29 155.0 5 Brown
42 Female 22.5 161.0 39 165.5 4 Blonde
43 Female 25.5 171.5 24 142.0 3 Brown
44 Female 25.0 158.0 44 167.0 2 Brown
45 Female 30.5 176.5 36 198.0 1 Brown
46 Female 26.0 158.0 22 160.0 3 Brown
47 Female 23.5 152.5 21 152.5 2 Brown
48 Female 25.0 182.0 24 177.0 4 Brown
49 Female 27.0 167.5 27 167.0 4 Brown
50 Male 27.0 180.0 37 173.0 4 Black
51 Female 26.0 178.0 26 175.0 4 Brown
52 Male 28.5 178.0 31 185.5 5 Brown
53 Female 23.0 165.0 31 167.0 2 Brown
2. Past enrollment data indicates that 50% of the students taking elementary statistics at FHSU have brown hair. Is the enrollment in this semester's virtual class significantly different from this claim, as measured statistically? Justify your answer through a formal hypothesis testing procedure on proportions with a 10% level of significance. It is required that you give needed hypotheses and related statistical values below as well as statistical computations to the right (feel free to use the appropriate template from the Excel Guide for Unit 3). Then give a proper final interpretive conclusion below based on the statistical measures calculated and related to the context given. 54 Male 28.0 183.0 27 193.0 3 Black
55 Female 23.5 170.5 22 172.0 5 Brown
56 Female 25.5 170.0 27 170.0 3 Brown
57 Female 23.5 170.0 42 150.0 3 Brown
58 Male 24.0 160.0 46 165.0 4 Black
59 Female 25.0 169.5 22 164.5 8 Blonde
60 Female 22.0 151.5 34 156.5 4 Brown
H0: 61 Female 24.0 159.0 40 161.5 7 Brown
H1: 62 Female 26.0 162.5 21 162.5 4 Black
Sample proportion (p-hat): 63 Female 25.5 170.0 28 165.5 6 Brown
Critical Value: 64 Male 28.0 181.0 27 182.5 4 Red
Sample's Test Statistic: 65 Female 22.0 154.0 23 142.0 3 Blonde
P-value: 66 Female 24.0 180.0 31 178.0 4 Brown
CONCLUSION: 67 Male 26.0 178.5 35 186.0 6 Brown
68 Male 26.0 178.0 37 176.5 3 Brown
69 Female 24.0 162.5 31 162.5 4 Blonde
70 Female 26.5 165.0 48 169.0 2 Brown
71 Male 31.0 178.0 21 152.0 5 Brown
72 Female 26.0 176.0 21 160.5 3 Brown
73 Female 23.0 160.0 23 150.0 2 Brown
74 Male 28.0 177.0 38 184.0 3 Black
3. It has been claimed that the average foot length of adults in the US is less than 26 cm. Does the data of our statistics class support or contradict this claim? Justify your answer through a formal hypothesis testing procedure with a P-value approach using a significance level of your choice. Calculation of and interpretation of the P-value is required on this problem. Give your final conclusion below.
H0:
H1:
Sample's Mean (x-bar):
Sample's S.D. (s):
Sample's Test Statistic:
P-value:
CONCLUSION: