# Project part 1

**Calculation of Means and Comparison of Means**

**To prepare** for this first Final Project assignment, it is suggested that you first review pertinent information that was presented in previous weeks of this course (e.g., topics related to measure of central tendency).

**To complete** the assignment, **examine** the data provided in the VirginiaHospitals_2001-2005 database. Save a version of this Microsoft Excel document to use to complete your assignment.

Next, **calculate the mean** for each of the variables below for the year 2001:

- Total Operating Expense
- Net Charity Care
- RN FTEs
- Payroll Expenses
- Bad Debt Expenses
- Staffed Beds
- Occupancy*
- Medicare Days
- Medicaid Days
- Total Surgeries
- Outpatient Visits
- Emergency Visits

*Occupancy must be calculated as Patient Days/(Licensed Beds X 365).

Then, **calculate the mean** for the same set of variables for the year 2005.

Finally, **compute the changes** between the two sets of means (for 2001 and 2005) and **test for significant differences** using a comparison of means test.**Note:** Your version of Microsoft Excel may differ, but many students will be able to do this test by clicking on Tools, Data Analysis, t-Test Paired Two Sample for Means.

Once you have performed all of the above tasks, use the resultant data to **complete the written analysis** portion of this assignment, for which you will need to **submit the following**:

**A Microsoft Excel table**that shows the calculated values for each year and the differences in means.**A Microsoft Word document**that includes:- A paragraph that summarizes these changes and reports the statistical significance of the differences between 2001 and 2005 for each of the above variables. (Indicate significance or no significance both in the Microsoft Excel table and in this paragraph.)
- A one-half to 1 page that addresses the following: What can you conclude about the data? What are some implications for health care professionals regarding the performance of hospitals in this state in the period from 2001 through 2005? Provide your rationale.

- A paragraph that summarizes these changes and reports the statistical significance of the differences between 2001 and 2005 for each of the above variables. (Indicate significance or no significance both in the Microsoft Excel table and in this paragraph.)

Your written assignments must follow APA guidelines. Be sure to support your work with specific citations from this week's Learning Resources and additional scholarly sources as appropriate. Refer to the*Essential Guide to APA Style for Walden Students* to ensure your in-text citations and reference list are correct.

**Answers 1**

Purchase the answer to view it

**Other questions 10**

- lab
- Assignment 2: Cost of Debt and Equity
- read the article and questions and answer it
- DBM 380 Week 4 Normalization of the ERD explanation
- Microeconomics Market Structure Paper
- DUE: 3/16/2015 @ 2pm est. for $10…..PLZ CHARGE THE ENTIRE $10.00 W/HAND SHAKE. THXS.
- what is the economic market for physicians in terms of supply and demand, elasticity, costs of production, pricing, and economic...
- philosophy assignment
- Project 2 "For king Dennis only"
- FIN 534 Week 5 Quiz 4

**Multiple Regression Analysis****To prepare**for this second Final Project assignment, it is suggested that you review pertinent information presented in previous weeks of this course (e.g., topics …#5238 Topic: Final Project, Part I

Number of Pages: 1 (Double Spaced)

Number of sources: 1

Writing Style: APA

Type of document: Essay

Academic Level:Master

Category: Healthcare

VIP …