Numeracy and Data Analysis

Assignment Brief

Course/Programme:	BABS Foundation
Level:	3
Module Title:	Numeracy and Data Analysis
Assignment title:	Data Analysis and Forecasting
Assignment number:
Weighting:	Individual Assignment : 30% of overall module grade End of Term Exam : 70% of overall module grade
Date given out:	July 2020
Submission date:	1st September 2020
Eligible for late submission (3 working days, with penalty)?	Yes / No
Method of submission:	X	Online only		Online and paper copy
Special instructions for submission (if any):	Data Source to be specified.
Date for results and feedback:
Employability skills assessed:	Applications of summarising and analysing data. Logical Reasoning. Ability to understand and apply forecasting techniques to real life situations.
Learning outcomes assessed:	Identify and apply techniques for summarising and analysing data. Show reasonableness in the calculation of answers. Demonstrate and analyse techniques used for forecasting.

Referencing:

In the main body of your submission you must provide correct Harvard references from where you collected weather data for ten days. Append to your submission a reference list that in order to complete this assignment (e.g. for books: surname of author and initials, year of publication, title of book, edition, publisher: place of publication).

 

Assignment Mark (Assessment marks are subject to ratification at the Assessment Board.  These comments and marks are to give feedback on module work and are for guidance only until they are confirmed. )	Late Submission Penalties (X if appropriate)		Capped at
	Up 72 hours late	X	40%
	Over 72 hours late		100%

 

TASK DESCRIPTION - INDIVIDUAL ASSIGNMENT: DATA ANALYSIS TECHNIQUES

 

You are required to collect the number of phone calls making per day for ten consecutive days. Once you have collected the data for ten days, you are required to prepare a report undertaking followings:

1. Arrange the data in a table format. (5 marks)

2. Present the data using any two types of charts of your choice. Example: Column chart, bar chart, scatter plot, line chart, pictograms, histograms etc. (10 marks)

3. Calculate and discuss the followings. Please provide the steps for the calculation and highlight the final value.

   • Mean (8 marks)

   • Median (8 marks)

   • Mode (8 marks)

   •  Range (8 marks)

   • Standard Deviation (13 marks)

4. For your data, use the linear forecasting model which is y = mx + c to calculate and discuss the followings:

   • Show the steps of calculation of m value and discuss the answer.    (15 marks)

   • Show the steps of calculation of c value and discuss the answer.     (15 marks)

   • Using the calculated `m` and `c` values, forecast the number of calls making on day 12 and day 14.  (10 marks)

 

Length Required

Approximately 1000 words, with data sources clearly cited.

Formatting and Layout

Please note the following when completing your written assignment:

1. Writing: Written in English using appropriate business/academic style
2. Focus: Focus only on the tasks set in the assignment.
3. Length: Approximately 1000 words
4. Document format: Individual Assignment

Cover page - Ensure a clear title, course, name and student ID number is on the cover sheet.

Table of Contents – Provide headings with appropriate page numbers.

Main Body - Attempt all the given tasks.

Reference list using Harvard Referencing Style.

Sample Answer

Data Analysis and Forecasting Report

Cover details

Course BABS Foundation
Module Numeracy and Data Analysis
Assignment Data Analysis and Forecasting
Student Name and ID add yours here
Data source Primary data recorded from daily phone log over ten consecutive days

Table of contents

• Introduction

• Dataset and tabulation

• Charts

• Descriptive statistics mean median mode range standard deviation

• Linear forecasting model estimation of m and c

• Forecasts for day 12 and day 14

• Discussion and reasonableness checks

• References

Introduction

This report analyses a short primary dataset on daily outbound and inbound phone calls over ten consecutive days. It summarises the data, presents two charts, and calculates mean, median, mode, range, and the sample standard deviation. It then estimates a simple linear trend using the least squares model $y=mx+c$ with Day as the explanatory variable and number of calls as the response, and uses the fitted line to forecast the number of calls for day 12 and day 14. I explain each step and highlight final values.

Dataset and tabulation

The dataset covers ten consecutive days. Days are coded 1 to 10.

You can view and download this table as a CSV using the link above.

Charts

A line chart shows the upward trend with small day-to-day variation. A bar chart confirms the pattern and enables easy comparison across days. Both images are saved and linked above.

Continued...