1 answer

5. (8 points) In this question we want to plot the aggregate personal expenditure on health...

Question:

5. (8 points) In this question we want to plot the aggregate personal expenditure on health care as percentage of GDP. You will get data from the Bureu of Economic Analysis. Go to the BEA website http://www.bea.gov/iTable, and click on GDP& THIS VERSION: JANUARY 10, 2019 PROF. NATALIA KOVRIJNYKH W. P. Carey School of Business Arizona State University ECN 313 - SPRING 2019 Personal Income under National Data. Download annual data from Tables 1.1.5 and 2.4.5 (Click on each tables link, then click on OPTIONS on top right corner. If you are given the option, select Annual. Check Select All Years and click on Update Now click on DOWNLOAD and select Download XLS File.). Take the following lines (for all years) from Table 2.4.5 and copy them in a new excel sheet . Therapeutic appliances and equipment (Line 21) Pharmaceutical and other medical products (Line 40) . Health care (Line 60) . Net health insurance (Line 93) Now add up all lines. What you have now is the aggregate personal expenditures on health care in current prices (in billions of dollars). Now get line 1 in Table 1.1.5 and copy it into the same excel sheet. This is Gross Domestic Product (GDP) in current prices (in billions of dollars). Divide aggregate personal expenditures on health care (which you calculated following the above instruction) by GDP and plot it. What do you notice!

5. (8 points) In this question we want to plot the aggregate personal expenditure on health care as percentage of GDP. You will get data from the Bureu of Economic Analysis. Go to the BEA website http://www.bea.gov/iTable, and click on GDP& THIS VERSION: JANUARY 10, 2019 PROF. NATALIA KOVRIJNYKH W. P. Carey School of Business Arizona State University ECN 313 - SPRING 2019 Personal Income under National Data. Download annual data from Tables 1.1.5 and 2.4.5 (Click on each table's link, then click on "OPTIONS" on top right corner. If you are given the option, select "Annual". Check "Select All Years" and click on "Update" Now click on "DOWNLOAD" and select "Download XLS File".). Take the following lines (for all years) from Table 2.4.5 and copy them in a new excel sheet . Therapeutic appliances and equipment (Line 21) Pharmaceutical and other medical products (Line 40) . Health care (Line 60) . Net health insurance (Line 93) Now add up all lines. What you have now is the aggregate personal expenditures on health care in current prices (in billions of dollars). Now get line 1 in Table 1.1.5 and copy it into the same excel sheet. This is Gross Domestic Product (GDP) in current prices (in billions of dollars). Divide aggregate personal expenditures on health care (which you calculated following the above instruction) by GDP and plot it. What do you notice!

Answers

Relaut asgegot deand, aagegae pphy aph Shending aneneny xei encing a Seppy b He lohoe ot guun Jevels ncessicn uld be anEp onaynhat ent andPrice level LRAS SRAS P* Recession ary AD Real GDPahoie the kengBgd hoh rites 9ugimed chich Can core a leng faa encrease 8, 9adudton in .guenamend ospending this sh:熟 to the ofoPrice level LRAS SRAS AD YF Y* Real GDPA Cmon ags these cete ?es us mis and tHn plemeding th bcres have thein cren inside and aus ide las makingidt A

.

Similar Solved Questions

1 answer
Pivot Question 2 (20 points) A pendulum consists of a thin, solid, cylindrical-rod and a mass...
Pivot Question 2 (20 points) A pendulum consists of a thin, solid, cylindrical-rod and a mass (bob) at the end as shown. The bob can be approximated as a flat plate. The mass of the rod cannot be neglected. Both the rod and the bob have uniform mass density. The pendulum is displaced 5° from its...
1 answer
V Question 11 5 pts A square planar loop of coiled wire has a length of...
V Question 11 5 pts A square planar loop of coiled wire has a length of 0.25 m on a side and is rotated 60 times per second between the poles of a permanent magnet. The magnetic field between the poles is 0.75 T. If a peak voltage of 1 kV is generated in the coil, how many turns does it have? 56 tur...
1 answer
What is the difference between the global health security and humanitarian biomedicine approaches to global health?...
What is the difference between the global health security and humanitarian biomedicine approaches to global health? Do you think one approach is better than the other and What are the primary sources of regional inequalities in health outcomes? What could be done to improve health outcomes for those...
1 answer
Ordered: Humulin R 67 units Available: Humulin R 100 units/ml After calculating the patient's dose, select...
Ordered: Humulin R 67 units Available: Humulin R 100 units/ml After calculating the patient's dose, select the type of syringe(s) that are most appropriate for administering your calculated dose. select all that apply ... a) Tuberculin syringe b) 1 ml syringe c) 100 unit syringe d)50 unit syring...
1 answer
If understate expenses to inflate profit which account and assertion are at risk of misstatement?
If understate expenses to inflate profit which account and assertion are at risk of misstatement?...
1 answer
8. (arbitrage) Assume that the pound sterling is worth Euro 3.80 in Paris and SFR 5.40...
8. (arbitrage) Assume that the pound sterling is worth Euro 3.80 in Paris and SFR 5.40 in Zurich. Show how British arbitrageurs can make profits given that one Swiss franc is worth 2 euros. What would be the profit per pound?...
1 answer
QUESTION 4: P6-4A Sandoval Skateshop Ltd. reports the following inventory transactions for its skateboards for the...
QUESTION 4: P6-4A Sandoval Skateshop Ltd. reports the following inventory transactions for its skateboards for the month of April. The company uses a perpetual inventory system. Date Explanation        Units Unit Cost Total Cost Apr. 1 Beginn...
1 answer
Only final answers plz 21. The accounting basis that records revenues when goods or services are...
only final answers plz 21. The accounting basis that records revenues when goods or services are provided to customers and expenses with related revenues is referred to as: A. Cash-basis. B. Matching-basis. C. Accrual-basis. D. Reporting-basis. 22. Consider the following events for Sophia Incorp...
1 answer
Question 19 2 pts In the following ODE, y is the independent variable. dy der 5ytet...
Question 19 2 pts In the following ODE, y is the independent variable. dy der 5ytet True O False Question 20 2 pts Which of the following is the simplest Runge-Kutta method? Euler Heun O Midpoint Ralston...
1 answer
Suppose a country's debt is $630 billion before Year 1. Using the information below, fill in...
Suppose a country's debt is $630 billion before Year 1. Using the information below, fill in the blanks for its budget balance and debt for the following years: 1. Expenditures Debt $202 Revenues Year 1 $203 Year 2 $215 Year 3 $227 Year 4 Year 5 $258 $626 $221 $230 $243 $619...
1 answer
Use the following information from separate companies a through f. i suoi oci Net Income (Loss)...
Use the following information from separate companies a through f. i suoi oci Net Income (Loss) $159,000 153,600 162,100 135, 150 103,350 (44,520) Interest Expense Income Taxes $73, 140 $39,750 59,904 55, 296 8,105 77,808 47,303 56,763 13,436 39,273 96,608 1. Compute times interest earned. 2. Which ...
1 answer
Ed to Instructie Prepare the 510-7 warehou building how it should be reported. newly formed corporation,...
ed to Instructie Prepare the 510-7 warehou building how it should be reported. newly formed corporation, incurred the ST0-(L01,3) (Treatment of Various Costs) Ben Sisko Supply Company Equipment mg expenditures related to Land, to Buildings, and to Machinery and $ 520 Abstract company's fee for t...
1 answer
What is lattice parameter? 2. what is Atomic structure factor for bcc and fcc? 1=0.154 nm...
what is lattice parameter? 2. what is Atomic structure factor for bcc and fcc? 1=0.154 nm 4000 3500 43.3 3000 2500 Intensity 2000 Intensity (Arb. units) 50.4 1000 74.1 89.9 500 سلسال 0.0 20.0 40.0 60.0 80.0 100.0 40 80 60 20 (deg) Diffraction angle 20 We were unable to...
1 answer
Issue Price The following terms relate to independent bond issues: 660 bonds; $1,000 face value; 8%...
Issue Price The following terms relate to independent bond issues: 660 bonds; $1,000 face value; 8% stated rate; 5 years; annual interest payments 660 bonds; $1,000 face value; 8% stated rate; 5 years; semiannual interest payments 860 bonds; $1,000 face value; 8% stated rate; 10 years; semiannual i...
1 answer
For each of the following independent situations, indicate whether there is an apparent internal control weakness,...
For each of the following independent situations, indicate whether there is an apparent internal control weakness, and, if one exists, suggest alternative procedures to eliminate the weakness. 1. John Smith is the petty cash custodian. John approves all requests for payment out of the $200 fund, whi...
1 answer
42.3) Write down the solutions to the follig inboundary value problems for the wave equation in t...
#4.2.3 (e, f, g only) & #4.3.11 (all of it) 42.3) Write down the solutions to the follig inboundary value problems for the wave equation in the form of a Fourier series: (a) utt = uzz , u(t, 0) = u(t, π) = 0, a(0,2) 1, ut(0,x) = 0; (d) ut4u (e) ut.-uzz , u(t, 0)u1) 0, u(0,), u, (0,x; u(t,...