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

#### Similar Solved Questions

##### 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...
##### 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...
##### 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...
##### 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...
##### 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?...
##### 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?...
##### 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...
##### 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...
##### 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...
##### 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...
##### 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...
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,...