Health Information Technology Occupancy Rate Calculation Help

Once you review the relevant material, discuss the following

  1. Based on the data presented in the table below, calculate the average daily census for each month, average length of stay for the quarter, and occupancy rate for each month and the quarter. Round to one decimal point. Analyze the data given; which month had the highest occupancy rate? Does the decision to increase the bed count for March seem supported by the current data? Explain your answers, and show your work either by attaching an excel spreadsheet with your calculations or by typing how you performed the calculations as text. Please make sure to provide details and explanations, and use your own words.
Month Total Admission Total Discharges Inpatient Service Days Total Length Stay Bed Count
January 1035 998 6850 6550 260
February 981 978 7200 6870 260
March 932 944 7350 5930 300

Select two of these topics to post about in order to help everyone study:

Mean, Median and Mode

LOS

Inpatient vs outpatient

Aggregate data

C-section rate

Inpatient death rate

Pie chart

Line chart

Bar chart

Histogram

Pareto chart

Incidence rate

Daily patient census

Inpatient service day

Autopsy rate

Executive information system

X12N

CONNECT system

Unstructured vs structured data

eHealth Exchange- what is it?

Descriptive analytics

Predictive analytics

Data provisioning

Data mining

Quantitative vs qualitative study- what is the difference?

Big data