Spreadsheet: cooper_richey__4352__GasPowerAnalysis
Sheet: Data

Date | Average of PP Liquidations (5*16) | Average of PP Liquidations (7*8) | Average of PP Liquidations (7*24) | Average of AECO CGPR Gas Daily | LN(Gas) | LN(Power 7*8) | LN(Power 7*24) | LN(Power 5*16)
1996-01-01 00:00:00 | 18.40227266197855 | 9.43471771670926 | 14.63803758736579 | 1.512050000000001
1997-01-01 00:00:00 | 35.79704533652826 | 20.24870974402274 | 29.61889780657266 | 2.873054838709678
1998-01-01 00:00:00 | 34.32005954924084 | 18.94431450866884 | 27.20247312386831 | 1.486587096774193
1999-01-01 00:00:00 | 37.46999991536141 | 25.32116940329152 | 32.05862903723153 | 2.31
2000-01-01 00:00:00 | 60.29403129220009 | 28.12048379067452 | 46.45850809863821 | 2.83
 | 14.84331251829863 | 5.909224148454337 | 10.61760058005651 | 1.487555172413793
 | 22.55358552305322 | 9.992544727666038 | 18.15793157617251 | 1.856132142857142
 | 24.8590460388284 | 17.08473214294229 | 21.56049105525016 | 1.638164285714286
 | 31.77990141667818 | 23.63464281814439 | 28.26940478171621 | 2.241539285714286
 | 51.24387509226799 | 33.10965512538778 | 47.07448287941943 | 3.119800000000001
 | 14.25648806350572 | 7.598508035944354 | 11.16012094001616 | 1.311241935483871
 | 19.62377975384394 | 9.929677515260634 | 15.54873659662021 | 1.482735483870967
 | 34.16022739085284 | 19.90479835002653 | 27.96873659664584 | 1.769722580645161
 | 34.82157609255417 | 22.06943551186592 | 29.20545700673134 | 2.208938709677419
 | 115.8393737129543 | 35.78653240588404 | 77.19321181569047 | 3.52
 | 13.87625001725696 | 5.287351177419935 | 9.614804346233175 | 1.18486
 | 22.34967266945612 | 8.996625042245501 | 16.84379110860364 | 1.784553333333333
 | 38.68226196084704 | 20.89265477714084 | 31.0904855483684 | 2.206413333333334
 | 41.03193441459111 | 19.09747027158737 | 31.39602951479419 | 2.54
 | 135.068518895852 | 36.30446420113245 | 93.59763522398644 | 3.78
 | 13.50025568360632 | 4.810362886997961 | 9.263561809255227 | 1.086696774193548
 | 26.01238086677733 | 10.65995970464522 | 19.74760747340417 | 1.705667741935484
 | 43.3942813873291 | 17.28552418370401 | 32.18672051224657 | 1.75
 | 77.39565598368645 | 27.16983867076135 | 51.15174723312419 | 2.701916129032258
 | 68.30869306217541 | 27.78576609396166 | 51.66387087811705 | 4.42212258064516
 | 10.23418745845556 | 4.982291655739148 | 7.964249964886242 | 1.103006666666667
 | 20.61535713502339 | 8.050833365321159 | 15.87618058092064 | 1.55624
 | 62.78170452876525 | 18.9233750184377 | 42.10098609262043 | 1.812196666666667
 | 81.99917598746039 | 24.87374993761381 | 54.62522218426069 | 2.79
 | 162.3232092478059 | 49.08304177522659 | 106.7254439764553 | 5.05
 | 14.7720738960938 | 6.325846754735516 | 11.32231184039065 | 1.170283870967742
 | 23.35957385328683 | 9.597741980706491 | 17.34619622717621 | 1.508470967741936
 | 40.32534098083323 | 14.60524194471298 | 29.04227156472463 | 1.967316129032258
 | 42.73032749266851 | 15.25899200285635 | 31.17262105147044 | 2.79
 | 202.278499341011 | 52.48612901472276 | 124.113763132403 | 4.5
 | 18.13639882348833 | 8.439516176139154 | 13.65729841686064 | 1.153170967741935
 | 33.07406245470047 | 15.07370959751068 | 24.05873651850608 | 1.504651612903226
 | 47.55115616321564 | 17.74254036718799 | 33.27358868942466 | 1.78
 | 113.8937798596564 | 20.94665322380681 | 66.46426083323776 | 3.26
 | 329.3477856896141 | 64.33068544633927 | 202.0939388736602 | 4.42
 | 15.94253124892712 | 6.951208430528641 | 12.49320836530791 | 1.109866666666667
 | 25.94842267887933 | 15.50487504402796 | 21.55016671816508 | 1.41
 | 48.14342260360718 | 19.6641666730245 | 36.13887503279579 | 2.02
 | 68.78595242613838 | 24.04849991401037 | 47.45186106761297 | 3.11054
 | 286.6590312957763 | 77.50804114341736 | 176.2805414835612 | 6.27753
 | 23.81627842783928 | 12.43116935606926 | 19.22422042905644 | 1.383732258064516
 | 29.41803975809704 | 16.13241936122218 | 23.35240590187811 | 1.770648387096774
 | 57.59029773871104 | 28.30927414663376 | 48.25432801374826 | 2.35
 | 115.1985319972038 | 31.15951614226064 | 70.4910621796885 | 3.58
 | 352.2958331562224 | 119.8440719001524 | 253.5104834337131 | 6.45
 | 30.83718749284744 | 20.76954171657562 | 26.65908333791626 | 1.931496666666666
 | 24.62184209572641 | 13.90883334676425 | 20.15355554024379 | 1.658370000000001
 | 43.2201876938343 | 21.02566674947739 | 34.06309733258353 | 2.52
 | 39.00336307003384 | 12.9813334107399 | 28.74706946876314 | 2.856283333333333
2000-11-01 00:00:00 | 333.1607141095116 | 100.3739583104452 | 40.17819881567392 | 7.31
1996-12-01 00:00:00 | 30.06693750023842 | 19.40681459634535 | 227.7274722574022 | 2.279596774193548
1997-12-01 00:00:00 | 27.79979168801081 | 15.44427422169716 | 26.10223121220066 | 1.342051612903226
1998-12-01 00:00:00 | 40.25345248267764 | 21.95947580568252 | 22.01001346431753 | 2.22
1999-12-01 00:00:00 | 55.57434502669743 | 22.72189509676349 | 32.6460081249155 | 2.76
2000-12-01 00:00:00 | 230.5190178780329 | 124.3043138596319 | 188.9136423551908 | 11.87
 |  |  |  | Correlation