Washington State University ECON 452 Midterm Exam latest update

Document Content and Description Below

Health Economics ECON 452 Fall 2019 Instructor: Germán M. Izón Student full name: ____Mariah Huey_______ Midterm Exam (Online) Due date: Wednesday, November 13, 2019, at 11:59pm. *Please type... your answers in Word and submit a Word document *Please use a software, such as PowerPoint, to create graphs. *Do not forget to write your name. *GROUP COLLABORATION IS NOT ALLOWED UNDER ANY CIRCUMSTANCES. *MAKE SURE TO SHOW ALL YOU WORK. NO SHORTCUTS. *The work you submit has to be your own work and not the result of group work. *Late submission will not be accepted. 1) (16 points) Use the excel file I uploaded to Canvas and the following websites to answer the questions below: (The purple cells refer to dollar amount that you have to copy and paste from the links below. The green cells refer to cells you have to fill in with the formulas I provide in the excel file.) a. Follow the steps below to download total hospital expenditures and population. Go here: http://cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-andReports/NationalHealthExpendData/NationalHealthAccountsHistorical.html (this is the Centers for Medicare and Medicaid website). Download the zip file “National Health Expenditures by type of service and source of funds, CY 1960-2017”. (You will see two excel files. Please open the second file which is a “97-2003 Worksheet” type.) Look for “TOTAL HOSPITAL EXPENDITURES” (row 103). Copy and paste the “TOTAL HOSPITAL EXPENDITURES” dollar amount for the period 1996-2017 in the corresponding rows in the excel sheet I provided in Canvas. (How to copy and paste in excel: Click on cell “AL103” (dollar amount corresponding to year 1996). Then press and hold the “Shift” key while scrolling to the right until you get to the dollar amount that corresponds to the year 2017. Without letting the “Shift” key go, left click on the cell that corresponds to this amount. The “TOTAL HOSPITAL EXPENDITURES” amounts between 1996 and 2017 should be highlighted. Then, press “Ctrl” key and the “C” key at the same time. This will copy the highlighted cells. Then, go to the excel file I provided and paste these dollars in the corresponding years by right clicking and selecting the “123 (Values)” option under the “Paste Options”.) Also look for “POPULATION” (row 39). Copy and paste all these figures in the corresponding rows in the excel sheet I provided in Canvas, only for the period 1996-2017. (Please follow the procedure I describe above to copy and paste these figures.) Page 1 of 7 b. Follow the steps below to download nominal gross domestic product. Go here: (You will see two excel files. Please open the second file which is a “97-2003 Worksheet” type.) Look for "Gross Domestic Product" (row 10). Copy and paste all these figures in the excel sheet I provided in Canvas, only for the period 1996-2017. (Please follow the procedure I describe above to copy and paste these figures.) c. Complete all the remaining rows and submit the completed excel file as a separate document. (I am providing all the numbers for 1996 and 1997 as examples. If you click on cell “B4” you will see that the formula for “Per capita hospital expenditures” in 1996 is “Total hospital expenditures/Population in 1996. You can drag this formula by first clicking on the cell that already has the formula. Then, position your pointer on the bottom right corner of the cell and left click while dragging to the right. The formula for the “Per capita hospital expenditures growth rate” in 1997 is (“Per capita hospital expenditures in 1996” - “Per capita hospital expenditures in 1997”) / “Per capita hospital expenditures in 1996”.) d. Replicate the two graphs I uploaded to canvas. Please include both graphs at the bottom of the table you completed in excel for part c). In total, there should be two separate graphs. Here is a link that explains how to create a graph in excel with two vertical axes and one horizontal axis: https://www.techonthenet.com/excel/charts/2_y_axes.php Page 2 of 7 [Show More]

Last updated: 2 years ago

Preview 1 out of 7 pages