Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Age BMI Language 74 38 English 32 27.3 Korean 60 34.9 French 47 28.5 Punjabi 19 15.3 French 52 34 Ukrainian 23 34.2 Punjabi 51
Age BMI Language 74 38 English 32 27.3 Korean 60 34.9 French 47 28.5 Punjabi 19 15.3 French 52 34 Ukrainian 23 34.2 Punjabi 51 32.6 Hindi 38 33.5 English 33 29.3 English 44 32.2 Hindi 51 35.1 French 44 30.8 English 66 40.2 Chinese 63 30.6 English 58 35.9 English 38 32.4 Punjabi 49 28.8 English 29 21.6 English 31 19.4 English 39 25.5 English 40 30.6 Punjabi 33 35.1 English 26 23.4 English 64 39.8 English 55 29.7 English 25 23.2 English 34 30.4 English 48 32.5 Punjabi 55 41.7 English 32 29 Punjabi 63 39.2 English 63 31.7 English 50 27.3 English 45 27.8 English 52 29.1 French 60 41.8 English 41 25.6 English 37 30.8 Punjabi 57 35.4 English 42 23.3 English 34 27.9 Punjabi 53 30.8 Punjabi 40 32.1 English 63 36.4 Punjabi 52 31.4 Chinese 42 29.7 English 45 38.3 English 47 37.5 Chinese 57 26.4 English 54 28.7 English 53 33.8 English 51 35.9 English 30 17.9 French 49 35.1 English 49 38.3 English 33 28.9 English 52 25.4 Punjabi 38 21.1 English
Age | BMI | Language |
74 | 38 | English |
32 | 27.3 | Korean |
60 | 34.9 | French |
47 | 28.5 | Punjabi |
19 | 15.3 | French |
52 | 34 | Ukrainian |
23 | 34.2 | Punjabi |
51 | 32.6 | Hindi |
38 | 33.5 | English |
33 | 29.3 | English |
44 | 32.2 | Hindi |
51 | 35.1 | French |
44 | 30.8 | English |
66 | 40.2 | Chinese |
63 | 30.6 | English |
58 | 35.9 | English |
38 | 32.4 | Punjabi |
49 | 28.8 | English |
29 | 21.6 | English |
31 | 19.4 | English |
39 | 25.5 | English |
40 | 30.6 | Punjabi |
33 | 35.1 | English |
26 | 23.4 | English |
64 | 39.8 | English |
55 | 29.7 | English |
25 | 23.2 | English |
34 | 30.4 | English |
48 | 32.5 | Punjabi |
55 | 41.7 | English |
32 | 29 | Punjabi |
63 | 39.2 | English |
63 | 31.7 | English |
50 | 27.3 | English |
45 | 27.8 | English |
52 | 29.1 | French |
60 | 41.8 | English |
41 | 25.6 | English |
37 | 30.8 | Punjabi |
57 | 35.4 | English |
42 | 23.3 | English |
34 | 27.9 | Punjabi |
53 | 30.8 | Punjabi |
40 | 32.1 | English |
63 | 36.4 | Punjabi |
52 | 31.4 | Chinese |
42 | 29.7 | English |
45 | 38.3 | English |
47 | 37.5 | Chinese |
57 | 26.4 | English |
54 | 28.7 | English |
53 | 33.8 | English |
51 | 35.9 | English |
30 | 17.9 | French |
49 | 35.1 | English |
49 | 38.3 | English |
33 | 28.9 | English |
52 | 25.4 | Punjabi |
38 | 21.1 | English |
Use the Excel attached above to answer the questions.
Threat the data in the file as a sample of all the students.
1. Test the (null) hypothesis, at 5% level of significance, that the population mean age of students is 45 years. Show the work.
2. Test the (null) hypothesis, at 5% level of significance, that the population proportion of students speaking English is 55%. Show the work.
3. Test the (null) hypothesis, at 5% level of significance, that the population proportion of students speaking English is no less than 65%. Show the work.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started