Statistics

Descriptive Statistic and Data Visualizations

· Create a descriptive statistics table and histogram for selected variables in a dataset. Write a 2–3-page narrative summary in a Word document and insert the table and histogram graphic into this document.

Note: You are strongly encouraged to complete the assessments in this course in the order they are presented. 

Show Less

Descriptive statistics play an important role in analyzing data. It numerically summarizes key characteristics of variables. Measures of central tendency (mean, median, and mode) and dispersion (variance, standard deviation, and range) characterize the probability distribution. A histogram visualizes the distribution of numerical data indicating the number of data points that lie within a range of values. For this assessment, you will perform descriptive statistics and create a histogram for selected variables in a dataset.

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

· Competency 2: Analyze data using computer-based programming and software.

1. Perform the appropriate descriptive statistics for selected variables in a dataset.

. Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice.

2. Interpret statistical results used in the   data analysis. 

. Competency 4: Present results of data analysis to support a decision or recommendation.

3. Create a histogram that visually depicts the distribution of selected variables in a dataset.

3. Write a narrative summary of the results that includes practical, administration-related implications of the descriptive statistics.

. Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style.

4. Write clearly and concisely, using correct grammar, mechanics, and APA formatting.

Resources

Excel

. Descriptive Statistics With Excel.

. Microsoft Office Software.

6. Visit this page for general help with Microsoft Excel. It offers tip sheets and in-depth tutorials.

. Frey, B. B. (Ed.). (2018). Excel. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.

. Microsoft. (n.d.). Load the analysis ToolPak in Excel. Retrieved from https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4?redirectSourcePath=%252fen-US%252fArticle%252fLoad-the-Analysis-ToolPak-305c260e-224f-4739-9777-2d86f1a5bd89&ui;=en-US&rs;=en-US&ad;=US

. Statistics in Excel.

Show Less

Descriptive Statistics 

. Tutorials for Statistical Data Analysis. (n.d.). Descriptive statistics using Microsoft Excel. Retrieved from https://www.stattutorials.com/EXCEL/EXCEL-DESCRIPTIVE-STATISTICS.html

. Frey, B. B. (Ed.). (2018). Descriptive statistics. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.

. Microsoft Virtual Academy. (2016).  Data analysis with Excel: Descriptive statistics with data analysis add-in [Video] | Transcript. Retrieved from https://mva.microsoft.com/en-us/training-courses/data-analysis-with-excel-16654?l=GIk9CQ8sC_5506573942

Data Presentation

. Frey, B. B. (Ed.). (2018). Data visualization methods. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.

. In, J., & Lee, S. (2017). Statistical data presentation. Korean Journal of Anesthesiology, 70(3), 267–276. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5453888/

Interpretation and Analysis

. Understanding and Selecting Inferential Techniques.

. Statistics and Business Analytics: Interpretation and Analysis.

Histograms

. Colette, C. (n.d.). Histogram. | Transcript. Retrieved from https://www.sophia.org/tutorials/histogram--11

. Baxter, J. (n.d.). Histogram | Transcript. Retrieved from https://www.sophia.org/tutorials/histogram--11

. Real Statistics Using Excel. (n.d.). Histograms. Retrieved from http://www.real-statistics.com/descriptive-statistics/histograms/

. Microsoft Virtual Academy. (2016).  Data analysis with Excel: Histograms in Excel 2016 [Video] | Transcript. Retrieved from https://mva.microsoft.com/en-us/training-courses/data-analysis-with-excel-16654?l=yD5KWP8sC_3406573942

Measures of Central Tendency

. Real Statistics Using Excel. (n.d.). Measures of central tendency. Retrieved from http://www.real-statistics.com/descriptive-statistics/measures-central-tendency/

Textbook

The following text provides instruction in statistics.

. Kros, J. F., & Rosenthal, D. A. (2016). Statistics for health care management and administration: Working with Excel (3rd. ed.). San Francisco, CA: Jossey-Bass. Available in the courseroom via the VitalSource Bookshelf link.

· Asssessment Instructions

Note: Complete the assessments in this course in the order in which they are presented.

Data Analysis Software

To complete the assessments in this course, you will need to use data analysis software to complete statistical calculations, create graphs, and tabular summaries, and share your results in a Microsoft Word document. You will use Microsoft Excel and Microsoft Excel Analysis ToolPak add-in. Be aware that not all statistical calculations, graphs, and tabular summaries can be completed in this software, so you may need to do some work outside of the software.

Microsoft Excel Data Analysis ToolPak Add-In for PC and Mac

Microsoft Excel Analysis ToolPak Activation for PC Users: The Microsoft Excel Analysis ToolPak is a specialized Excel add-in included in the standard Microsoft Office suite. If your Excel software meets the standard Capella University Computer Requirements , you will not need to purchase this software. However, you may need to activate the application before you can use it. If you do not own Microsoft Excel, Capella arranges for a significant discount for Microsoft Office for Capella learners. 

The following provides an overview of the Analysis ToolPak, instructions for loading and activation and instructions on using the ToolPak to perform data analysis. Note that these instructions are for 2016 and older versions of Microsoft Excel for PC and for the 2016 version only for Mac. If you are using a different version, you may need to search Microsoft's website for the appropriate instructions.

. Use the Analysis ToolPak to Perform Complex Data Analysis .

Preparation 

Download the Assessment 1 Dataset [XLSX] . 

The dataset contains the following variables:

. utilization (average number of patient days per month).

. satisfaction (patient satisfaction scores percentile rank).

. readmissions (readmission rate per month).

Instructions

Nursing home administration has the objectives of higher utilization, higher patient satisfaction, and lower readmissions, and they need to make a decision on whether to retain the department manager based on average performance over the past 70 months. For this assessment, create a descriptive statistics table and histogram based on the Assessment 1 Dataset. Write a narrative summary in a Word and insert the table and histogram graphic into this document. See Copy From Excel to Another Office Program for instructions. Submit both the Word document and the Excel file that shows the descriptive statistics output.

Grading Criteria

The numbered assessment instructions outlined below correspond to the grading criteria in the Descriptive Statistics and Data Visualizations Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed.

· Perform the appropriate descriptive statistics for selected variables in a dataset.

. Report descriptive statistics table with measures of central tendency and dispersion.

· Create a histogram that visually depicts the distribution of selected variables in a dataset.

· Interpret statistical results used in the data analysis.

· Write a narrative summary of the results that includes practical, administration-related implications of the descriptive statistics.

. Write a separate summary for the histogram.

· Write clearly and concisely, using correct grammar, mechanics, and APA formatting.

Additional Requirements

Your assessment should meet the following requirements:

· Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.

· Length: 2–3 pages

· Resources: Not applicable.

· APA format: Cite your sources using current APA format.

· Font and font size: Times Roman, 12 point.