Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can somebody please help me with the questions below. I need step-by-step instructions as to how to do the moving averages using the data analysis

Can somebody please help me with the questions below. I need step-by-step instructions as to how to do the moving averages using the data analysis tool in Excel.

Q1 10 Marks Sales
Month Sales
a) Develop the 2-months and 3-months moving averages for the supermarket sales. 1 125
Note: use data analysis tool pack. 5 Marks 2 141
3 125
b) Which moving average appears to provide more accurate forecasts based on MAD? Explain. 4 123
Note: show your MAD calculations. 5 Marks 5 126
6 145
7 147
8 162
9 155
10 158
11 147
12 159

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Tutor For Serways Essentials Of College Physics,

Authors: Raymond A Serway, Chris Vuille

1st Edition

0495171646, 9780495171645

More Books

Students also viewed these Mathematics questions

Question

Less than

Answered: 1 week ago

Question

Values: What is important to me?

Answered: 1 week ago

Question

Purpose: What do we seek to achieve with our behaviour?

Answered: 1 week ago

Question

An action plan is prepared.

Answered: 1 week ago