Dataset: (may be downloaded below.) Required analysis program: (RStudio or R Programming for BONUS point seekers only – 10 bonus points if used for analysis). Author, Hossein Zare, PhD Citation: Zare, H. (2017). HMGT 400 Research and Data Analysis in Health Care-Exercise. UMGC.EDU 1. You may download the dataset from the link below. This dataset provides information about hospitals in 2011 and 2012. Before you do that however consult the additional instructions that I provided to you in 4 PDF email attachments.  ([a]. Ex 1 – Additional Instructions. [b] Ex 1 – Instructions t-Test to compare means [c] Ex 1 – Example t-Test Output. [d] Ex 1 – Example Output – Graphs). 2. Analyze the data, using these instructions. Your objective is to use the results of your analysis to create “summary statistics” (Count (N), Mean, and Standard Deviation) for each hospital characteristic and each year (2011 and 2012) and complete Table 1 (template below). You should then create any meaningful graphs (using Excel) to summarize your findings and to write a short paragraph summary report describing your findings. 3. Your report may be in WORD format, with the tables you create in Excel copied and pasted in WORD. Submit your report to the appropriate folder.

In this assignment, we are provided with a dataset containing information about hospitals in the years 2011 and 2012. The goal is to analyze the data using the provided instructions and to create “summary statistics” for each hospital characteristic and each year. Additionally, we are required to complete Table 1 using the template provided, create meaningful graphs using Excel, and write a short paragraph summary report describing our findings.

To start the analysis, we need to download the dataset from the provided link. It is important to consult the additional instructions provided in the form of four PDF email attachments before proceeding with the analysis. These attachments include instructions on conducting a t-Test to compare means, an example t-Test output, and example outputs with graphs.

Once we have downloaded the dataset and familiarized ourselves with the additional instructions, we can begin analyzing the data. The objective of the analysis is to calculate the “summary statistics” for each hospital characteristic and each year. The summary statistics include the count (N), mean, and standard deviation. We will need to calculate these statistics for both the 2011 and 2012 data.

After calculating the summary statistics, we are required to complete Table 1 using the provided template. The table should include the hospital characteristics as rows and the years (2011 and 2012) as columns. The summary statistics should be filled in for each cell in the table.

In addition to completing Table 1, we are also expected to create meaningful graphs using Excel to summarize our findings. The type of graphs to be created will depend on the characteristics of the data and the objectives of the analysis. These graphs should effectively communicate the main findings of the analysis.

Finally, we need to write a short paragraph summary report describing our findings. The report should provide a concise overview of the main results obtained from the analysis. It should highlight any interesting or significant findings and provide context for the conclusions drawn from the data.

The report may be in WORD format, with the tables created in Excel copied and pasted into WORD. Once the report is complete, we can submit it to the appropriate folder as instructed.

To complete this assignment, we have the option to use either RStudio or R Programming for the analysis. Using R Programming will earn bonus points for those seeking the extra challenge.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer