Neco 2023 Data Processing Question 2

Practice essay / theory question 2 from the 2023 Neco Data Processing examination. This question covers Descriptive Statistics, Grouped Frequency Distribution, Mean, Median, Mode, Simple Moving Average .

Neco 2023 Data Processing Essay / Theory
Topics: Descriptive Statistics Grouped Frequency Distribution Mean, Median, Mode Simple Moving Average
Question 2 NECO • 2023 • DATA_PROCESSING • essay

The table below shows the number of units of a product sold by a small business during eight consecutive weeks. | Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |------|---|---|---|---|---|---|---|---| | Units sold | 45 | 52 | 38 | 60 | 55 | 47 | 62 | 58 | Using this data, answer the following questions.

Question Parts

( a )
Calculate the total units sold over the eight weeks and the average (mean) weekly sales.
( b )
Construct a grouped frequency distribution for the units sold using class intervals of 5 units (35‑39, 40‑44, 45‑49, 50‑54, 55‑59, 60‑64). List the frequency for each class.
( c )
Using the grouped data, estimate the mean weekly sales by multiplying each class midpoint by its frequency, summing the products and dividing by 8. Compare this estimated mean with the exact mean obtained in part (a) and comment on any difference.
( d )
Determine the median weekly sales from the raw data (ordered) and explain the steps used.
( e )
The business wishes to forecast the sales for week 9 using a simple moving average of the last three weeks (weeks 6, 7 and 8). Compute this forecast and discuss its reliability based on the pattern of the data.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Neco 2023 Data Processing Question 2. It is one of the essay questions from the 2023 Neco Data Processing examination.

The question covers Descriptive Statistics, Grouped Frequency Distribution, Mean, Median, Mode, Simple Moving Average .

View More Neco 2023 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support