pleaae follow all directions using the provided data set  Assessment 1 Instructions: Descriptive Statistics and Data Visualizations Create a descriptive sta

Assessment 1 Instructions: Descriptive Statistics 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.

IntroductionIntroduction

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

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.

OverviewOverview

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

Data Analysis SoftwareData 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,

Course Navigation 

Tyler Zerwekh
FACULTY 

Kacie Goblirsch
COACH 

3/30/23, 5:13 AM
Page 1 of 4

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 Preparation 

Download the Assessment 1 Dataset [XLSX]. 

The dataset contains the