San Diego State University Analyze Health Data Excel Worksheet

To complete this assignment, use the Excel file, “Data for Assignment 1,” posted on Blackboardin the Excel Assignment folder on the “Assignments” tab.It is preferred that students work in pairs on assignments, with one assignment submitted perpair; both students in a pair will receive the same grade. It is strongly recommended that bothstudents actively participate in preparing the assignment. If, instead, partners choose to splitthe assignment (with each being responsible for different parts of the assignment), be awarethan one person’s poor/non-completion of his/her portion is NOT an acceptable reason forsubmitting the assignment late. You may work with a student in the Wednesday section; if youdo, please note that when you upload your assignment.At the completion of your assignment, you should have one workbook with four tabs (theoriginal three tabs + one worksheet you have created). Name the file as follows:OurNamesAssign1.xlsx (or NamesAssign1.xls), where you replace OurNames with your firstinitials and last names. Your name(s) must be a part of your file name. Upload your completedExcel document to Blackboard on the assignment page.

INSTRUCTIONS – READ CAREFULLY:When it is appropriate to show decimals, you should show 2 decimal places; use of decimalplaces should be consistent within a column (or variable). Use cell referencing in all formulas,and use functions that we have discussed in class whenever possible; a significant part of yourgrade is dependent on your use of appropriate cell referencing and use of functions.TIPS: Make it easy to locate all requested information. You can use bold or another font coloror try using the paint can to fill the cell with color ( ) Use column/row titles to describe thedata included. Use column and row columns to describe the data included.To receive full credit, you will need to follow all instructions

Question 1 (27 points)Using the Fourth Quarter 2019 California Hospital Quarterly Financial and Utilization data (thefirst tab in the “Data for Assignment 1”), copy the San Diego and Los Angeles County hospitalsto a new worksheet within this workbook. (Copy the rows holding the variable names and LosAngeles and San Diego County hospitals as described in class; do not copy the wholePH 307 Fall 20202worksheet.) Name this tab “San Diego and Los Angeles.” Sort this worksheet by county. Removeany hospitals where the results of your calculations equal “#DIV/0!.” (To make the data easierto work with, I suggest that you hide columns that you will not need to answer the question.)A. Calculate the net inpatient revenue (est.) for each hospital located in San Diego County andLos Angeles County. (Hint: You will need to refer to the OSHPD documentation to determinehow to calculate the net inpatient revenue.)

the full instructions are attached.