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 “Data-Problem 1.”

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?
• What is the median?
• What is the mode?
• What is the standard deviation?
• Create a Bar Graph for each of the 2 out of the 3 questions. What type of skewness is present, if any?
• Are there any outliers? If so, what are the outliers? Do you believe they were typos? What is the range and midrange?
• Calculate the variance and coefficient of variation?
• Calculate 2 of the following 3 zscores for age of 30, wait time of 15 min, satisfaction of 4.
• 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.

1. Graph the measurements: found in the Microsoft Excel file titled “Data – Tab Problem 2” There will be a bar chart on the ages, a pie chart on pizza toppings and a line chart on temperatures.

1. Standard Normal Distribution: Assume the measurements given, have a mean of 0 and a standard deviation of 1. Find the probability of the reading.

1. Less than 2.16
2. Greater than 1.66
3. Between 1.2 and 1.9
4. Greater than 2.44

1. Standard Normal Distribution: Find the area, if there is a mean of 40 and a standard deviation of 5 for the following scenarios.

1. Greater than 30
2. Less than 60
3. Between 35 and 50

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.