Sheet1 A B C D E F G H J K M Car sales data Month Sales (in 1000s) 0.37 0.14 Year 2018 1 2 Here is a monthly sales data for a random motor store. Data is given till June, 2021. 0.18 Your Tasks follows; 0.29 0.36 0.43 You have to forecast amount of sales till December, 2021. On the same plot show the graph of original sales, MA(3) & forecast values. Choose appropriate title & Legend for the plot. 7 0.04 1 0.26 0.89 Note: This is randomly generated data. So do the same drill before start to work. Dont overthink. I dont want any explanation. Just one excel file with plots, Regression & forecasts. 3 10 0.11 4 11 0.71 5 12 0.02 6 2019 1 0.75 7 0.27 0.10 0.30 9 4 0.68 21 2 23 24 25 26 6 0.08 7 0.19 8 0.87 0.47 10 0.02 11 0.48 12 0.76 28 9 2020 1 0.60 2 0.00 3 0.69 11 12 13 14 4 0.47 0.74 0.47 7 0.27 15 8 0.56 16 17 18 19 0.42 10 0.66 11 0.54 0.52 0.10 0.40 12 2021 1 11 12 13 14 15 3 0.24 4. 0.43 0.90 6 0.35
Sheet1 A B C D E F G H J K M Car sales data Month Sales (in 1000s) 0.37 0.14 Year 2018 1 2 Here is a monthly sales data for a random motor store. Data is given till June, 2021. 0.18 Your Tasks follows; 0.29 0.36 0.43 You have to forecast amount of sales till December, 2021. On the same plot show the graph of original sales, MA(3) & forecast values. Choose appropriate title & Legend for the plot. 7 0.04 1 0.26 0.89 Note: This is randomly generated data. So do the same drill before start to work. Dont overthink. I dont want any explanation. Just one excel file with plots, Regression & forecasts. 3 10 0.11 4 11 0.71 5 12 0.02 6 2019 1 0.75 7 0.27 0.10 0.30 9 4 0.68 21 2 23 24 25 26 6 0.08 7 0.19 8 0.87 0.47 10 0.02 11 0.48 12 0.76 28 9 2020 1 0.60 2 0.00 3 0.69 11 12 13 14 4 0.47 0.74 0.47 7 0.27 15 8 0.56 16 17 18 19 0.42 10 0.66 11 0.54 0.52 0.10 0.40 12 2021 1 11 12 13 14 15 3 0.24 4. 0.43 0.90 6 0.35
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
Question
Need answer so fast. Will be good within 1hr. Thank you tutor. Pls provide ans correctly as per question
Transcribed Image Text:Sheet1
..
A
B
D
E
F
G
H
J
K
L
M
1
Car sales data
2
Sales (in 1000s)
0.37
3
Year
Month
4
2018
1
2
0.14
Here is a monthly sales data for a random motor store. Data is given till June, 2021.
6
3
0.18
Your Tasks follows;
7.
4
0.29
8.
0.36
You have to forecast amount of sales till December, 2021.
On the same plot show the graph of original sales, MA(3) & forecast values.
Choose appropriate title & Legend for the plot.
9
0.43
10
7
0.04
11
8
0.26
12
9
0.89
Note: This is randomly generated data. So do the same drill before start to work. Dont overthink. I
dont want any explanation. Just one excel file with plots, Regression & forecasts.
13
10
0.11
14
11
0.71
15
12
0.02
16
2019
0.75
17
2
0.27
18
3
0.10
19
4
0.30
20
0.68
21
6.
0.08
22
0.19
23
8
0.87
24
0.47
25
10
0.02
26
11
0.48
27
12
0.76
28
2020
1
0.60
29
0.00
30
0.69
31
4
0.47
32
0.74
33
6.
0.47
34
7
0.27
35
8
0.56
36
9
0.42
37
10
0.66
38
11
0.54
39
12
0.52
40
2021
1
0.10
41
0.40
42
3
0.24
43
4
0.43
44
0.90
45
6
0.35
46
47
48
49
50
51
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 6 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON