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.

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

Assignment brief:

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.

1. Mean                          (8 marks)
2. Median                       (8 marks)
3. Mode                          (8 marks)
4.  Range                       (8 marks)
5. 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.