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
- St. Johns River Shipyards' welding machine is 15 years old, fully depreciated, and has no salvage...
- The following information is available for Robstown Corporation for 20Y8: Inventories January 1 December 31 Materials...
- /* Complete the TO DO comments below */ window.onload = function() { /* TODO add a...
- Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $4,532.35. The bonds...
- How do you represent 5.1 (5 + 1/10) in binary? I know that it is 0101....
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
ADVERTISEMENT