Spreadsheet: 93690d1293424603-linear-regression-formula-help-linear-regression
Sheet: Linear Regression

# | Date | Time | Quarters | Close
1 | 2010.01.04 | 1900-01-01 00:00:00 | 1st Qtr. | 1.4335
2 | 2010.01.04 | 01:00:00 | 2nd Qtr. | 1.4394
3 | 2010.01.04 | 02:00:00 | [NAME]. | 1.4376
4 | 2010.01.04 | 03:00:00 | [NAME]. | 1.4389
5 | 2010.01.04 | 04:00:00 | 1st Qtr. | 1.4396
6 | 2010.01.04 | 05:00:00 | 2nd Qtr. | 1.4421
7 | 2010.01.04 | 06:00:00 | [NAME]. | 1.4424
8 | 2010.01.04 | 07:00:00 | [NAME]. | 1.4438
9 | 2010.01.04 | 08:00:00 | 1st Qtr. | 1.4417
10 | 2010.01.04 | 09:00:00 | 2nd Qtr. | 1.4414
11 | 2010.01.04 | 10:00:00 | [NAME]. | 1.4412
12 | 2010.01.04 | 11:00:00 | [NAME]. | 1.4411
13 | 2010.01.04 | 12:00:00 | 1st Qtr. | 1.4411
14 | 2010.01.04 | 13:00:00 | 2nd Qtr. | 1.4412
15 | 2010.01.04 | 14:00:00 | [NAME]. | 1.4412
16 | 2010.01.04 | 15:00:00 | [NAME]. | 1.4423
17 | 2010.01.04 | 16:00:00 | 1st Qtr. | 1.4418
18 | 2010.01.04 | 17:00:00 | 2nd Qtr. | 1.4419
19 | 2010.01.04 | 18:00:00 | [NAME]. | 1.4415
20 | 2010.01.04 | 19:00:00 | [NAME]. | 1.4422
21 | 2010.01.04 | 20:00:00 | 1st Qtr. | 1.4426
22 | 2010.01.04 | 21:00:00 | 2nd Qtr. | 1.4463
23 | 2010.01.04 | 22:00:00 | [NAME]. | 1.4476
24 | 2010.01.04 | 23:00:00 | [NAME]. | 1.4452
25 | 2010.01.05 | 1900-01-01 00:00:00 | 1st Qtr. | 1.4419
26 | 2010.01.05 | 01:00:00 | 2nd Qtr. | 1.4431
27 | 2010.01.05 | 02:00:00 | [NAME]. | 1.4418
28 | 2010.01.05 | 03:00:00 | [NAME]. | 1.4417
29 | 2010.01.05 | 04:00:00 | 1st Qtr. | 1.4437
30 | 2010.01.05 | 05:00:00 | 2nd Qtr. | 1.4426
31 | 2010.01.05 | 06:00:00 | [NAME]. | 1.4404
32 | 2010.01.05 | 07:00:00 | [NAME]. | 1.4416
33 | 2010.01.05 | 08:00:00 | 1st Qtr. | 1.4401
34 | 2010.01.05 | 09:00:00 | 2nd Qtr. | 1.439
35 | 2010.01.05 | 10:00:00 | [NAME]. | 1.4363
36 | 2010.01.05 | 11:00:00 | [NAME]. | 1.4369
37 | 2010.01.05 | 12:00:00 | 1st Qtr. | 1.4367
38 | 2010.01.05 | 13:00:00 | 2nd Qtr. | 1.4365
39 | 2010.01.05 | 14:00:00 | [NAME]. | 1.4361
40 | 2010.01.05 | 15:00:00 | [NAME]. | 1.4364
41 | 2010.01.05 | 16:00:00 | 1st Qtr. | 1.4347 | All of the 4th Qtr. Closings grouped together.
42 | 2010.01.05 | 17:00:00 | 2nd Qtr. | 1.4368 |  | 1.4389
43 | 2010.01.05 | 18:00:00 | [NAME]. | 1.4357 |  | 1.4438
44 | 2010.01.05 | 19:00:00 | [NAME]. | 1.4355 |  | 1.4411
45 | 2010.01.05 | 20:00:00 | 1st Qtr. | 1.4354 |  | 1.4423
46 | 2010.01.05 | 21:00:00 | 2nd Qtr. | 1.4356 |  | 1.4422
47 | 2010.01.05 | 22:00:00 | [NAME]. | 1.431 |  | 1.4452
48 | 2010.01.05 | 23:00:00 | [NAME]. | 1.4328 |  | 1.4417
49 | 2010.01.06 | 1900-01-01 00:00:00 | 1st Qtr. | 1.4351 |  | 1.4416
50 | 2010.01.06 | 01:00:00 | 2nd Qtr. | 1.4378 |  | 1.4369
51 | 2010.01.06 | 02:00:00 | [NAME]. | 1.4376 |  | 1.4364
52 | 2010.01.06 | 03:00:00 | [NAME]. | 1.4348 |  | 1.4355
53 | 2010.01.06 | 04:00:00 | 1st Qtr. | 1.4356 |  | 1.4328
54 | 2010.01.06 | 05:00:00 | 2nd Qtr. | 1.4358 |  | 1.4348
55 | 2010.01.06 | 06:00:00 | [NAME]. | 1.4353 |  | 1.4387
56 | 2010.01.06 | 07:00:00 | [NAME]. | 1.4387 |  | 1.4408 | 1.436280833333333 | 1.436280833333333
57 | 2010.01.06 | 08:00:00 | 1st Qtr. | 1.4402 |  |  | Two Different Linear Regression [NAME].
58 | 2010.01.06 | 09:00:00 | 2nd Qtr. | 1.4404 |  |  | The 15 period Linear Regression of the 4th quarters/Closing of the 240 minute.
59 | 2010.01.06 | 10:00:00 | [NAME]. | 1.4397 |  | It's a whatif scenario. What if this quarter was the new closing quarter. |  |  |  |  |  |  |  | Linear Regression
60 | 2010.01.06 | 11:00:00 | [NAME]. | 1.4408 | 15th 4th Qtr. | I want to get the same result here without having to group all of the closings cell to cell. |  |  |  |  |  |  |  | 1.436280833333333
61 | 2010.01.06 | 12:00:00 | 1st Qtr. | 1.4411 |  | From this point on I want to calculate the 15th Qtr. linear regression value of each quarter. A:5 would drop off. |  |  |  |  |  |  |  | 1.4365825
62 | 2010.01.06 | 13:00:00 | 2nd Qtr. | 1.4406 |  |  |  |  |  |  |  |  |  | 1.436461666666667
63 | 2010.01.06 | 14:00:00 | [NAME]. | 1.44 |  |  |  |  |  |  |  |  |  | 1.436316666666667
64 | 2010.01.06 | 15:00:00 | [NAME]. | 1.4401 |  | At this point I want the whole process to start over with A:10 dropping off. |  |  |  |  |  |  |  | 1.436340833333333
65 | 2010.01.06 | 16:00:00 | 1st Qtr. | 1.4424
66 | 2010.01.06 | 17:00:00 | 2nd Qtr. | 1.4425
67 | 2010.01.06 | 18:00:00 | [NAME]. | 1.4404
68 | 2010.01.06 | 19:00:00 | [NAME]. | 1.4404
69 | 2010.01.06 | 20:00:00 | 1st Qtr. | 1.4399
70 | 2010.01.06 | 21:00:00 | 2nd Qtr. | 1.4391
71 | 2010.01.06 | 22:00:00 | [NAME]. | 1.4368
72 | 2010.01.06 | 23:00:00 | [NAME]. | 1.4386
73 | 2010.01.07 | 1900-01-01 00:00:00 | 1st Qtr. | 1.4363
74 | 2010.01.07 | 01:00:00 | 2nd Qtr. | 1.4353
75 | 2010.01.07 | 02:00:00 | [NAME]. | 1.4349
76 | 2010.01.07 | 03:00:00 | [NAME]. | 1.4334
77 | 2010.01.07 | 04:00:00 | 1st Qtr. | 1.4318
78 | 2010.01.07 | 05:00:00 | 2nd Qtr. | 1.4333
79 | 2010.01.07 | 06:00:00 | [NAME]. | 1.4319
80 | 2010.01.07 | 07:00:00 | [NAME]. | 1.4327
81 | 2010.01.07 | 08:00:00 | 1st Qtr. | 1.4312
82 | 2010.01.07 | 09:00:00 | 2nd Qtr. | 1.4324
83 | 2010.01.07 | 10:00:00 | [NAME]. | 1.4308
84 | 2010.01.07 | 11:00:00 | [NAME]. | 1.4326
85 | 2010.01.07 | 12:00:00 | 1st Qtr. | 1.4322
86 | 2010.01.07 | 13:00:00 | 2nd Qtr. | 1.4307
87 | 2010.01.07 | 14:00:00 | [NAME]. | 1.4304
88 | 2010.01.07 | 15:00:00 | [NAME]. | 1.4317
89 | 2010.01.07 | 16:00:00 | 1st Qtr. | 1.4316
90 | 2010.01.07 | 17:00:00 | 2nd Qtr. | 1.4311
91 | 2010.01.07 | 18:00:00 | [NAME]. | 1.4308
92 | 2010.01.07 | 19:00:00 | [NAME]. | 1.4313
93 | 2010.01.07 | 20:00:00 | 1st Qtr. | 1.4312
94 | 2010.01.07 | 21:00:00 | 2nd Qtr. | 1.4293
95 | 2010.01.07 | 22:00:00 | [NAME]. | 1.4311
96 | 2010.01.07 | 23:00:00 | [NAME]. | 1.4318
97 | 2010.01.08 | 1900-01-01 00:00:00 | 1st Qtr. | 1.433
98 | 2010.01.08 | 01:00:00 | 2nd Qtr. | 1.4322
99 | 2010.01.08 | 02:00:00 | [NAME]. | 1.4302
100 | 2010.01.08 | 03:00:00 | [NAME]. | 1.4303
101 | 2010.01.08 | 04:00:00 | 1st Qtr. | 1.4289
102 | 2010.01.08 | 05:00:00 | 2nd Qtr. | 1.4402
103 | 2010.01.08 | 06:00:00 | [NAME]. | 1.4355
104 | 2010.01.08 | 07:00:00 | [NAME]. | 1.4325
105 | 2010.01.08 | 08:00:00 | 1st Qtr. | 1.4355
106 | 2010.01.08 | 09:00:00 | 2nd Qtr. | 1.4393
107 | 2010.01.08 | 10:00:00 | [NAME]. | 1.4423
108 | 2010.01.08 | 11:00:00 | [NAME]. | 1.4415