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 9 months 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....
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
If the file circuit.txt contains the following data
Exercise 2:
If the file circuit.txt contains the
following data
3.0
2.1
1.5
1.1
2.6
4.1
The first column is voltage and the second column is the
electric current.
Write program that reads the voltages and currents then
calculates the electric power (P) based on the equation:
Voltage
Current Power
3.0
2.1
(result)
1.5
1.1
(result)
2.6
4.1
(result)
P = v * i
Write your output to the file
results.txt with voltage in the first,
current in the second...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A Ferris wheel with a diameter of 35.0 m in , starts from rest and achieves...
- Question 1: Explain and comment the following statement: “Service value creation can go beyond the interaction...
- Consider a project with a 5-year life. The initial cost to set up the project is...
- A proton moving to the right at 6.2 × 10^5 ms^-1 enters a region where there...
- Heating a broth culture of microorganisms to 140∘∘C for three seconds would ___ the culture. View...
- How can I differentiate between QH and QL in the refrigerator case in the second law...
- Conduct a research design. You have been asked by a university to determine whether living in...
ADVERTISEMENT