S TA322

 

Week 2 ASStgnment
120 Pomts

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

READ ALSO :   Maternity

a. Less than 2.16 (5 points)

b. Greater than 1.66 (5 points)

c. Between 1.2 and 1.9 (5 points)
(1. 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)
0. Between 35 and 50 (5 points)

Client Name Client Age Wait Time (min) Are you satisfied
with appt on scale
of 1-5? 5=yes, 1=no

Sally 22 45 – 2

Joe 34 12 5

Kathy 21 35 5

Shawn 55 68 1

James 62 12 _ 3

Jim 42 5 4

Liz 65 25 2

Paul 39 15 4

Jamie 58 173 1

Jean 42 ‘ 16 2

Jeremy 32 58 1

Elijah 2 13 2

Kris 48 15 3

David 56 900 1

Jackie 48 . 24 4

Kelly 38 26 4

Steven 3 5 5

Pat 25 15 1

Mel 58 16 1

Debbie 25 11 2

 

Graph as a Bar Chart Graph as a Pie Chart

Age Pepperoni 14
Joe 12 Cheese 29
Jake 9 ‘ Meatlovers 12
Bill 6 Supreme 5
Sarah 8
Mary 11
Bobby 2

Graph as a Line Chart
Temperature
Monday 58
Tuesday 63
Wednesday 60
Thursday 65
Ffiday . 64
Saturday 69
Sunday 72