Marge N. O’Hara, a senior analyst for a large stock brokerage has been tasked to forecast the weekly

Marge N. O’Hara, a senior analyst for a large stock brokerage has been tasked to forecast the weekly closing stock prices for this blue-chip stock for the first four weeks of next year. You are assigned to provide technical support to Ms. O’Hara. Weekly closing stock prices for all 52 weeks of this year for this blue-chip stock are reported in units of dollars ($). You may use Excel, Minitab, or both for the calculations required in this problem. 4. a. Calculate and state the value of Durbin-Watson (DW) statistic for the time series regression of weekly closing stock prices data. (Hint: The DW statistic is calculated by checking it in the “Results” option in Minitab’s Regression tool.) b. Test the DW statistic found above at the ? = 0.05 significance level to determine if the time series of the weekly closing stock prices data is serially correlated in time. (Be complete and specific.) c. On this basis can it be concluded that the weekly closing stock prices data is serially correlated in time.

week, t stock price, y
1 267
2 267
3 268
4 264
5 263
6 260
7 256
8 256
9 252
10 245
11 243
12 240
13 238
14 241
15 244
16 254
17 262
18 261
19 265
20 261
21 261
22 257
23 268
24 270
25 266
26 259
27 258
28 259
29 268
30 276
31 285
32 288
33 295
34 297
35 292
36 299
37 294
38 284
39 277
40 279
41 287
42 276
43 273
44 270
45 264
46 261
47 268
48 270
49 276
50 274
51 284
52 304

Looking for a similar assignment? Get help from our qualified experts!

"Our Prices Start at $9.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Order a Similar Paper Order a Different Paper