Math 217 Beginning Stats - graph project.

profileheatherruiz
Week4AssignmentWidget.xlsx
Home>Mathematics homework help>Statistics homework help>Math 217 Beginning Stats - graph project.

Topic 1 - Infections

MTH/217: Statistics I
Health Services and Nursing Scenario
Topic 1 Infections
Scenario 1 Suppose you work at a local state hospital. In 2015, the infectious disease department of the hospital was operating at max capacity. Your supervisor has given you the job of presenting to the hospital leadership board about the number of patients who contracted infections while at 30 different hospitals in your state in 2015. The board will use your findings to make informed decisions about possible expansion of the infectious disease department. You will review the data, create visuals for the data, and create a presentation for the hospital leadership board to help with the decision.
2015 Infections Infection Class Frequency
Hospital Infections Min 6 - 81
1 89 Q1 82 - 156
2 58 Median 157-231
3 96 Q3 232-306
4 206 Max
5 31
6 16 Check for Outliers
7 249 IQR
8 79 Lower
9 29 Upper
10 6
11 222
12 108
13 58
14 54
15 81
16 64
17 9
18 130
19 37
20 121
21 27
22 6
23 95
24 7
25 18
26 37
27 140
28 74
29 134
30 184

Topic 2 - Widgets

MTH/217: Statistics I
Business Scenario
Topic 2 Widgets
Scenario 2 Suppose you work for a Fortune 500 company that is planning start selling widgets in the southwestern region of the United States to expand the company. Price is one of the considerations your company's leadership will use to determine where to get the widgets. Your supervisor has given you the job of presenting to the company's board of trustees about which widget to consider based on price. The board will use your findings along with others to make an informed decision on the widgets. You will review the data, create visuals for the data, and create a presentation for the board to help with the decision.
Widget Manufacturer Price Price Normal Distribution Exponential Binomial Distribution Box Whisker Plot
1 5.36 Min 1.25 0.1969266998 5.36 8.41483679399995E-21
2 7.22 Q1 3.57 0.1044806904 6.662 9.73716829019996E-18 Min 1.25
3 1.25 Median 4.775 0.0352861129 2.8736 2.69999999999998E-28 Q1 3.62
4 6.70 Q3 6.70 0.1362922747 5.55208 3.15556379774998E-19 Median 4.78
5 5.10 Max 8.22 0.2006064377 5.235624 8.41483679399995E-21 Q3 6.67
6 3.78 0.1690419604 4.2166872 2.95973999999998E-24 Maximum 8.22
7 7.44 Outlier Check 0.0914551123 6.47300616 9.73716829019996E-18
8 6.58 IQR -3.05 0.1435056882 6.547901848 3.15556379774998E-19 Mean 4.95
9 4.23 Lower 4.23 0.1883477692 4.9253705544 1.79804204999999E-22 Range 6.97
10 3.12 Upper 3.12 0.1314182795 3.6616111663 2.95973999999998E-24
11 2.75 0.108721358 3.0234833499 3.52349999999996E-26
12 8.01 Class Frequency 0.0611666218 6.514045005 2.51949229508923E-16
13 2.25 1-2.99 0 0.0796199644 3.5292135015 3.52349999999996E-26
14 3.77 3-4.99 2 0.1685376031 3.6977640504 2.95973999999998E-24
15 4.89 5-6.99 2 0.2010891109 4.5323292151 1.79804204999999E-22
16 5.76 7-8.99 2 0.1850787118 5.3916987645 8.41483679399995E-21
17 6.44 0.1517015106 6.1255096294 3.15556379774998E-19
18 3.48 0.1528477406 4.2736528888 2.95973999999998E-24
19 7.64 Mean 4.95 0.0801675152 6.6300958666 9.73716829019996E-18
20 8.22 Std Dev 1.9828365842 0.0516545329 7.74302876 2.51949229508923E-16
21 5.82 0.1827217021 6.396908628 8.41483679399995E-21
22 3.57 0.1579149912 4.4180725884 2.95973999999998E-24
23 2.88 Bin Range 0.1166724645 3.3414217765 3.52349999999996E-26
24 4.66 1 0.1990413076 4.264426533 1.79804204999999E-22
25 6.78 1.5 0.1314182795 6.0253279599 3.15556379774998E-19
26 7.45 2 0.0908766753 7.022598388 9.73716829019996E-18
27 1.44 2.5 0.0420002497 3.1147795164 2.69999999999998E-28
28 3.88 3 0.1739258587 3.6504338549 2.95973999999998E-24
29 3.79 3.5 0.1695435153 3.7481301565 2.95973999999998E-24
30 4.22 4 0.1880008304 4.0784390469 1.79804204999999E-22
4.5
5
5.5
6
6.5
7
7.5
8
8.5
Histogram Plot
Bin Frequency Cumulative %
1 0 0.00%
1.5 2 6.67%
2 0 6.67%
2.5 1 10.00%
3 2 16.67%
3.5 2 23.33%
4 5 40.00%
4.5 2 46.67%
5 2 53.33%
5.5 2 60.00%
6 2 66.67%
6.5 1 70.00%
7 3 80.00%
7.5 3 90.00%
8 1 93.33%
8.5 2 100.00%
More 0 100.00%
Normal Distribution 0.196926699769363 0.104480690362262 0.0352861128902044 0.136292274728745 0.200606437682174 0.169041960359402 0.0914551122608869 0.14350568824665 0.18834776916037 0.131418279546127 0.108721357976842 0.0611666217887936 0.079619964387222 0.16853760311106 0.20108911089199 0.185078711822757 0.151701510563867 0.152847740567301 0.0801675151544751 0.0516545329399266 0.182721702063424 0.15791499119974 0.116672464450975 0.199041307598262 0.131418279546127 0.0908766752694454 0.0420002496528351 0.17392585866395 0.169543515294222 0.188000830446781

Exponential Smoothing

Forecast 0.0 5.36 6.661999999999999 2.8736 5.552079999999999 5.235624 4.2166872 6.47300616 6.547901848 4.925370554400001 3.66161116632 3.023483349896 6.514045004968799 3.52921350149064 3.697764050447191 4.532329215134156 5.391698764540246 6.125509629362075 4.273652888808622 6.630095866642587 7.743028759992776 6.396908627997833 4.41807258839935 3.341421776519804 4.264426532955941 6.025327959886781 7.022598387966035 3.11477951638981 3.650433854916943 3.748130156475082

Data Point

Value

Binomial Distribution 8.41483679399995E-21 9.73716829019996E-18 2.69999999999998E-28 3.15556379774998E-19 8.41483679399995E-21 2.95973999999998E-24 9.73716829019996E-18 3.15556379774998E-19 1.79804204999999E-22 2.95973999999998E-24 3.52349999999995E-26 2.51949229508923E-16 3.52349999999995E-26 2.95973999999998E-24 1.79804204999999E-22 8.41483679399995E-21 3.15556379774998E-19 2.95973999999998E-24 9.73716829019996E-18 2.51949229508923E-16 8.41483679399995E-21 2.95973999999998E-24 3.52349999999995E-26 1.79804204999999E-22 3.155 56379774998E-19 9.73716829019996E-18 2.69999999999998E-28 2.95973999999998E-24 2.95973999999998E-24 1.79804204999999E-22

Histogram

Frequency 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 More 0.0 2.0 0.0 1.0 2.0 2.0 5.0 2.0 2.0 2.0 2.0 1.0 3.0 3.0 1.0 2.0 0.0 Cumulative % 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 More 0.0 0.0666666666666667 0.0666666666666667 0.1 0.166666666666667 0.233333333333333 0.4 0.466666666666667 0.533333333333333 0.6 0.666666666666667 0.7 0.8 0.9 0.933333333333333 1.0 1.0

Bin

Frequency

Pie Chart

5.36 7.22 1.25 6.7 5.1 3.78 7.44 6.58 4.23 3.12 2.75 8.01 2.25 3.77 4.89 5.76 6.44 3.48 7.64 8.220000000000001 5.82 3.57 2.88 4.66 6.78 7.45 1.44 3.88 3.79 4.22