Client Name Sally Joe Kathy Shawn James Jim Liz Paul Jamie Jean Jeremy Elijah Kris David Jackie Kelly Steven Pat Mel Debbie Client Age Wait Time (min) 22 34 21 55 62 42 65 39 58 42 32 2 48 56 48 38 3 25 58 25 45 12 35 68 12 5 25 15 173 16 58 13 15 900 24 26 5 15 16 11 Are you satisfied with appt on scale of 1-5? 5=yes, 1=no 2 5 5 1 3 4 2 4 1 2 1 2 3 1 4 4 5 1 1 2 Graph as a Bar Chart Graph as a Pie Chart Age Joe Jake Bill Sarah Mary Bobby 12 9 6 8 11 2 Pepperoni Cheese Meatlovers Supreme 14 29 12 5 Graph as a Line Chart Temperature Monday 58 Tuesday 63 Wednesday 60 Thursday 65 Friday 64 Saturday 69 Sunday 72 STA322 Week 2 Assignment 120 Points 1. Problem Statement: Doctor Visit Analysis, data provided on 20 patients for Age, Wait time and Satisfaction. Raw data is found in the Microsoft Excel file titled \"STA322 Week 2 DataProblem 1.\" (70 points total) Analysis of Statement: Discuss/Demonstrate how you will use the data to analyze ( must find each of the following for all 2 out of the 3 data sets: age, wait time and satisfaction ). What is the mean? (6 points) What is the median? (6 points) What is the mode? (6 points) What is the standard deviation? (6 points) Create a Bar Graph for each of the 2 out of the 3 questions. What type of skewness is present, if any? (9 points) Are there any outliers? If so, what are the outliers? Do you believe they were typos? (3 points) What is the range and midrange? (6 points) Calculate the variance and coefficient of variation? (9 points) Calculate 2 of the following 3 zscores for age of 30, wait time of 15 min, satisfaction of 4. (9 points) Discuss the data analysis and what you can determine from the data. If you were the office manager, are there areas you should improve? Draw conclusions from the data. (10 points) 2. Graph the measurements: found in \"STA322 Week 2 Data - Tab Problem 2\" There will be a bar chart on the ages (5 points), a pie chart on pizza toppings (5 points) and a line chart on temperatures (5 points). 3. Standard Normal Distribution: Assume the measurements given, have a mean of 0 and a standard deviation of 1. Find the probability of the reading. a. Less than 2.16 (5 points) b. Greater than 1.66 (5 points) c. Between 1.2 and 1.9 (5 points) d. Greater than 2.44 (5 points) 4. Standard Normal Distribution: Find the area, if there is a mean of 40 and a standard deviation of 5, for the following scenarios. a. Greater than 30 ( 5 points) b. Less than 60 (5 points) c. Between 35 and 50 (5 points)