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 |
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 to Expert-Tailored 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