Passengers (thousands) 150000 145000 140000 135000 130000 125000 120000 115000 110000 Time Series plot of quarterly light rail usage (first quarter 2015 through third quarter 2024) wwww 0 8 12 16 20 Time (Quarters) 24 28 32 36 40 40 Year Quarter t y(t) 2015 1 1 110569 2 2 113433 3 3 118183 4 4 114932 2016 1 5 112337 2 6 117224 3 7 118863 4 8 116554 2017 1 9 116287 2 10 124077 3 11 126540 4 12 123559 2018 1 13 122607.4 2 14 129549.7 3 15 128105.9 4 16 126818.9 2019 1 17 123020.3 2 18 130158.9 3 19 133584.3 4 20 132147.9 2020 1 21 126932.4 2 22 123051.92] 3 23 134041.56 4 24 135031.20 2021 1 25 130020.840 2 26 128010.480 3 27 138000.12 4 28 139989.76 2022 1 29 140979.40! 2 30 135969.04 3 31 130958.68! 4 32 142948.32! 2023 1 33 144321.12! 2 34 139782.059 3 35 135372.74 4 36 147611.86 2024 123 37 149334.83 38 145124.004 39 141022.359

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows
Section10.4: Internal Rate Of Return (irr)
Problem 6ST
icon
Related questions
Question

Figure 1 below displays the quarterly number of U.S. passengers (in thousands) using light rail as a mode of transportation. The series begins in the first quarter of 2015 and ends with the third quarter of 2024. 

We can see a regularity to the series: the first quarter’s ridership tends to be lowest; then there is a progressive rise in ridership going into the second and third quarters, followed by a decline in the fourth quarter. Superimposed on the series are the moving-average forecasts based on a span of k = 4. 

Notice that the seasonal pattern in the time series is not present in the moving averages. The moving averages are a smoothed-out version of the original time series, reflecting only the general trend in the series, which is upward.

Data Analysis Questions:

1. Calculate seasonal ratio for the passenger series y(t). The basic idea behind seasonal ratios can be seen by rearranging the trend-times-seasonal model:

For each of the estimated levels given by the centered moving averages, we calculate the ratio of actual sales divided by the centered moving average. 

Because we have more than one seasonal ratio observation for a given quarter, we average these ratios by quarter. That is, we compute the average for all quarter 1 ratios, then the average for all the quarter 2 ratios, and so on. These averages become our seasonal ratio estimates. 

Show the resulting ratios based on the periods of 1, 2, 3 and 4 in the table below:

Quarter

Seasonality ratio

1

 

2

 

3

 

4

 
Passengers (thousands)
150000
145000
140000
135000
130000
125000
120000
115000
110000
Time Series plot of quarterly light rail usage
(first quarter 2015 through third quarter 2024)
wwww
0
8
12
16
20
Time (Quarters)
24
28
32
36
40
40
Transcribed Image Text:Passengers (thousands) 150000 145000 140000 135000 130000 125000 120000 115000 110000 Time Series plot of quarterly light rail usage (first quarter 2015 through third quarter 2024) wwww 0 8 12 16 20 Time (Quarters) 24 28 32 36 40 40
Year
Quarter
t
y(t)
2015
1
1
110569
2
2
113433
3
3
118183
4
4
114932
2016
1
5
112337
2
6
117224
3
7
118863
4
8
116554
2017
1
9
116287
2
10
124077
3
11
126540
4
12
123559
2018
1
13
122607.4
2
14
129549.7
3
15
128105.9
4
16 126818.9
2019
1
17
123020.3
2
18
130158.9
3
19 133584.3
4
20
132147.9
2020
1
21 126932.4
2
22 123051.92]
3
23 134041.56
4
24 135031.20
2021
1
25 130020.840
2
26 128010.480
3
27 138000.12
4
28 139989.76
2022
1
29 140979.40!
2
30 135969.04
3
31 130958.68!
4
32 142948.32!
2023
1
33 144321.12!
2
34 139782.059
3
35 135372.74
4
36 147611.86
2024
123
37 149334.83
38 145124.004
39 141022.359
Transcribed Image Text:Year Quarter t y(t) 2015 1 1 110569 2 2 113433 3 3 118183 4 4 114932 2016 1 5 112337 2 6 117224 3 7 118863 4 8 116554 2017 1 9 116287 2 10 124077 3 11 126540 4 12 123559 2018 1 13 122607.4 2 14 129549.7 3 15 128105.9 4 16 126818.9 2019 1 17 123020.3 2 18 130158.9 3 19 133584.3 4 20 132147.9 2020 1 21 126932.4 2 22 123051.92] 3 23 134041.56 4 24 135031.20 2021 1 25 130020.840 2 26 128010.480 3 27 138000.12 4 28 139989.76 2022 1 29 140979.40! 2 30 135969.04 3 31 130958.68! 4 32 142948.32! 2023 1 33 144321.12! 2 34 139782.059 3 35 135372.74 4 36 147611.86 2024 123 37 149334.83 38 145124.004 39 141022.359
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage