### Problem 1

Discussion Board Exercises

Compute the average patient to provider ratio and evaluate the results in terms of the health care quality.

Compute the percentage of board certified providers and evaluate the results in terms of health care quality.

Compute the percentage of patients who received preventive services and evalute the results in terms of health care quality. What recommendations could you make to the board of directors?

Compute the surgical mortality rate and evaluate the results in terms of health care quality. What recommendations could you make to the board of directors?

Use a line graph to display the surgical mortaliy rate by month and discuss the results in terms of trend. What recommendations could you make to the board of directors?

Use a bar chart to display the average # of patients by month. Which months has the greatest amount of patients? Which months has the least amount of patients? If these patients are school-aged children, what could explain these differences?

Problem 2

Create a table showing the average breast cancer screening rates by year for both hospitals.

Create a table showing the total and average breast cancer costs by year for both hospitals.

Using one bar chart, display the average breast cancer screening rates by year for each hospital.

Using one bar chart, display the average breast cancer costs by year for each hospital.

For each hospital, use a pie chart to show the percentage of cancer cost contribution by year to the overall 2015â€“2017 cancer total costs. Which year was responsible for most of the cancer cost during this period?

Create a visualization to forecast screening rates for each hospital.

Summarize your findings in one paragraph by comparing hospitalsâ€™ breast cancer screening rates. Which hospital needs a change in breast cancer screening policy? Why does this policy change matter to health care?

Compute a correlation statistic to examine the association between breast cancer screening rates and breast cancer costs for both hospitals. Interpret both correlation statistics in terms of direct/inverse association and terms of weak/moderate/strong association. What is your overall conclusion about the relationship between breast cancer screening rates and breast cancer costs? What specific policy recommendations could you provide to the hospital board at Southern Hospital Group?

Create a storyboard with a narrative.

Create a dashboard.

Contact us to get complete solution of above both tableau problems at:

And get instant help with an affordable price. Here you get all tableau related help like Tableau Data Analysis, Tableau Visualization, Tableau Dashboard and more other topics related to tableau.

## Comments