Numeracy and Data Analysis

Numeracy and Data
Analysis
1

Table of Contents
Introduction......................................................................................................................................3
Main Body.......................................................................................................................................3
1. Monthly data in tabular presentation..................................................................................3
2. Monthly data in graphical presentation..............................................................................3
3. Calculations........................................................................................................................4
4. Linear forecasting model....................................................................................................8
Conclusion.......................................................................................................................................9
References......................................................................................................................................10
2

Introduction
Data analysis aims to mine data to evaluate, process and transform data to generate
meaningful information out of it. In the assessment mentioned below, certain questions related to
data analysis has been given (Hounslow, 2018). A set of monthly expenses for 10 consecutive
months has been taken to undertake the process of data mining and drawing observation from the
same. Firstly, a tabular presentation has been drawn for the monthly data which forms the basis
for graphical representation. Column chart and bar chart have been charted. Further, using the
data mentioned above, mean, mode, median, range and standard deviation has been determined.
In addition, assessment covers forecasting the monthly expenditure for 11th and 12th month using
linear forecasting method.
Main Body
1. Monthly data in tabular presentation
Month Total expenses per month
January 6500
February 10000
March 8000
April 8000
May 10000
June 8000
July 7500
August 12000
September 9000
October 7000
2. Monthly data in graphical presentation
(I) Column Chart – Column chart is one the charts and uses vertical columns to depict data
collection on the chart.
3

(II) Bar Chart – It uses horizontal columns to present data proportional to the values that they
represent.
4
January
February
March
April
May
June
July
August
September
October
0
2000
4000
6000
8000
10000
12000
6500
10000
8000 8000
10000
8000 7500
12000
9000
7000
Total
expenses
per month
January
Febr...
March
April
May
June
July
August
Sept...
October
0 2000 4000 6000 8000 10000 12000
6500
10000
8000
8000
10000
8000
7500
12000
9000
7000
Total
expenses
per month