Assignment

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 Data-Problem 1.” (85 points total)

Analysis of Statement: Discuss/Demonstrate how you will use the data to analyze (see below to see which data set to analyze: age, wait time and satisfaction).

· What is the mean? (9 points-find for all 3 data sets: age, wait time and satisfaction)

· What is the median? (3 points-find for any 1 data set)

· What is the mode? (3 points-find for any 1 data set)

· What is the standard deviation? (9 points-find for all 3 data sets: age, wait time and satisfaction)

· Create a Column Chart for all 3 data sets. (12 points)

· Are there any outliers? If so, what are the outliers? Do you believe they were typos? (3 points)

· Calculate the range. (4 points- find for any 1 data set)

· Calculate the midrange. (4 points –find for any 1 data set)

· Calculate the variance. (3 points-find for any 1 data set)

· Calculate the coefficient of variation. (3 points – find for any 1 data set)

· Calculate the following 3 z-scores for age of 30, wait time of 15 min, satisfaction of 4. (12 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. (75 words, 20 points)

2. 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.02 (5 points)

b. Greater than 1.45 (5 points)

c. Between 1.8 and 2.1 (5 points)

d. Greater than 2.08 (5 points)

3. 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 32 (5 points)

b. Less than 55 (5 points)

c. Between 30 and 55 (5 points)