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.

https://courserooma.capella.edu/images/ci/icons/generic_updown.gifResources

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