Question
Can you please help me with this question? Explain health care spending in each region of the state in 2013 a. Using the data listed
Can you please help me with this question?
Explain health care spending in each region of the state in 2013
a. Using the data listed below (in millions), calculate the percentage change for average HCS spending in each region from year to year. Describe the findings using only percentages (round the percentages to one digit to the right of the decimal) in your table.
b. Using the data listed above, calculate the percentage of the budget that is represented by each revenue source for each fiscal year. Each fiscal year should total 100%.
c. Using the HCS percentage change data that you calculated in 5a, create line graphs describing the growth or decline in spending by region. Note: The various regions should appear in the legend, not the year. All of these graphs should be completed in one step.
d. Using the original raw data for the City of Alexander Health Care Spending allocations described above, create line graphs describing the growth or decline in spending by region. All of the regional line graphs should be completed in one step (one graph with five lines). Also, format the data labels so that the dollar amount for each year and region appears on the graph. Note: The various regions should appear in the legend, not the year.
her, except fair uses permit Health Care Spending in Alexander, FY 2010-FY 2014 Region 2011 2012 2013 2014 (est.) 2015 (est.) Central $3,890 $4,090 $4,862 $5,300 $6,000 2,890 3,498 East North 3,723 4,400 5,500 4,798 4,990 5,074 5,600 6,200 18,987 17,903 15,300 14,000 South 13,000 West Total 5,790 5,981 5.611 6,450 7,500 $30,368 $37,546 $37,173 $37,050 $39,200 h. Using the data listed above calculata
Step by Step Solution
3.34 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
Answer a percentage change for average HCS spending in each region from year to year 2012 2013 2...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started