Quantitative Analysis
Answer the following questions, showing your work in an Excel spreadsheet.
1. For the following variables, state what kind of measurement is being used? (Nominal, Ordinal, Interval, Ratio)
a. Geographic Region
b. Control
c. Payroll Expenditure
2. Create a frequency distribution for the beds variable.
3. From that frequency distribution, make a histogram.
4. Using information from the first 8 hospitals in the dataset, make a pie chart for the payroll expenditure variable.
5. Using information from the first 8 hospitals in the dataset, make a stem and leaf plot for the personnel variable.
6. Looking at the graph from questions 4 and 5, ¿can you spot a relationship between the two variables, payroll and personnel? Explain.
Geographic Region
1 South
2 Northeast
3 Midwest
4 Southwest
5 Rocky Mountain
6 California
7 Northwest
Control
1 government, nonfederal
2 nongovernment, not-for-profit
3 for-profit
4 federal government
Service
1 general medical
2 psychiatric
Beds Number of beds
Admissions Number of admissions
Census
Outpat. Visits Number of outpatients
Births Number of births
Tot. Exp. Total expenditures
Payroll Exp. Payroll expenditures
Personnel