The Sky Hospital Consortium

Anonymous

Question Description

The Sky Hospital Consortium consists of 40 hospitals in various parts of the US. After being discharged, patients are given a survey to determine if they are satisfied with the overall service. In most cases patients are satisfied. However, some are dissatisfied. In addition, out of those who responded as being dissatisfied, some filed a formal complaint. In the attached excel file, Hospitals, are the results for the patients during a specific year. The Sky Hospital Consortium is divided into the West, Central, and East Regions.

The Sky Hospital Consortium wants to evaluate the performance of the hospitals. The Consortium wants to know which hospitals have the fewest complaints. You are to assist in the data analysis by using your knowledge of probability and conditional probability to help with the ranking of the hospitals, as well as each Region.

Managerial Report
Prepare a report (see below) with your ranking of the hospitals based on the probabilities and conditional probabilities, as well as the analysis of each region. Include the following seven (7) items in table format to support your ranking. Be sure to use five (5) decimal places for your probabilities in the table, as some of them might be quite small.

  1. The probability of a patient responding “Dissatisfied” in each of the three different regions.
  2. The probability of a patient filing a formal complaint in each of the three different regions.
  3. The probability of a patient filing a formal complaint given a patient response of “Dissatisfied” in each of the three different regions.
  4. The probability of a patient responding “Dissatisfied” for each hospital.
  5. The probability of a patient filing a formal complaint for each hospital.
  6. The probability of a patient filing a formal complaint given a patient response of “Dissatisfied” for each hospital.
  7. Rank the hospitals within each region for each of the probabilities in 4 - 6. In other words, only rank the hospitals in the West region against the other hospitals in the West region. Perform the same analysis for the other two regions. Then, within each region, find the sum of the ranks and get an overall ranking for each hospital. Evaluate and discuss the meaning of your results. Use tables, charts, graphs, or visual dashboards to support your findings.

Your report must contain the following:

  • Follow APA formatting.
  • A title page.
  • An introduction that summarizes the problem.
  • The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
  • A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.

Please include your Excel file in addition to your report.

Unformatted Attachment Preview

MTH410 Critical Thinking Rubric - Module 3 Meets Expectation Content, Research, and Analysis 21 -25 Points Requirements Includes all of the required components, as specified: addressed items 17; report contains all sections and components; Excel file submitted. 25-30 Points Content Demonstrates strong or adequate knowledge of probabilities and statistics in general; correctly represents knowledge from the readings and sources. 25-30 Points Critical Analysis Provides a strong critical analysis and interpretation of the information given. Mechanics and Writing 9-10 Points Demonstrates Project is clearly college-level organized, well proficiency in written, and in organization, proper format as grammar and outlined in the style. assignment. Strong sentence and paragraph structure; few errors in grammar and spelling. Approaches Expectation Below Expectation Limited Evidence 16-20 Points Includes most of the required components, as specified in the assignment. 11-15 Points Includes some of the required components, as specified in the assignment. 6-10 Points Includes few of the required components, as specified in the assignment. 19-24 Points Some significant but not major errors or omissions in demonstration of knowledge. 13-18 Points Major errors or omissions in demonstration of knowledge. 7-12 Points Fails to demonstrate knowledge of the materials. 19-24 Points Some significant but not major errors or omissions in analysis and interpretation. 13-18 Points Major errors or omissions in analysis and interpretation. 7-12 Points Fails to provide critical analysis and interpretation of the information given. 7-8 Points Project is fairly well organized and written, and is in proper format as outlined in the assignment. Reasonably good sentence and paragraph structure; significant number of errors in grammar and spelling. 5-6 Points Project is poorly organized; does not follow proper paper format. Inconsistent to inadequate sentence and paragraph development; numerous errors in grammar and spelling. 3-4 Points Project is not organized or well written, and is not in proper paper format. Poor quality work; unacceptable in terms of grammar and spelling. MTH410 Critical Thinking Rubric - Module 3 9-10 Points Demonstrates Project contains proper use of proper APA APA style formatting, according to the CSU-Global Guide to Writing and APA Requirements, with no more than one significant error. Total points possible = 105 7-8 Points Few errors in APA formatting, according to the CSU-Global Guide to Writing and APA Requirements, with no more than two to three significant errors. 5-6 Points Significant errors in APA formatting, according to the CSU-Global Guide to Writing and APA Requirements, with four to five significant errors. 3-4 Points Numerous errors in APA formatting, according to the CSU-Global Guide to Writing and APA Requirements, with more than five significant errors. West Regional Hospital Bell County Danville Eden Medical Elton Farr County Fresno Glendale Heber Valley Lakeview La Paz Main Mountain View Roosevelt Ross General Salem South General Total Dissatisfied Patients Patients Patients who Filed a Last who Are Formal Year Dissatisfied Complaint P(Dissatisfied) 4191 147 79 4382 497 34 1468 271 77 2223 206 72 2162 288 58 5125 485 52 7339 373 73 5418 473 93 5922 382 87 5157 305 54 4257 220 40 2840 492 27 2133 300 20 3354 120 91 3868 700 88 1096 77 18 60935 5336 963 Central Adams General Columbus Mercy Hospital South Point Total 5885 2634 3300 6991 18810 449 213 300 451 1413 87 36 19 57 199 East Atlantic Branden Carson General Clifton General Columbia District Central Drexel Dubois Regional Easton Kent Lake Shore Medina Monroe 5694 4449 1169 2588 7548 1214 4622 2303 5016 5289 5914 4366 5899 438 318 342 312 382 300 103 361 490 346 269 216 365 36 70 31 46 59 73 11 60 51 39 79 37 42 Nathan Smith O'connor Rye Southern Ocean Trenton Spring Harbor Sun Coast Total 5050 6859 6224 6881 2687 1712 6347 91831 361 428 484 387 310 205 284 6701 58 79 74 88 74 57 37 1101 P(Complaint Rank by P(D) ) Rank by P(C) P(C|D) Rank by P(C|D) Sum of Ranks Overall Rank Running head: GUIDE TO WRITING WITH STATISTICS MTH410 Guide to Writing with Statistics CSU-Global Campus October, 2014 1 GUIDE TO WRITING WITH STATISTICS 2 Introduction The purpose of this paper is to provide some general guidance in the writing of papers using statistics and associated tests. The paper provides some general tips for writing and the use of statistics. An example prompt is included, followed by a sample paper. General Tips for Writing a Math Paper: • • • • • • • • Organization: o Turn your prompt into headings for paper sections. This will help you to make sure you include all of the required information and analysis. It also helps the reader identify the material. o Your paper needs: ▪ A separate title page using APA style requirements (running header, page numbers, course, instructor, your name, date, etc.). ▪ An introduction (often a summary or abstract of the problem). ▪ A body of the paper that answers the questions posed in the problem and includes calculations and graphs associated with this problem. This is where you can turn your prompt into headings. All references need to be properly cited. ▪ A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. ▪ A separate sheet for references. o There are templates that use APA style that you can insert your material into. If you really struggle with formatting, this may be an option for your first paper or two. If you use a template, remember to double-check it to remove any extra instructions or pages or other elements that weren’t used. In general, numbers less than 10 are to be written in word form. However, if you have numbers in this range that carry decimals, write them in numeral form. Never use or interpret a statistic or test that you don’t fully understand. Target your audience and present as much information as necessary to allow the reader to make an independent interpretation. Make use of graphs and tables to display information in an easily understood manner. Format them the same throughout, and make sure you don’t manipulate axes. If you are referring to a statistic that is less commonly used, explain how you calculated it. (It is not necessary to explain mean, but it may be necessary to explain how you set up an ANOVA test.) Be clear about your sample and its corresponding population. Be direct in writing descriptive statistics (The mean in Group A is 22.9 units.). GUIDE TO WRITING WITH STATISTICS • • 2 Translate the meaning of the statistic for the reader. Write plainly and then back it up with statistical evidence. For example: Men and women scored equally well on this study (t = 0.25, p < 0.01). For additional resources see the CSU-Global Guide to Writing and APA Requirements or visit https://owl.english.purdue.edu/owl/owlprint/672/ GUIDE TO WRITING WITH STATISTICS 3 Prompt for Sample Paper: Critical Thinking: Heavenly Chocolates Website transactions are an important segment of sales and distribution today. Heavenly Chocolates manufactures and sells quality chocolates at its plant and retail store in Bozeman, MT. Three years ago, the company developed a website and began sales on the internet. Website sales have exceeded expectations and management is now considering strategies to continue to increase its sales. To learn more about its sales, Heavenly Chocolates selected a sample of 50 random transactions from its previous month’s sales. The transaction data shows the day of the week the purchase was made, the type of browser used in the transaction, the time spent on the website, the number of website pages viewed, and the amount spent by the customer. The data is shown in a file named Chocolate. Heavenly Chocolates would like to determine if time spent on the website or the number of pages viewed influence the total purchase. They would also like to examine any effect that day of the week and browser type have on sales. Managerial Report Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how the variables contribute to the sales of chocolate. Be sure to include the following four (4) items in your report. 1. Descriptive statistics (mean, median, range, and standard deviation) for each of the three variables along with an explanation of what the descriptive statistics tell us about the sales. 2. A breakdown using descriptive statistics examining the effect of days of the week on sales. Evaluate the results. 3. A breakdown using descriptive statistics examining the effect of browser type on sales. Evaluate the results. 4. Descriptive statistics (correlation coefficient) showing the relationship between sales (in dollars), and each of the other two variables. Evaluate the relationships between sales (in dollars) and each of the other variables (time spent and pages visited). Use tables, charts, graphs, or visual dashboards to support your conclusions. Make recommendations for continuing to develop sales to the management. Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. Your report must contain the following: • • A title page An introduction GUIDE TO WRITING WITH STATISTICS • • 4 A body of the paper that answers the questions posed in the problem and calculations and graphs associated with this problem. A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. Submit your Excel file in addition to your report. Note: Prompt adapted from the “Heavenly Chocolate Website Transactions Case Problem 4,” D. Anderson, D. Sweeney, T. Williams, J. Camm, & J. Cochran, 2015, Essentials of statistics for business and economics. (7th ed.), p. 167,168. The following pages contain the sample paper corresponding to the prompt written above. Read through it for ideas on how to write your own papers. HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) Heavenly Chocolates Web Sales Analysis Student Name MTH410 – Quantitative Business Analysis Colorado State University–Global Campus Instructor Name Date 1 HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 2 Heavenly Chocolates Web Sales Analysis Website transactions are an important segment of sales and distribution today. Any business developing a market for online sales would be wise to analyze data from both the general marketplace and its own specific customer segment. Analysis of this data can provide insight into further development of sales. Heavenly Chocolates data-mined their transactions for the previous month to gather a random sample of 50 customer transactions. The sample recorded the day of the week the purchase was made, the type of browser used in the transaction, the time spent on their website, the number of website pages viewed, and the amount spent by the customer. The purpose of this analysis is to determine if the time spent on the website or the number of pages viewed influences the total purchase. The impact of day of the week and browser type on sales will also be studied. Overview of Online Sales The 50 customers sampled spent a total of $3,406.41 in the previous month. This is an average of $68.10 per customer. The purchases ranged from a $17.80 to $158.50. The average customer spent 12.8 minutes on the website. Time spent on the website ranged from 4.3 minutes to 32.9 minutes. The typical customer viewed almost five pages, with two as the minimum and ten as the maximum. The data set is summarized below in Table 1. Table 1 Summary of Online Sales Sample Time (min) Pages Viewed Amount Spent ($) mean 12.8 4.8 68.1 median 11.4 4.5 62.2 std dev 6.1 2 32.3 min 4.3 2 17.8 HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 3 Table 1 Summary of Online Sales Sample (Continued) Time (min) Pages Viewed Amount Spent ($) max 32.9 10 158.5 range 28.6 8 140.7 SUM ($) 3406.41 Note: Data compiled from the “Heavenly Chocolate Website Transactions Case Problem 4,” D. Anderson, D. Sweeney, T. Williams, J. Camm, & J. Cochran, 2015, Essentials of statistics for business and economics. (7th ed.), p. 167,168. Impact of Day of the Week on Sales The daily sales breakdown reveals some interesting patterns. Sunday is the lowest sales day, from the perspective of both total sales ($218.15) and average sales ($43.60). Monday and Friday were the best days in terms of overall sales performance. Monday had the highest mean (average) sales at $90.40, while Friday had the highest total sales at $945.43 for roughly 28% of the sample total. See Table 2 for a complete breakdown of the impact of the day of the week on amount spent, time spent on the website, and number of pages viewed. Table 2 Breakdown of Sales by Day of the Week Sun Mon Tues Wed Thurs Fri Sat Total mean 43.6 90.4 59.3 57 58.8 85.9 54.1 68.1 median 37.2 104.2 67.4 53.4 59.2 70.4 55.6 62.2 std dev 12.8 43.5 14.6 24.5 30.4 33.9 17.7 32.3 min 32.7 26.7 39.1 32.7 17.8 52.1 27.9 17.8 max 64.2 158.5 74.4 94.9 91.6 155.3 78.6 158.5 range 31.4 131.8 35.4 62.2 73.8 103.2 50.7 140.7 count 5 9 7 6 5 11 7 50 Total Sales HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 4 Table 2 Breakdown of Sales by Day of the Week (Continued) Sun SUM ($) 218.15 Mon Tues Wed Thurs Fri Sat Total 813.38 414.86 341.82 294.03 945.43 378.74 3,406.41 Time Spent mean 11.4 15.3 12.7 12.4 10.9 12.3 13.2 12.8 median 11.7 13.3 10.6 12 8.1 9.7 13.3 11.4 std dev 2.2 7.4 6 4.8 7.1 7.8 4.3 6.1 min 8 7.3 7.8 5 6.2 4.3 6 4.3 max 14.3 30.1 24.7 19.5 23.3 32.9 18.1 32.9 range 6.3 22.8 16.9 14.5 17.1 28.6 12.1 28.6 Pages Viewed mean 4.2 6.4 4 4.2 3.8 4.8 5.3 4.8 median 4 6 4 4.5 4 4 5 4.5 std dev 1.9 2.1 2.1 1.5 2 2.3 1.1 2 min 2 4 2 2 2 3 4 2 max 7 10 7 6 7 10 7 10 range 5 6 5 4 5 7 3 8 Note: Data compiled from the “Heavenly Chocolate Website Transactions Case Problem 4,” D. Anderson, D. Sweeney, T. Williams, J. Camm, & J. Cochran, 2015, Essentials of statistics for business and economics. (7th ed.), p. 167,168. By almost every measure, Monday is the best day for sales. Friday follows closely (see Table 2). It makes logical sense to recommend that the marketing department develop advertising targeted for Monday and Friday. Weekends are subpar and midweek statistics are nearly equivalent. Targeting sales or special packages for midweek may produce some increased traffic. If these recommendations are implemented, follow-up analysis is recommended to see if the desired results are being produced. HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 5 Impact of Browser on Sales There were also sales differences revealed by breaking the data down by browser type. Customers using Internet Explorer to complete their transactions accounted for the highest total sales at $1,656.81; however, this value was achieved on volume (see Table 3). Internet Explorer had the lowest average sale at $61.36 while Firefox customers averaged $76.80 per transaction. Table 3 Breakdown of Sales by Browser Firefox Internet Explorer Other Total mean 76.8 61.36 74.5 68.1 median 68 55.6 67.4 62.2 std dev 38.9 29.2 24.6 32.3 min 27.9 17.8 52.2 17.8 max 158.5 126.4 120.3 158.5 range 130.6 108.6 68.1 140.7 count 16 27 7 50 SUM ($) 1,228.21 1,656.81 521.39 3,406.41 Note: Data compiled from the “Heavenly Chocolate Website Transactions Case Problem 4,” D. Anderson, D. Sweeney, T. Williams, J. Camm, & J. Cochran, 2015, Essentials of statistics for business and economics. (7th ed.), p. 167,168. The opportunity here is to target premium packages for advertising specific to Firefox. Value packages could be created for advertising specific to Internet Explorer. This promotion should be combined with the recommendations given regarding days of the week and subjected to a follow-up analysis to check for results. Relationship between Amount Spent and Website Use The other feature of this analysis is to evaluate the relationship between amount spent by customers and how much time they spent on the website with the additional variable of number HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 6 of pages viewed also taken into account. For this, a correlation analysis was performed. The correlation coefficient between time spent on the website and amount spent in dollars was moderately positive (r = 0.58). A similar moderately positive correlation coefficient (r = 0.60) was found between the variables of time spent on the website and number of pages visited. The strongest correlation was found between number of pages viewed on the website and amount spent. This correlation coefficient (r = 0.72) approaches a strong positive correlation (see Figure 1). This suggests that there may be some merit in trying to guide customers to view more pages. 180.00 160.00 Dollars Spent 140.00 120.00 100.00 80.00 60.00 40.00 20.00 0.00 0 2 4 6 8 10 12 Pages Viewed Figure 1. Relationship Between Pages Viewed and Dollars Spent. Data compiled from the “Heavenly Chocolate Website Transactions Case Problem 4,” D. Anderson, D. Sweeney, T. Williams, J. Camm, & J. Cochran, 2015, Essentials of statistics for business and economics. (7th ed.), p. 167,168. A common tactic is to guide customers to pages that have also been viewed by other customers viewing the product on the current page. Another suggestion is to pair pages and suggest that customers who purchased the product on the current page also frequently purchased a product on the linked page. As with previous suggestions, follow-up analysis should be performed to check results. On a cautionary note, this can be overdone. The statement from HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) 7 Essentials of Statistics for Business and Economics that correlation is a measure of linear association and not causation should also be duly noted (Anderson, et al., 2015). Conclusion The analysis of this sample of 50 random customer transactions revealed several items to be used in the development of continued growth at Heavenly Chocolate. There is positive correlation between all three variables, but the strongest correlation is between number of pages viewed and amount of sales. There is adequate reason to pursue linking pages and making suggestions for customer purchasing. Monday and Friday are the best sales days. Firefox customers spend the most, but Internet Explorer customers provide the highest volume. Packaging and marketing strategies can be developed using this information. This analysis validates the use of statistical tools to provide insight into new strategies. Follow-up analysis is also mandated to find out if the strategies are producing results. HEAVENLY CHOCOLATES WEB SALES ANALYSIS (Sample) References Anderson, D.R., Sweeney, D.J., Williams, T.A., Camm, J.D., & Cochran, J.J. (2015). Essentials of statistics for business and economics. (7th ed.). Stamford, CT: Cengage Learning. 8 ...
Purchase answer to see full attachment

Tutor Answer

psumanrec
School: Duke University

Please find the answer to docs file along with the excel attached file.

West

Regional Hospital
Bell County
Danville
Eden Medical
Elton
Farr County
Fresno
Glendale
Heber Valley
Lakeview
La Paz
Main
Mountain View
Roosevelt
Ross General
Salem
South General
Total

Patients Last Year
4191
4382
1468
2223
2162
5125
7339
5418
5922
5157
4257
2840
2133
3354
3868
1096
60935

Central

Adams General
Columbus
Mercy Hospital
South Point
Total

5885
2634
3300
6991
18810

East

Atlantic
Branden
Carson General
Clifton General
Columbia
District Central
Drexel
Dubois Regional
Easton
Kent
Lake Shore
Medina
Monroe
Nathan Smith
O'connor
Rye

5694
4449
1169
2588
7548
1214
4622
2303
5016
5289
5914
4366
5899
5050
6859
6224

Southern Ocean
Trenton
Spring Harbor
Sun Coast
Total

6881
2687
1712
6347
91831

Highest Probability or Rank
Lowest Probability or Rank

Patients who Are
Dissatisfied
147
497
271
206
288
485
373
473
382
305
220
492
300
120
700
77
5336

Dissatisfied Patients who
Filed a Formal
79
34
77
72
58
52
73
93
87
54
40
27
20
91
88
18
963

449
213
300
451
1413

87
36
19
57
199

0,0763
0,0809
0,0909
0,0645
0,07512

438
318
342
312
382
300
103
361
490
346
269
216
365
361
428
484

36
70
31
46
59
73
11
60
51
39
79
37
42
58
79
74

0,07692
0,07148
0,29256
0,12056
0,05061
0,24712
0,02228
0,15675
0,09769
0,06542
0,04549
0,04947
0,06187
0,07149
0,06240
0,07776

P(Dissatisfied)
Rank by P(D)
0,03508
16
0,11342
6
0,18460
1
0,09267
8
0,13321
5
0,09463
7
0,05082
14
0,08730
9
0,06451
11
0,05914
12
0,05168
13
0,17324
3
0,14065
4
0,03578
15
0,18097
2
0,07026
10
0,08757
#N/A
3
2
1
4
#N/A
9
11
1
4
16
2
20
3
7
12
18
17
14
10
13
8

387
310
205
284
6701

88
74
57
37
1101

0,05624
0,11537
0,11974
0,04475
0,07297

15
6
5
19

P(Complaint
)
0,01885
0,00776
0,05245
0,03239
0,02683
0,01015
0,00995
0,01717
0,01469
0,01047
0,00940
0,00951
0,00938
0,02713
0,02275
0,01642
0,01580
0,01478
0,01367
0,00576
0,00815
0,01058
0,00632
0,01573
0,02652
0,01777
0,00782
0,06013
0,00238
0,02605
0,01017
0,00737
0,01336
0,00847
0,00712
0,01149
0,01152
0,01189

Rank by
P(C)
6
16
1
2
4
11
12
7
9
10
14
13
15
3
5
8
#N/A
1
2
4
3
#N/A
18
7
4
6
15
1
20
5
13
16
8
14
17
12
11
10

P(C|D) Rank by P(C|D) Sum of Ranks Overall Rank
0,53741
2
24
9
0,06841
14
36
2
0,28413
4
6
16
0,34951
3
13
15
0,20139
7
16
14
0,10722
13
31
7
0,19571
9
35
3
0,19662
8
24
9
0,22775
6
26
8
0,17705
11
33
5
0,18182
10
37
1
0,05488
16
32
6
0,06667
15
34
4
0,75833
1
19
12
0,12571
12
19
12
0,23377
5
23
11
0,18047
#N/A
#N/A
#N/A
0,19376
0,16901
0,06333
0,12639
0,14084
0,08219
0,22013
0,09064
0,14744
0,15445
0,24333
0,10680
0,16620
0,10408
0,11272
0,29368
0,17130
0,11507
0,16066
0,18458
0,15289

1
2
...

flag Report DMCA
Review

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors