M2LA10
docx
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
8390
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by GrandMouse3342
CST8390 Business Intelligence and Data Analytics
Module 2: Activity 10 - Simulation: Descriptive Analytics: Microsoft Excel
Instructions
Load Data Analysis ToolPak
1.
In an open Excel workbook select
File > Options
and, when the Options dialogue box appears,
click
Add-ins
.
2.
In the
Manage
drop down menu select
Excel Add-ins
, then click
Go
.
3.
When the
Add-ins
dialogue box appears, select the
Analysis ToolPak
check box, then click
OK
.
4.
You will find the
Data Analysis
ToolPak in the
Ribbon
of the
Data
tab.
Calculate Descriptive Statistics
1.
Open the workbook entitled
module-2_activity-8_raw-data
and select the
descriptive-success-
percent
tab.
2.
Select the
Data
tab, click the
Data Analysis
button and, in the Data Analysis dialogue box, select
Descriptive Statistics,
then click
OK
.
3.
In the Descriptive Statistics dialogue box take the following actions.
a.
Key in the
range
of cells containing
PERCENT
values.
b.
Select the
Labels in first row checkbox
.
c.
Select the
Output Range
radio button and key in the upper-left corner of output range.
d.
Select the following
checkboxes
, then click
OK
.
i.
Summary Statistics
ii.
Confidence Level for Mean (and entry of 95% is appropriate)
iii.
Kth Largest (an entry of 1 is appropriate)
iv.
Kth Smallest (and entry of 1 is appropriate)
4.
Please find, below, images of a completed descriptive statistics dialogue box and the statistics as
calculated by Excel (format the table to your taste).
Module 2: Activity 8 - Instructions
Page 1
Create a Visual Representation
1.
Open the workbook entitled
module-2_activity-8_raw-data
and select the
histogram-success-
percent
tab.
2.
Next to the input range (PERCENT) create a BIN range as shown below.
3.
Select the
Data
tab, click the
Data Analysis
button and, in the Data Analysis dialogue box, select
Histogram,
then click
OK
.
4.
In the Histogram dialogue box take the following actions.
a.
Key in the
input range
(
PERCENT)
and the
BIN range
.
b.
Select the
Labels checkbox
.
c.
Select the
Output Range
radio button and key in the upper-left corner of output range.
d.
Select the following
checkboxes
, then click
OK
.
i.
Cumulative Percentage
ii.
Chart Output
5.
Please find, below, images of a completed descriptive statistics dialogue box and a histogram
created by Excel (format the table and chart to your taste).
Module 2: Activity 8 - Instructions
Page 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help