Registration times #1 Data

Assignment 3: INTERPRETING DATA Submission date: 21 August 2024 @17h00 INSTRUCTIONS: What you need to submit: 1. Answer ALL questions in the submitted .pdf file using the standard naming convention, for example 2. Submit your workings in EXCEL or Python as supporting documentation using the standard naming convention, for example, 3. All submissions MUST to be made on Efundi. 4. Please note the deadline and ensure that all submissions are received well before the cut off time. DATA: Consider all data as fictions. All data required is available in the accompanying EXCEL spreadsheet DAY DAY1 DAY2 DAY3 DAY4 DAY5 DAY6 DAY7 DAYS8 DAY9 DAY10 DAY11 DAY12 DAY13 DAY14 DAY15 DAY16 DAY17 DAY18 DAY19 DAY20 DAY21 Afternoon 11,38 9,00 5,71 14,32 11,49 12,30 16,64 | 12,13 11,80 5,30 12,81 10,39 12,10 9,36 12,82 9,99 9,89 10,98 10,79 12,67 C D Morning Midday 8h00 to 11h00 11h00 to 14h00 14h00 to 17h00 11,00 14,52 11,81 14,28 12,72 14,02 12,32 12,82 11,45 14,83 12,59 15,65 11,54 15,35 12,02 17,73 13,15 10,31 10,85 10,77 11,26 12,49 12,57 14,79 12,58 13,98 12,34 19,88 11,49 16,18 13,01 11,43 11,85 8,93 11,41 13,58 12,78 7,16 10,73 12,43 9,53 13,58 16,61 25 DAY22 9,91 14,13 11,05 26 DAY23 12,29 12,01 10,67 27 DAY24 12,80 13,90 11,16 28 DAY25 12,56 16,13 5,86 29 DAY26 12,29 14,06 14,63 30 DAY27 11,11 12,51 17,29 31 DAY28 11,00 12,67 11,36 32 DAY29 11,93 12,01 9,66 33 DAY30 12,39 12,98 14,905) The above graph shows that for a symmetrical distribution, there is approximately 99.73% between the LL and the UL The Big Dreams Campus expects that 99.73% of the observations to lie between 10 mins and 15 mins, using the above analysis comment (and motivate) on whether the data supports this expectation or not. (4) QUESTION 1: 13 marks Data in TAB Registration times #1 The Big Dreams Campus has recently embarked on a quality improvement project to investigate and understand the registration times of students who choose to register online. Registrations were monitored over a 30-day period. It is believed if the registration times of students are improved, it would encourage students to register on-line and hereby reducing the number of students that still choose to register on campus. The college believes that they comply with the expectations, and that students can register online in less than 15 min. The data in the table represents a random sample of students that registered online, where each data point represents the average of 20 randomly selected students per timeslot and the data shows the average registration time in minutes. 1) [Initiallyuse all the data (sample size is n=90) to draw a histogram with +10 intervals. (2) 2) Describe the data using the mean & the standard deviation and comment on the skewness. (3) 3) Put the data into a frequency table (choose intervals of 1 minute) and calculate the % of observations that show a registration of less than or equal to 15 min. (2) 4) Determine the 6-sigma limits for this data set by following the below: a. Calculate Lower Limit (LL) = average - (3x standard deviation) (1) b. Calculate Upper Limit (UL) = average + (3x standard deviation) (1) __"15.73% 68.27% 15.73% ~ __ r T 1 do =30 -2c o 1) Oc lo 20 3o 4o QUESTION 2:17 marks The Big Dreams Campus has asked your advice on how to improve the online registration times for the campus. Answer the following questions in pursuit of further understanding. 1) The first question to answer is whether there is a trend over time. To do this, calculate an average for each day and plot the daily averages on a line graph. (1) Using the findings in previous question, discuss whether there is evidence of a trend over time. (2) Use a box-and-whisker diagram compare the online registration times for the 3 timeslots, ie morning, midday and afternoon. (3) Describe the distribution of the afternoon's registration times by using the minimum, maximum and inter-quartile range. (3) Using the findings in the previous questions, discuss whether there is any evidence of a difference between the three timeslots. 3) Considering both sets of results, give Big Dreams Campus a 5-point recommendation of how to conduct further studies to improve the online registration times. (5) Morning Midday Afternoon Day 8h00 to 11h00 11h00 to 14h00 14h00 to 17h00 UTA W N DAY45 11,71 11,72 12,30 DAY46 12,23 12,07 12,46 DAY47 12,04 12,46 12,95 DAY48 14,28 11,22 11,48 8 DAY49 12,98 12,35 12,49 9 DAY50 11,94 12,83 11,33 10 DAY51 11,79 12,65 12,07 11 DAY52 10,57 13,40 12,82 12 DAY53 12,45 12,84 11,47 13 DAY54 13,18 11,23 13,09 14 DAY55 11,90 12,90 12,00 15 DAY56 11,96 12,67 11,43 16 DAY57 11,31 11,83 12,01 17 DAY58 12,47 11,21 12,43 18 DAY59 12,65 11,50 11,43 19 DAY60 13,49 12,44 12,85 20 DAY61 13,82 12,29 10,71 21 DAY62 13,23 10,27 12,54 22 DAY63 13,01 11,75 10,08 23 DAY64 14,26 11,94 13,25