Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Mr. Glenn Your Own Question

Mr. Glenn, Math and Stat Expert

Category: Calculus and Above

Satisfied Customers: 678

Experience: Math Professor for at least 15 yrs

79514296

Type Your Calculus and Above Question Here...

Mr. Glenn is online now

Final Project, Part I Calculation of Means and Comparison of

Customer Question

Final Project, Part I 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: • o 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.) o 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

********************************************************************************* If you are satisfied and happy with the answer, please choose a high rating. If you need more information, clarifications, or are not satisfied yet, choose 'Continue the conversation'. Bonuses are very much appreciated. Thanks! Kindly remember the ONLY WAY experts receive any credit at all for spending time with customers is if you click on OK, GOOD or EXCELLENT SERVICE even though you have made a deposit or are a subscription customer. YOU MUST COMPLETE THE RATING FOR THE EXPERT TO RECEIVE ANY CREDIT. So kindly do not forget to rate the answers, thanks!

hi, sorry for late reply can I ask for an excel file of these raw data so that it will be faster to compute the measures of central tendencies and variabilities of these data. Please reply asap. sorry for late reply, I have some minor internet connection problem only.. Please reply asap.

I sent you the data but I see that you did not do the final project, part 1 calculation could you tell me when would be able to get it done? Plus it has to go on excel.

I mean kindly sent me the data in excel form, but what I received is the raw data not in excel form, and with this kind of presented data, it is really hard to treat statistically the data, in the first place, the commas, place values are all mixed up, please send the data in excel form

here is the excel file: please copy the link and download the said excel file: https://www.mediafire.com/?704lqb2u7zz116h ********************************************************************************* If you are satisfied and happy with the answer, please choose a high rating. If you need more information, clarifications, or are not satisfied yet, choose 'Continue the conversation'. Bonuses are very much appreciated. Thanks! Kindly remember the ONLY WAY experts receive any credit at all for spending time with customers is if you click on OK, GOOD or EXCELLENT SERVICE even though you have made a deposit or are a subscription customer. YOU MUST COMPLETE THE RATING FOR THE EXPERT TO RECEIVE ANY CREDIT. So kindly do not forget to rate the answers, thanks! ********************************************************************************* You can request me in future by writing "For Mr. Glenn only".

Mr. Glen, we're finished with that one. The next one I'm talking about is the final project where 2001-2005 • 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: • o 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.) o 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.

Customer:replied 1 year ago.

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: • o 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.) o 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.

The calculated means are in the excel file, I even calculated the standard deviations of each stated variables, please check first the excel file ( the 2nd mediafire I sent you)

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.) o 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.09 August 2015 08:30Once 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: • o 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.) o 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.

Here are the updated excel and word file which include the last questions/summary please copy the link and download the said excel file: https://www.mediafire.com/?704lqb2u7zz116h https://www.mediafire.com/?ko1mk25mcm1u7v1 ********************************************************************************* If you are satisfied and happy with the answer, please choose a high rating. If you need more information, clarifications, or are not satisfied yet, choose 'Continue the conversation'. Bonuses are very much appreciated. Thanks! Kindly remember the ONLY WAY experts receive any credit at all for spending time with customers is if you click on OK, GOOD or EXCELLENT SERVICE even though you have made a deposit or are a subscription customer. YOU MUST COMPLETE THE RATING FOR THE EXPERT TO RECEIVE ANY CREDIT. So kindly do not forget to rate the answers, thanks! ********************************************************************************* You can request me in future by writing "For Mr. Glenn only".