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.

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