Please help me with the below I previously asked the question on here but want to check I have done part a right Part b, I am really struggling with I can not figure out how MAD is calculated I've seen answers for part b online, but no thorough explanation Every time I calculate it, I do not get the same answer as the ones given on CourseHero Really appreciate any help explanation Q1 10 Marks Sales Month Sales 2 Months St Error 3 Months St Error a) Develop the 2 months and 3 months moving averages for the supermarket sales 1 125 N A N A N A N A Note use data analysis tool pack 5 Marks 2 141 133 N A N A N A 3 125 124 5 70088 129 6667 N A b) Which moving average appears to provide more accurate forecasts based on MAD Explain 4 123 124 5 1 27475 124 6667 N A Note show your MAD calculations 5 Marks 5 126 135 5 6 80074 131 3333 8 812869 6 145 146 6 75463 139 3333 9 079892 7 147 154 5 5 35023 151 3333 10 9443 8 162 158 5 5 85235 154 6667 7 586538 a) answer on the right 9 155 156 5 2 69258 158 3333 6 164414 10 158 152 5 4 03113 153 3333 3 666667 11 147 153 5 75543 154 6667 4 434712 12 159

The Answer is in the image, click to view ...

Question: Please help me with the below. I previously asked the question on here but want to check I have done part a right. Part b,

Please help me with the below. I previously asked the question on here but want to check I have done part a right. Part b, I am really struggling with. I can not figure out how MAD is calculated. I've seen answers for part b online, but no thorough explanation. Every time I calculate it, I do not get the same answer as the ones given on CourseHero. Really appreciate any help/explanation.

Q1								10 Marks		Sales
										Month	Sales	2 Months	St. Error	3 Months	St. Error
a) Develop the 2-months and 3-months moving averages for the supermarket sales.		1	125	#N/A	#N/A	#N/A	#N/A
Note: use data analysis tool pack.				5 Marks			2	141	133	#N/A	#N/A	#N/A
										3	125	124	5.70088	129.6667	#N/A
b) Which moving average appears to provide more accurate forecasts based on MAD? Explain.	4	123	124.5	1.27475	124.6667	#N/A
Note: show your MAD calculations.				5 Marks			5	126	135.5	6.80074	131.3333	8.812869
										6	145	146	6.75463	139.3333	9.079892
										7	147	154.5	5.35023	151.3333	10.9443
										8	162	158.5	5.85235	154.6667	7.586538
a) answer on the right									9	155	156.5	2.69258	158.3333	6.164414
										10	158	152.5	4.03113	153.3333	3.666667
										11	147	153	5.75543	154.6667	4.434712
										12	159

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1. Application of structural testing criteria 2. Features of application of testing criteria within OOP paradigm 3. Prepare report I shared this question yesterday, but the same answer came as...

Course Title: Fundamentals of HRM Question : How can you tap into the diverse talent pool outside the company's doorstep to attract, recruit, and retain visible minorities and ensure that talent is...

Please help me come up with answers to questions 1-9 based off of the text. Thank you Part 8 Supplementary Material PepsiCo Pepsico entered the Indian market in 1986 under the traditional Gujarati...

This is JAVA PROGRAMMING!!! Really Need Help with Part 3 of this Assignment ASAP. I already completed Part 1 and Part 2 of the assignment, but I attached it because it will help with part 3. All I...

Please help me figure out what goes in the boxes in part B (Part A is done and is correct). Can you also show your work pretty please? Contrary to what most people do on here, I actually want to...

Can someone please help me with this? Hint: This is similar to Question 63 in Section 5.7 of our textbook. We covered this section in "1-4Reading and Participation Activities: Inverses and Radical...

look into the transcription of the videos that we coded for the Dominance project and identify if there are any errors (grammar and spelling and etc): Baseline 266 Baseline266 Yeah. Hello. My name is...

Please read the question Question: Choose another different one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That...

Please read the question Question: Choose one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That is, what's the...

QUESTION 5 (20) 5.1 Study the extracts of the Cash Flow Statement of Conlog Limited for the year ended 31 December 2020 and answer the following: 5.1.1 What do you understand by Cash flow from...

Given the network shown determine the input voltage phasor Vs in rms units using complex power if the load voltage is 200/0 Vrms. Vs 0.25 j0.25 30 KVA 0.8 PF leading 50 kW 0.7 PF lagging

You have a patient who is 1 5 years old she's diagnosed with anorexia interviews along with depression and anxiety she has become problematic at school and at home she does not take care of herself...

required a answer including issue, rules, acceptance and conclusion Jellal 212 di 5 Upon turning 21, Eva inherited a large sum of money from her grandmother. She decided to purchase a townhouse from...

7. Imagine yourself in a future situation that you know you do not thrive in. Try to bring with you that feeling of satisfaction from task 6 in the future uncomfortable situation. a. Highlight three...

1. Maintain my own perspective and my opinions

2. See things from the other persons perspective (1 is oriented towards an inner source of inspiration, while 2 is oriented towards an outer source of motivation). d. Reflection style: When I really...