Tnhosp

Fall 2015 ECON 2040-98

Data Analysis and Writing Assignment

Dr. Achintya Ray (Phone: 615.963.7347; Email: aray4@tnstate.edu )

Due Date: 11.00pm (US Central Time) December 04, 2015

This assignment is counts 15% towards your final grade.

A bonus up to 5% may be granted for superlative performance in this assignment.

Please complete the assignment and write your answers to each and every question below in much detail as possible. Your answers must be typed neatly in a Microsoft Word (Times New Roman Font, 12pt, Single Spaced) document and uploaded to the Dropbox section under Assessment for this course on Elearn. No hardcopy submission will be accepted. Please make sure that you submit by the deadline mentioned above. No late submissions will be accepted.

University honor code will be strictly enforced for this assignment. Your submission must reflect your work. All group submissions are STRICTLY PROHIBITED. Any form of plagiarism will be penalized in accordance to existing university rules and policies.

The accompanying Microsoft Excel file “tnhosp.xls” has the following data for 96 Tennessee hospitals: Hospital Name, City, Staffed Beds, Total Discharges, Patient Days, and Gross Patient Revenue.

This data is somewhat dated, and it should not be used to draw a conclusion about the current state of hospital finances in Tennessee. The purpose of this exercise is purely academic in nature, and it is aimed towards understanding your command of basic statistical theories and applications.

1. Find the mean number of hospital beds in Tennessee Hospitals. Also, find the median, variance, standard deviation, 95% confidence interval, 90% confidence interval, and 99% confidence interval of the same. Present your results neatly in a table.

2. Find the mean number of total discharges in Tennessee Hospitals. Also, find the median, variance, standard deviation, 95% confidence interval, 90% confidence interval, and 99% confidence interval of the...