Question
XYW Pte Ltd specialises in providing servicing and repair of air conditioners. In the past three months, they received an overwhelmingly high number of requests
XYW Pte Ltd specialises in providing servicing and repair of air conditioners. In the past three months, they received an overwhelmingly high number of requests for servicing or repair of air conditioners.
Joe, the human resource manager would like to analyse the situation to improve the scheduling of manpower in air conditioner servicing or repair. He would like to investigate if there are any day(s) of the week with significantly higher mean number of requests received than other days.
You are tasked to assist Joe to conduct a suitable test using 5% level of significance. Using the data in the Excel file that is provided to you, conduct suitable statistical tests.
Based on the data given, copy the data to a new Excel file, and work on the new Excel file for submission. The data below shows the number of requests received on each day over the past 10 weeks. The company only takes in requests on week days.
Explain your rationale of choosing the type of hypothesis tests.Show all steps of the test clearly and state all necessary assumptions. Provide a recommendation based on the findings.
Week | Mon | Tue | Wed | Thu | Fri |
1 | 47 | 22 | 32 | 41 | 20 |
2 | 34 | 24 | 17 | 30 | 32 |
3 | 43 | 27 | 23 | 27 | 20 |
4 | 48 | 24 | 11 | 50 | 36 |
5 | 47 | 25 | 31 | 15 | 22 |
6 | 36 | 34 | 15 | 29 | 31 |
7 | 46 | 36 | 21 | 19 | 24 |
8 | 38 | 15 | 23 | 50 | 38 |
9 | 38 | 21 | 35 | 39 | 36 |
10 | 44 | 18 | 27 | 21 | 29 |
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