Question: a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? ( show specific steps drawing graph in Excel)

a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? ( show specific steps drawing graph in Excel)

b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. (show specific steps drawing graphs in Excel)

YEAR	1	2	3	4	5	6	7	8	9	10	11
DEMAND	7	9	5	9	13	8	12	13	9	11	7

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 General Management Questions!

PLEASE SHOW IN-DETAIL STEPS DRAWING GRAPH IN EXCEL a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast...

( 4.25 ( trend line is given as y=5+20x , 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Forecast the...

(4.25 (trend line is given as y=5+20x, 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month January...

Note: means the problem may be solved with POM for Windows and/or Excel OM. . b) Use a 3-week weighted moving average, with weights of .1,.3, and .6, using .6 for the most recent week. Forecast...

without excel Question 1: 11 Year Demand 1 7 ON 2 9 Uw 3 5 4 9 5 13 wun 6 8 7 12 8 13 9 9 10 11 0 0 7 a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b)...

4.2 a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your...

using excel please a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving...

all questions please and using excel a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a...

4.2 3 4 4 1 2 3 5 YEAR 7 8 9 10 6 11 9 13 11 8 9 7 5 12 7 9 un 13 DEMAND a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to...

( Note; please check picture attached to question for data ) a . Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b . Starting in year 4 and going to year 1 2 ,...

A student dissolved a compound in water and added hydrochloric acid. No precipitate formed. Next she bubbled H2S into this solution, but again no precipitate formed. However, when she made the...

Research a lone wolf shooting incident, provide a basic synopsis of the Incident (Who, What, Where, When, How did they prepare, and If you have a Why please Identify this), and then offer what type...

Siles reverue liss cout of goods rold is called grostprofit netincome. marginal income. net proft.

Comment your opinion on this post. Hello class, Sally did not commit the assault the reason behind this situation is basically due to the fact Michael and his bumps into sally which causes her to...