Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Managers Using Microsoft Excel

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

7th Edition

978-0133061819, 133061817, 978-0133130805

More Books

Students also viewed these Accounting questions

Question

8. How do epinephrine and cortisol enhance memory storage?

Answered: 1 week ago