variable “ newchg .” run frequencies B u s i n e s s F i n a n c e

variable “ newchg .” run frequencies B u s i n e s s F i n a n c e

Question 1(7.5 points)

Using the “disp” (disposition of patient) variable, answer the following questions:

a.What percent of all cases had a disposition of “within this hospital”?

b.What percent of all cases had a disposition of “to another hospital”?

HINT: You will probably want to recode the “disp” variable. Leave the codes 07 through 13 the

same. Check to see if there are values not specified in the Patient Data Discharge File Documentation.

Question 2(3.5 points)

Recode the variable “charges” so that charges of “0” and “1” are made system missing; all other charges should remain the same. Name this variable “NewChg.” Run frequencies on both the original and new charges variables. Paste the “Statistics” table (do NOT paste the frequency tables) showing the number of valid and missing cases for the old and new variables into your homework. (No sentence required.)

Question 3(14.5 points)

Is there a difference in charges (use the “NewChg” variable) between scheduled and unscheduled admissions (adm_type)?

Question 4(11 points)

Using all cases, is there a relationship between sex and ethnicity? “Ethncty” should be recoded into 2 categories – Hispanic and Non-Hispanic; “unknown” should be recoded to missing.)

Question 5(3 points)

Recode length of stay per the instructions in the Patient Data Discharge File Documentation into a new variable, NewLOS. (No sentence required.)

Question 6(3 points)

Using the new variables NewChg and NewLOS, create a variable for charge per day, ChargeDay, using this equation: NewChg / NewLOS. (No sentence required.)

Question 7(18 points)

Using the new variable for charge per day (ChargeDay), is there a difference in charge per day among patients in Alameda, Sacramento, and Santa Clara Counties?

Question 8(13.5 points)

Using all cases, is there a relationship between age (in years), charges, and length of stay? Use age_years, NewLOS, and NewChg.

Question 9(7.5 points)

Recode “agecat5” into 3 groups: age 17 and below, age 18-34, and age 35 and above. Using all cases, show the frequency tables for the old and new variables. What percent of individuals are 35 years and older?