BSB131 Applied Data Analytics - 52070387985Assessment Instructions
BSB131 Applied Data Analytics - 52070387985Assessment Instructions
This assessment is focused on the material contained in week 4 and 5related to probability distributions and sampling distributions.
There is no Excel data file.
As usual, do the working in Excel, but copy all of your solutions to an answer document in Word.
Note that if your solution is a single value that was generated using an Excel formula, please include the formula itself on your solution document e.g. for a binomial distribution calculation you may include the formula norm.dist(x, mean, standard deviation, cumulative) with the correct values entered for each of the four required inputs.
Where calculations are done by hand, please include all working
Note that if an answer is given with no working or excel output it will not be marked.
Once completed save your solutions as a PDF file using the title <your_name>PST4.pdf e.g. Andrew_paltridge pst4.pdf.
Submit only the PDF and not the Excel worksheet. We will request that if required.
00Assessment Instructions
This assessment is focused on the material contained in week 4 and 5related to probability distributions and sampling distributions.
There is no Excel data file.
As usual, do the working in Excel, but copy all of your solutions to an answer document in Word.
Note that if your solution is a single value that was generated using an Excel formula, please include the formula itself on your solution document e.g. for a binomial distribution calculation you may include the formula norm.dist(x, mean, standard deviation, cumulative) with the correct values entered for each of the four required inputs.
Where calculations are done by hand, please include all working
Note that if an answer is given with no working or excel output it will not be marked.
Once completed save your solutions as a PDF file using the title <your_name>PST4.pdf e.g. Andrew_paltridge pst4.pdf.
Submit only the PDF and not the Excel worksheet. We will request that if required.
Problem Solving Task 4
Your Task
Question One
A large organisation promotes its call centre efficiency stating that the average time to answer all calls is 7.5 minutes with a standard deviation of 2.4 minutes. Assuming the waiting time duration is approximately normal:
What is the probability that a random customer would need to wait more than 10 minutes for their call to be answered?
What is the probability that a customer is answered in between 2 and 3 minutes?
What is the waiting time that the associated with the top 10% of customers i.e. if you are unlucky enough to be a customer who is subjected to the 10% of longest waiting times.
A consumer advocacy group is investigating customer waiting times and has decided to test the claim that the average waiting time is 7.5 minutes. They place 36 different calls to the organisation and found that the average waiting time was 7.7 minutes.
What is the probability that the average waiting time would be 7.7 minutes or more if the organisations claim of 7.5 minutes was true?
Using the answer to part d., given the sample average was 7.7 minutes, what does this imply about the companies claim? Explain your answer briefly.
Question Two
A 2023 Youth Insights study of the top causes of stress in students showed that 84% of university students were working while also studying.
If a sample of 10 university students was randomly selected, what is the probability that all 10 would be working as well as studying?
If a random sample of 100 university students was randomly selected, calculate the probability that the PROPORTION of students who were also working was less than 75%?
Assessment is due Friday 19th April, 11:59pm.
