Question

In: Statistics and Probability

  Quarterly billing for water usage is shown below. Assume the time series has seasonality with a...

  Quarterly billing for water usage is shown below. Assume the time series has seasonality with a long term trend.

Year

Quarter

1

2

3

4

Winter

  64

  66

  68

  73

Spring

103

103

104

120

Summer

152

160

162

176

Fall

  73

  72

  78

  88

Forecast the next four quarters:

FWinter = 81.625, FSpring = 126.375, FSummer= 175.375, FFall= 92.625

FWinter = 80.625, FSpring = 120.375, FSummer= 175.375, FFall= 90.625

FWinter = 82.625, FSpring = 120.375, FSummer= 174.375, FFall= 90.625

FWinter = 80.625, FSpring = 120.375, FSummer= 174.375, FFall= 95.625

Solutions

Expert Solution

data

Quarter 1 winter spring summer t
Winter 64 1 0 0 1
Spring 103 0 1 0 2
Summer 152 0 0 1 3
Fall 73 0 0 0 4
66 1 0 0 5
103 0 1 0 6
160 0 0 1 7
72 0 0 0 8
68 1 0 0 9
104 0 1 0 10
162 0 0 1 11
78 0 0 0 12
73 1 0 0 13
120 0 1 0 14
176 0 0 1 15
88 0 0 0 16

here winter, spring and summer are three dummy variable

t = 1 to 16

result

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.995917324
R Square 0.991851316
Adjusted R Square 0.988888158
Standard Error 4.079327039
Observations 16
ANOVA
df SS MS F Significance F
Regression 4 22280.7 5570.175 334.7278066 2.09358E-11
Residual 11 183.05 16.64090909
Total 15 22463.75
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 64.875 3.059495279 21.20447789 2.85131E-10 58.14109629
winter -6.1375 2.964537083 -2.070306368 0.062739758 -12.66240213
spring 32.325 2.92035373 11.06886459 2.65619E-07 25.89734478
summer 86.0375 2.893519896 29.73454585 7.34358E-12 79.66890565
t 1.2875 0.228041314 5.645906775 0.000149723 0.785584452

using regression result

17 80.625
18 120.375
19 175.375
20 90.625

formula

17 =B17+B18+B21*17
18 =B17+B19+B21*18
19 =B17+B20+B21*19
20 =B17+B21*20

B17 is

64.875

B18 slope of winter , B19 - spring , B20 for summer , B21 for t

option B) is correct


Related Solutions

7. Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter...
7. Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 The forecast equation is: Ft = 64.875 – 6.1375 Qtr1t + 32.325 Qtr2t + 86.0375 Qtr3t + 1.2875 (t). Forecast the summer of year 5 and spring of year 6.
Define the following time series components: ● Trend ● Seasonality ● Cyclic ● Random
Define the following time series components: ● Trend ● Seasonality ● Cyclic ● Random
TI have provided two "mystery" time series below. Each is a real world, quarterly time series,...
TI have provided two "mystery" time series below. Each is a real world, quarterly time series, that has been transformed in some way so that you cannot discover (easily) its true identity. Your asignment is to create a 1-year (4-quarter) forecast for each series.  You can use any method or combination of methods that you feel is best. Forecast should be submitted as a spreadsheet. Series X 91.49754 113.0043 135.4433 152.3375 102.7495 114.6203 136.7652 161.4187 115.3307 128.6314 160.2941 181.7292 110.4326 122.5296...
Below you are given the first five values of a quarterly time series of sales. Year...
Below you are given the first five values of a quarterly time series of sales. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 4 20 2 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2. a. 20 b. 44 c. 27 d. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is...
Consider the following quarterly time series. The regression model developed for this data set that has...
Consider the following quarterly time series. The regression model developed for this data set that has seasonality and trend is as follows, yˆt = 864.08 + 87.8Qtr1t + 137.98Qtr2t + 106.16Qtr3t + 28.16t Compute the quarterly forecasts for next year based on the regression model? Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198
Sequence the jobs shown below by using a Gantt chart. Assume that the move time between...
Sequence the jobs shown below by using a Gantt chart. Assume that the move time between machines is one hour. Sequence the jobs in priority order 1, 2, 3, 4. Job Work Center/Machine Hours                                  Due Date (days) 1 A/3, B/2, C/2 3 2 C/2, A/4 2 3 B/6, A/1, C/3 4 4 C/4, A/1, B/2 3 Which department is the bottleneck? Calculate the machine utilization?
Sequence the jobs shown below by using a Gantt chart. Assume that the move time between...
Sequence the jobs shown below by using a Gantt chart. Assume that the move time between machines is one hour. Sequence the jobs in priority order 1, 2, 3, 4. Job Work Center/Machine Hours                                  Due Date (days) 1 A/3, B/2, C/2 3 2 C/2, A/4 2 3 B/6, A/1, C/3 4 4 C/4, A/1, B/2 3 Using finite capacity scheduling, draw a Gantt chart for the schedule (Marks 0.5) What is the makespan? (Marks 0.5) How much machine idle time...
Assume the following time series regression has been estimated for sales of gadgets: St = 20...
Assume the following time series regression has been estimated for sales of gadgets: St = 20 + 13Q1 + 9Q2 +4Q3 + 2t + 3t2; where t is the time trend and Q1, Q2 and Q3 are dummy variables for quarters 1, 2 and 3 respectively. Assume the data used in the regression starts in the first quarter of 2016 and ends in the first quarter of 2018. Forecast the expected sales for quarters 2, 3 and 4 of 2018.
Write a C program to create a series of processes, as shown below in the diagram....
Write a C program to create a series of processes, as shown below in the diagram. P |------ ---- > c1 |------------>c2                              |------- ------>c3 ---------->c4                             In other words, the parent process p creates process c1, c1 creates c2 and c3, and c3 creates c4. A sample run of the program shows Your program should output something similar to what is shown above. You could optionally use wait/waitpid/sleep/exit in your program. Comment your code to show where you created...
Write a C program to create a series of processes, as shown below in the diagram....
Write a C program to create a series of processes, as shown below in the diagram. P - ------------------ > c1 ------------>c3    |                                          |    |------------------> c2 |----- >c4 In other words, the parent process p creates processes c1 and c2, c1 creates c3 and c4.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT