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.

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Answer a percentage change for average HCS spending in each region from year to year 2012 2013 2... View the full answer