Question
In: Statistics and Probability
From the following data set, create a scatter diagram and choose a time series analysis method...
From the following data set, create a scatter diagram and choose a
time series analysis method and use it to adjust them and forecast
for month 13, justify because you chose the method you have chosen,
you choose the parameters you need
Month 1 2 3 4 5 6 7 8 9 10 11 12 13
Sales 210 190 240 250 200 170 190 235 160 185 260 145
Solutions
Expert Solution
The scatter diagram is:
The trend analysis method will be used here.
The forecast for month 13 is 184.85.
This method is used because there is a trend in the data.
| Period | Sales | Period(x) | Forecast | Error | Absolute | Squared | Abs Pct Err | |
| Period 1 | 210 | 1 | 218.2051 | -8.20513 | 8.205128 | 67.32413 | 03.91% | |
| Period 2 | 190 | 2 | 215.4254 | -25.4254 | 25.42541 | 646.4514 | 13.38% | |
| Period 3 | 240 | 3 | 212.6457 | 27.35431 | 27.35431 | 748.2584 | 11.40% | |
| Period 4 | 250 | 4 | 209.866 | 40.13403 | 40.13403 | 1610.741 | 16.05% | |
| Period 5 | 200 | 5 | 207.0862 | -7.08625 | 7.086247 | 50.2149 | 03.54% | |
| Period 6 | 170 | 6 | 204.3065 | -34.3065 | 34.30653 | 1176.938 | 20.18% | |
| Period 7 | 190 | 7 | 201.5268 | -11.5268 | 11.52681 | 132.8673 | 06.07% | |
| Period 8 | 235 | 8 | 198.7471 | 36.25291 | 36.25291 | 1314.274 | 15.43% | |
| Period 9 | 160 | 9 | 195.9674 | -35.9674 | 35.96737 | 1293.651 | 22.48% | |
| Period 10 | 185 | 10 | 193.1876 | -8.18765 | 8.187646 | 67.03754 | 04.43% | |
| Period 11 | 260 | 11 | 190.4079 | 69.59207 | 69.59207 | 4843.057 | 26.77% | |
| Period 12 | 145 | 12 | 187.6282 | -42.6282 | 42.62821 | 1817.164 | 29.40% | |
| Total | 1.14E-13 | 346.6667 | 13767.98 | 173.03% | ||||
| Intercept | 220.984848 | Average | 9.47E-15 | 28.88889 | 1147.331 | 14.42% | ||
| Slope | -2.7797203 | Bias | MAD | MSE | MAPE | |||
| SE | 37.10523 | |||||||
| Forecast | 184.848485 | 13 | ||||||
| Correlation | -0.27257 | |||||||
| Coefficient of determination | 0.074292 |
orchestra answered 1 year agoRelated Solutions
For the following data set: a) draw a scatter diagram, b) develop the estimation equation that...
For the following data set:
a) draw a scatter diagram,
b) develop the estimation equation that best describes the
data,
c) predict Y for X = 10, 15, 20.
X 13 ,16 ,14 ,11 ,17 ,9 ,13 ,17 ,18, 12
Y 6.2 ,8.6 ,7.2 ,4.5 ,9.0 ,3.5 ,6.5 ,9.3 ,9.5, 5.7
Using the data given below,
a) draw the scatterplot,
b) develop the estimation equation that best describes the
data,
c) predict Y for X = 5, 6, 7.
X...
For the accompanying data set, (a) draw a scatter diagram of the data, (b) by hand,...
For the accompanying data set, (a) draw a scatter diagram of
the data, (b) by hand, compute the correlation coefficient, and
(c) determine whether there is a linear relation between x and
y.
n
3
0.997
4
0.950
5
0.878
6
0.811
7
0.754
8
0.707
9
0.666
10
0.632
11
0.602
12
0.576
13
0.553
14
0.532
15
0.514
16
0.497
17
0.482
18
0.468
19
0.456
20
0.444
21
0.433
22
0.423
23
0.413
24
0.404
25
0.396...
For the accompanying data set, (a) draw a scatter diagram of the data, (b) by hand,...
For the accompanying data set, (a) draw a scatter diagram of
the data, (b) by hand, compute the correlation coefficient, and
(c) determine whether there is a linear relation between x and
y.
x 2 4 6 6 7
y 4 8 11 13 18
n
3
0.997
4
0.950
5
0.878
6
0.811
7
0.754
8
0.707
9
0.666
10
0.632
11
0.602
12
0.576
13
0.553
14
0.532
15
0.514
16
0.497
17
0.482
18
0.468
19
0.456...
For the accompanying data set, (a) draw a scatter diagram of the data, (b) compute the...
For the accompanying data set, (a) draw a scatter diagram of
the data, (b) compute the correlation coefficient, and (c)
determine whether there is a linear relation between x and y.
x
2
6
1
7
9
y
8
2
6
9
5
Critical Values for Correlation Coefficient
n
3
0.997
4
0.950
5
0.878
6
0.811
7
0.754
8
0.707
9
0.666
10
0.632
11
0.602
12
0.576
13
0.553
14
0.532
15
0.514
16
0.497
17
0.482
18...
For the accompanying data set, (a) draw a scatter diagram of the data, (b) compute the...
For the accompanying data set, (a) draw a scatter diagram of
the data, (b) compute the correlation coefficient, and (c)
determine whether there is a linear relation between x and y.
Data set
x
7
6
6
7
9
y
3
2
6
9
5
Critical Values for Correlation Coefficient
n
3
0.997
4
0.950
5
0.878
6
0.811
7
0.754
8
0.707
9
0.666
10
0.632
11
0.602
12
0.576
13
0.553
14
0.532
15
0.514
16
0.497...
A data set is given a) (a) Draw a scatter diagram. Comment on the type of...
A data set is given
a)
(a) Draw a scatter diagram. Comment on the type of relation that
appears to exist between x and y.
(b) Given that
x overbarxequals=3.83333.8333,
s Subscript xsxequals=2.40142.4014,
y overbaryequals=3.98333.9833,
s Subscript ysyequals=1.74521.7452,
and
requals=negative 0.9457−0.9457,
determine the least-squares regression line.
(c) Graph the least-squares regression line on the scatter
diagram drawn in part (a).
x
0
2
4
5
6
6
y
6.0
5.8
4.7
3.0
2.1
2.3
For the accompanying data set, (a) draw a scatter diagram of the data, (b) by hand,complete...
For the accompanying data set, (a) draw a scatter diagram of the
data, (b) by hand,complete the correlation coefficient, and (c)
determine whether there is a linear relation between x and y.
x
2
4
6
6
7
y
4
8
12
12
20
Critical Values for Correlation Coefficient
n
3
0.997
4
0.950
5
0.878
6
0.811
7
0.754
8
0.707
9
0.666
10
0.632
11
0.602
12
0.576
13
0.553
14
0.532
15
0.514
16
0.497
17
0.482...
A data set is given below. (a) Draw a scatter diagram. Comment on the type of...
A data set is given below. (a) Draw a scatter diagram. Comment
on the type of relation that appears to exist between x and y. (b)
Given that x̅ = 3.8333, Sx = 2.4014 , ȳ equals = 3.7333 3., Sy =
1.8381, and r = -0.9545 , determine the least-squares regression
line.
(c) Graph the least-squares regression line on the scatter
diagram drawn in part
x y
0 5.9
2 5.7
4 4.3
5 2.8
6 1.7
6 2...
A data set is given below. (a) Draw a scatter diagram. Comment on the type of...
A data set is given below. (a) Draw a scatter diagram. Comment
on the type of relation that appears to exist between x and y. (b)
Given that x̅ = 3.6667, sx = 2.0656, ŷ = 4.2000, sy = 1.4805, and
r = −0.9287, determine the least-squares regression line. (c)
Graph the least-squares regression line on the scatter diagram
drawn in part (a).
x y
1 5.2
2 5.8
3 5.4
4 3.8
6 2.4
6 2.6
(a) Choose the...
From the data set myclass.restaurantratings, create - a scatter digram with a regression line between score and price
From the data set myclass.restaurantratings, create - a scatter digram with a regression line between score and price (use REG statement in PROC SGPLOT) Add a title to the scatter diagram and provide a brief discussion on the relationship between the two variables.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Would the voltage of a battery in circuit be larger or smaller than the voltage of...
- The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
- Part 1: Explain and provide a real life business example for equivalent units. Explain the importance...
- A company produces three different type of chocolates. A, B, and C. The sales volume for...
- When considering labeling someone with a disorder it is important that we use the most up...
- 7. The director of career advising at Rutgers want to use decision analysis to provide...
- Looking for assistance with the "sketch/graph" part of the below question:Consider the following projects, X and...
ADVERTISEMENT