Question
In: Math
The accompanying data file contains monthly observations for 5 years. a. Calculate the 12-month centered moving...
The accompanying data file contains monthly observations for 5 years.
a. Calculate the 12-month centered moving average. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
b. Calculate the ratio-to-moving average.
(Do not round intermediate
calculations.Round your answers to 2 decimal
places.)
| Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | CMA:ybar | Rate- to moving Average:y/ybar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 28 | 30 | 19 | 10 | 28 | 10 | 39 | 31 | 26 | 28 | 18 | 22 | ||
| 2 | 20 | 21 | 39 | 24 | 34 | 39 | 13 | 32 | 16 | 31 | 13 | 12 | ||
| 3 | 20 | 11 | 37 | 38 | 25 | 37 | 13 | 30 | 28 | 37 | 13 | 20 | ||
| 4 | 29 | 33 | 25 | 11 | 21 | 38 | 28 | 12 | 23 | 12 | 13 | 33 | ||
| 5 | 20 | 29 | 12 | 18 | 25 | 34 | 37 | 23 | 17 | 14 | 15 | 17 |
c-1. Calculate the seasonal indices for April and November. (Do not round intermediate calculations.Round your answers to 4 decimal places.)
| Adjusted Seasonal Index | |
|---|---|
| April | |
| November |
c-2. Interpret the seasonal index for April.
(Do not round intermediate
calculations.Round your answer to 2 decimal
places.)
The Series is __________% above or below??? its average monthly
level.
c-3. Interpret the seasonal index for November.
(Do not round intermediate calculations.
Round your answer to 2 decimal places.)
The series is __________% above or below??? its average monthly level.
Solutions
milcah answered 1 year agoRelated Solutions
The accompanying data file contains 20 observations for t and yt.
The accompanying data file contains 20 observations for t and
yt.
t
1
2
3
4
5
6
7
8
9
10
yt
12.1
12.2
9.3
12.8
8.6
9.3
14.3
12.1
11.5
15.1
t
11
12
13
14
15
16
17
18
19
20
yt
13.5
9.8
9.6
14.5
14.9
12.4
11.2
8.8
11.8
10
a. Discuss the presence of random
variations.
The smoother appearance of the graph suggests the presence of
random variations.
The smoother appearance of the graph...
The accompanying data file contains 20 observations for t and yt. The data are plotted below....
The accompanying data file contains 20 observations for
t and yt.
The data are plotted below.
t
1
2
3
4
5
6
7
8
9
10
yt
10.8
14.1
10.3
10.9
11.3
13.5
10.7
9.2
8.8
12
t
11
12
13
14
15
16
17
18
19
20
yt
9.8
11
15.1
12.5
12.9
12.3
9
14.9
10.1
11.9
b-1. Use the exponential smoothing method to make
forecasts with α = 0.2. (Round intermediate
calculations to at least 4...
The accompanying data file contains 20 observations for t and yt. t 1 2 3 4...
The accompanying data file contains 20 observations for
t and yt.
t
1
2
3
4
5
6
7
8
9
10
yt
13.7
8.9
10.4
9.3
12.1
13.7
11.9
13.9
13.8
13.5
t
11
12
13
14
15
16
17
18
19
20
yt
10.8
10.6
12.3
9.3
11.2
10
10.5
13.7
10.3
10.7
The data are plotted below.
a. Discuss the presence of random variations.
A. The smoother appearance of the graph suggests the presence of
random variations....
The accompanying data file contains 20 observations for t and yt. t y 1 10.32 2...
The accompanying data file contains 20 observations for
t and yt.
t
y
1
10.32
2
12.25
3
12.31
4
13
5
13.15
6
13.84
7
14.39
8
14.4
9
15.05
10
14.99
11
16.95
12
16.18
13
17.22
14
16.71
15
16.64
16
16.26
17
16.77
18
17.1
19
16.91
20
16.79
b-1. Estimate a linear trend model and a
quadratic trend model. (Negative values should be indicated
by a minus sign. Round your answers to 2 decimal
places.)...
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter...
Refer to Revenue Data Excel File. The 4 QTR Centered Moving
Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b.
333.875 c. 269.250 d. 243.625
Year
QTR
Revenue (in $1000)
2015
1
205
2
400
3
200
4
229
2016
1
236
2
219
3
211
4
200
2017
1
280
2
275
3
261
4
322
2018
1
500
2
230
3
310
4
400
2019
1
325
2
241
3
379
4
316
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index...
The Excel file Stock Data contains monthly
data for several stocks and the S&P 500 Index (i.e., the
market). Assume the risk free rate of return is 2.5%.
Compute the cost of equity (required rate of return) for Cin
using the classic CAPM.
Compute the Weighted Average Cost of Capital (WACC) for Cin
using the classic CAPM if the corporate tax rate is 20%, the cost
of debt is 15% and the capital structure is: 75% equity and 25%
debt....
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index...
The Excel file Stock Data contains monthly
data for several stocks and the S&P 500 Index (i.e., the
market).
Compute Beta for NT and the S & P 500 using the
Covariance/Variance relationship.
Compute Beta for NT and the S & P 500 using the EXCEL slope
function.
Compute the equation: Ri= ai +
biRMKT for NT.
Compute R2 for this equation.
Compute the t-statistic for a.
Is the t-statistic for a Significant or Not Significant?
Compute the t-statistic for...
Deseasonalize the data by calculating the centered moving average. Plot the deseasonalized data on the graph...
Deseasonalize the data by calculating the centered moving
average. Plot the deseasonalized data on the graph created in (a).
Calculate the seasonal index for each quarter. Write a short
explanation of why the results make sense.
Period
Sales
Mar-01
26.84
Jun-01
26.95
Sep-01
32.21
Dec-01
27.30
Mar-02
26.87
Jun-02
29.82
Sep-02
32.34
Dec-02
29.28
Mar-03
30.07
Jun-03
32.40
Sep-03
35.41
Dec-03
32.15
Mar-04
31.84
Jun-04
35.08
Sep-04
37.80
Dec-04
33.46
Mar-05
33.85
Jun-05
36.73
Sep-05
38.09
Dec-05
32.98
Mar-06
32.93...
The data file wages contains monthly values of the average hourly wages (in dol-lars) for workers...
The data file wages contains monthly values of the average
hourly wages (in dol-lars) for workers in the U.S. apparel and
textile products industry for July 1981 through June 1987.
(a) Display and interpret the time series plot for these
data.
(b) Use least squares to fit a linear time trend to this time
series. Interpret the regression output. Save the standardized
residuals from the fit for further analysis.
(c) Construct and interpret the time series plot of the
standardized...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...
For the attached data set,
1. create a 3-month and 6-month moving average forecast.
2. Calculate the standard errors
3. compare their forecast accuracy
Month/Year
Unemployment rate
Jan-17
5.1
Feb-17
4.9
Mar-17
4.6
Apr-17
4.1
May-17
4.1
Jun-17
4.5
Jul-17
4.6
Aug-17
4.5
Sep-17
4.1
Oct-17
3.9
Nov-17
3.9
Dec-17
3.9
Jan-18
4.5
Feb-18
4.4
Mar-18
4.1
Apr-18
3.7
May-18
3.6
Jun-18
4.2
Jul-18
4.1
Aug-18
3.9
Sep-18
3.6
Oct-18
3.5
Nov-18
3.5
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia...
- Journal Entries and Trial Balance Elite Realty acts as an agent in buying, selling, renting, and...
- In racket Assume that the elements of a list are indexed starting with 1. Write a...
- Describe System Development Life Cycle (SDLC) and how it is used.
- What symbolism do you find in the play,Oedipus?
- • Using the Scanner class to obtain input from the user. • Using printf to output...
- In each of the following situations, develop a tentative plan for the client. List the various...
ADVERTISEMENT