Scribd
Upload
5 views1 page

Data Analysis: Measures of Location & Dispersion

The document outlines the tasks for Week 2 of the MIS10090 module, focusing on data analysis for decision-making. It includes instructions to compute various statistical measures such as mean, median, mode, quartiles, range, variance, and standard deviation using the provided Tutorial2.xlsx file. Students are instructed to apply definitions and formulas from Lecture 2 and consider both population and sample perspectives for variance and standard deviation calculations.

Uploaded by

Herman Herman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

Data Analysis: Measures of Location & Dispersion

The document outlines the tasks for Week 2 of the MIS10090 module, focusing on data analysis for decision-making. It includes instructions to compute various statistical measures such as mean, median, mode, quartiles, range, variance, and standard deviation using the provided Tutorial2.xlsx file. Students are instructed to apply definitions and formulas from Lecture 2 and consider both population and sample perspectives for variance and standard deviation calculations.

Uploaded by

Herman Herman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Module MIS10090: Data Analysis for Decisions Making

Week 2

Please save on your PC the [Link] file that you can find in Brightspace.

Tutorial Questions

Question 1: Measures of location

Given the [Link] file, please compute the following:

a) the (arithmetic) mean


b) the median
c) the mode (if any)
d) first quartile
e) third quartile

Please use definitions as in Lecture 2 as well as formulae in Excel.

Question 2: Measures of dispersion

Given the [Link] file, please compute the following:

a) the range
b) the variance
c) the standard deviation

Please use definitions as in Lecture 2 as well as formulae in Excel. Also, assume at first the data
constitute a population. Then, assume the data are drawn from a population and represent a sample
of it. Can you appreciate any change in the final result with respect to points b) and c)?

You might also like