MIS171 Tut Week 02
MELBOURNE INSTITUTE OF BUSINESS AND TECHNOLOGY
In association with
DEAKIN UNIVERSITY
MIS171 Business Analytics
Tutorial Week 2
Summary Measures for Numerical Variables
Introduction
In this week’s tutorial, we look at summarising a single numerical variable. There are five (5) aspects that need to be investigated: average, spread, location, shape and outliers. You will complete some of the work by hand and the rest using Microsoft Excel.
Specifically the aims of this tutorial are to:
Produce frequency distributions and histograms for numerical data
Calculate by pen-and-paper some of the standard summary measures used to describe single quantitative variables.
Produce summary measures using Microsoft Excel.
Practise choosing the most appropriate summary measures to describe a variable.
Interpret the results from your analysis in regard to the following scenario.
Scenario
We continue with the analysis of the Conrobar employee data set that we started in Part 1 of this tutorial.
Conrobar is a manufacturing company which employs over 3,000 people. Management is concerned about the wide variation in productivity between employees and whether employee job satisfaction and their sense of job security plays any part in this problem. The organisation also has staff planning issues that need addressing, including planning to replace workers who retire, undertaking a recruitment drive for new employees and providing adequate promotion opportunities within the company.
The company has conducted a survey of 48 of their staff, collecting data on these and related issues. You are required to provide Conrobar management with a report on (a) the age profile of staff and (b) the productivity of staff. In particular, are they meeting the target of 100% productivity?
1. Open the data file and install the Data Analysis Toolpak
Open the file Conrobar_Tut02.xlsx in Excel.
To perform a number of statistical calculations in Excel, the Analysis Toolpak needs to be
In association with
DEAKIN UNIVERSITY
MIS171 Business Analytics
Tutorial Week 2
Summary Measures for Numerical Variables
Introduction
In this week’s tutorial, we look at summarising a single numerical variable. There are five (5) aspects that need to be investigated: average, spread, location, shape and outliers. You will complete some of the work by hand and the rest using Microsoft Excel.
Specifically the aims of this tutorial are to:
Produce frequency distributions and histograms for numerical data
Calculate by pen-and-paper some of the standard summary measures used to describe single quantitative variables.
Produce summary measures using Microsoft Excel.
Practise choosing the most appropriate summary measures to describe a variable.
Interpret the results from your analysis in regard to the following scenario.
Scenario
We continue with the analysis of the Conrobar employee data set that we started in Part 1 of this tutorial.
Conrobar is a manufacturing company which employs over 3,000 people. Management is concerned about the wide variation in productivity between employees and whether employee job satisfaction and their sense of job security plays any part in this problem. The organisation also has staff planning issues that need addressing, including planning to replace workers who retire, undertaking a recruitment drive for new employees and providing adequate promotion opportunities within the company.
The company has conducted a survey of 48 of their staff, collecting data on these and related issues. You are required to provide Conrobar management with a report on (a) the age profile of staff and (b) the productivity of staff. In particular, are they meeting the target of 100% productivity?
1. Open the data file and install the Data Analysis Toolpak
Open the file Conrobar_Tut02.xlsx in Excel.
To perform a number of statistical calculations in Excel, the Analysis Toolpak needs to be