Numeracy and Data Analysis

Numeracy
and
Data Analysis

Table of Contents
Introduction......................................................................................................................................3
1. Arrange the data in table format..................................................................................................3
2. Present the data in column chart and line chart...........................................................................3
3. Calculation of mean, median, mode, range and standard deviation............................................4
I. Mean:........................................................................................................................................4
II. Median:...................................................................................................................................5
III. Mode:.....................................................................................................................................6
IV. Range:....................................................................................................................................6
V. Standard deviation:.................................................................................................................7
4. Calculation based on y = mx + c.................................................................................................8
I. Calculation of m.......................................................................................................................8
II. Calculation of c.....................................................................................................................10
III. Calculation for 11th and 12th Month expenses......................................................................10
Conclusion.....................................................................................................................................10
REFERENCES..............................................................................................................................11

Introduction
This project is based on statistical analysis of data collected in the form of twelve months
personal expenses. These expenses have been expressed monthly from January to October.
Based on these data mean, median, mode, standard deviation and range have been calculated.
Also a regression equation has formed to find expected expenses on 11th and 12th month.
1. Arrange the data in table format
Month Expenses £
Jan 1
Feb 3
Mar 2
Apr 5
May 4
Jun 5
Jul 3
Aug 1
Sep 2
Oct 7
Sum Ʃ 33
2. Present the data in column chart and line chart
Column chart:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct
0
1
2
3
4
5
6
7
8
Series1
Line chart:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct
0
1
2
3
4
5
6
7
8
Series1