Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

logPrice Avg_Price Date %Coal %Gas %Hydro %Multiple %Nuclear %Oil %Other %Solar %Wind 1.541581 34.80014 12/31/2016 0:00 0.369528 0.192874 0.022624 0.002711 0.34509 0.001733 0.006825 0 0.058615

logPriceAvg_PriceDate%Coal%Gas%Hydro%Multiple%Nuclear%Oil%Other%Solar%Wind
1.54158134.8001412/31/2016 0:000.3695280.1928740.0226240.0027110.345090.0017330.00682500.058615
1.4385927.4530412/30/2016 0:000.3706180.1920410.0173610.0017720.3590080.0018410.0069656.38E-040.049756
1.40630925.4864112/29/2016 0:000.3641940.1884670.0158870.001870.3652710.0018910.0071352.31E-040.055055
1.4825130.3745712/28/2016 0:000.3784620.1808720.014720.0027040.3770690.003510.0071097.61E-040.034793
1.38031524.0057412/27/2016 0:000.3572530.1553720.01470.0032740.4034720.0020850.0075434.31E-040.055869
1.38844624.4593912/26/2016 0:000.3462770.1448180.0131320.0033920.4192790.0021690.008291.38E-040.062504
1.34442722.1017612/25/2016 0:000.3712450.1437860.0129480.0033970.4276130.0022160.008639.60E-040.029205
1.41784626.1725612/24/2016 0:000.3978790.1616540.0128060.0031230.3887350.0017410.0072711.31E-040.02666
1.43711627.3599812/23/2016 0:000.3807250.2118030.0156150.0030160.3550629.58E-040.0066087.54E-040.02546
1.44721728.0038212/22/2016 0:000.3772610.2099540.0150490.0025810.3492050.0010530.0069677.16E-040.037214
1.4758629.9130212/21/2016 0:000.4013840.2209720.0158790.0018360.3224920.0014970.0071245.97E-040.02822
1.54430935.0194612/20/2016 0:000.4043930.2239650.0140490.0032820.3116840.0034540.0071775.84E-040.031412
1.58869838.7880712/19/2016 0:000.4080490.2398610.0137540.0066660.3140298.52E-040.0074173.76E-040.008996
1.43783327.4051812/18/2016 0:000.409740.1960210.0075310.0019750.3506819.57E-040.008372.61E-040.024463
1.4884630.7935712/17/2016 0:000.4448070.2043960.0070150.0028490.3179950.0014450.0074537.08E-050.013969
1.78817861.4013412/16/2016 0:000.4279030.2360290.0187390.0052090.2843230.0029890.0067392.89E-040.017781
1.70950851.2281212/15/2016 0:000.412020.2127980.0149940.0037580.3089550.0022190.0067046.64E-040.037887
1.44337827.7573412/14/2016 0:000.3967990.2165280.013120.0030530.3337420.0034570.0066646.18E-040.02602
1.50787132.2011212/13/2016 0:000.4050960.2198240.0139770.0028630.3322080.0032070.0069263.21E-040.015577
1.5226633.3165812/12/2016 0:000.3938670.2079060.012560.001940.3379940.0018640.0072611.62E-040.036446
1.4697829.4971712/11/2016 0:000.4047710.2158420.0107480.0028130.3298040.0017740.0069964.76E-040.026776
1.52525633.5163212/10/2016 0:000.4127980.225050.0140340.0027160.3248260.0017560.0070148.06E-040.011001
1.63368643.0215712/9/2016 0:000.4027490.2193720.0179390.0032480.319050.0028240.0066367.61E-040.027422
1.4943931.2169312/8/2016 0:000.3820230.208420.0147450.0024360.339780.0018710.0070242.23E-040.043477
1.43279227.0889612/7/2016 0:000.3689780.2257990.0146510.0028220.3545380.0025490.0073085.01E-040.022854
1.52900133.8065912/6/2016 0:000.3623710.2390940.0141320.0039430.3490540.0037370.007021.06E-040.020542
1.46976429.4960912/5/2016 0:000.351380.2367180.0157710.004010.3604710.0022710.0076525.50E-040.021178
1.42251526.4554112/4/2016 0:000.3454520.2370050.0118380.0035560.3826320.0021130.0083084.80E-040.008615
1.46743129.3380312/3/2016 0:000.3242020.243180.0121450.0040390.3864420.0021480.0081378.30E-040.018877
1.50703132.1388812/2/2016 0:000.3080740.2625860.0191050.0068490.3661770.0026290.0075848.93E-040.026103
1.4453827.8856312/1/2016 0:000.2945840.2374350.0138150.0039230.382060.0065810.007987.99E-040.052822
1.39475224.8171411/30/2016 0:000.29910.2483420.0117610.0040180.3966830.0023420.0082322.17E-040.029305
1.47944230.1607511/29/2016 0:000.2874190.2480060.0117890.0043820.3884770.0019250.0081111.19E-040.049773
1.44667327.9687211/28/2016 0:000.2860680.252620.0156810.0039280.3822480.0023350.0077115.79E-040.04883
1.37806423.8816311/27/2016 0:000.2856930.242690.0080680.0032560.4119880.0027840.0081530.0010440.036324
1.34160721.9587411/26/2016 0:000.2830980.2450530.0070060.0032710.429670.0022850.0086766.29E-040.02031
1.36181823.0047811/25/2016 0:000.2836790.249040.0070680.0034610.4364220.0022720.0085372.68E-040.009252
1.32494721.1323311/24/2016 0:000.2912760.2493510.0065950.0034290.4131030.0022310.0089532.99E-040.024762
1.39399624.7739911/23/2016 0:000.3373820.2522710.0123550.0040630.3551390.002010.007979.54E-040.027856
1.44609127.9313111/22/2016 0:000.3357030.2542660.0141590.0045390.3525280.0021250.0075688.82E-040.02823
1.43719527.3649611/21/2016 0:000.3363110.2509550.0148680.0058580.3626480.0020210.0076249.00E-040.018816
1.35886722.8489711/20/2016 0:000.2957180.232940.0078820.0054010.404110.0021650.0086866.88E-040.042409
1.31581920.6927911/19/2016 0:000.2541770.2267890.0064630.0043810.4313010.0025040.0079390.0010880.065358
1.38648724.3493111/18/2016 0:000.2658430.2532830.0101040.0031840.4040520.0025730.0074220.0011780.052362
1.36324223.0803311/17/2016 0:000.2848710.2506650.0125250.0027380.3983020.0020380.006860.0011870.040815
1.39812625.0107311/16/2016 0:000.2924960.2697530.0118740.0024460.3980310.0019760.0066730.0010390.015712
1.45698228.6405911/15/2016 0:000.2846510.2872530.011270.0041330.3908940.0022820.0072458.62E-040.011409
1.43679927.3400311/14/2016 0:000.2799960.2718950.0108320.0075230.3880850.0024280.0072686.53E-040.031321
1.33860321.8073411/13/2016 0:000.2677870.2558710.0073370.0060310.4186180.0011220.0076050.0014160.034213
1.37689523.8174411/12/2016 0:000.2908460.2692670.0077510.0065620.4002715.88E-040.0073360.0014010.015979
1.34887822.3294611/11/2016 0:000.2920890.2598120.01190.0054640.3652915.28E-040.0070790.001250.056587
1.41371225.9246311/10/2016 0:000.3105630.2543460.0148910.0102520.3564895.50E-040.0065170.0012790.045113
1.39450724.8031511/9/2016 0:000.3159960.2590140.0130390.0134010.3655.74E-040.0060473.22E-040.026607
1.37218423.5604911/8/2016 0:000.3208630.2607940.0152560.012490.3614465.48E-040.0057530.0013380.021511
1.37915423.9416711/7/2016 0:000.3190430.2639590.0161720.0107460.3711660.0016810.0060620.0013740.009797
1.32101520.9418511/6/2016 0:000.2877330.2540420.0099920.0063630.4114960.0023820.0068230.0013950.019774
1.34975222.3744411/5/2016 0:000.3046310.256080.0100860.0047630.3949610.0023850.0069040.0014550.018735
1.38751924.4072811/4/2016 0:000.3202660.2589320.0154690.0045930.3735880.0023760.0066080.0011790.016989
1.39419524.7853311/3/2016 0:000.3270690.2610570.0138310.0059660.3618930.0021910.0064167.03E-040.020874
1.41231725.8414711/2/2016 0:000.3227790.2565480.0160040.0119270.3578290.0021560.006120.0010750.025562
1.50637232.0901711/1/2016 0:000.3254630.2419410.0175020.0169720.3472080.0022420.0060047.54E-040.041912
1.45259728.3528410/31/2016 0:000.3310920.2315880.0198320.012520.3732510.0030570.0063290.0012040.021127
1.34534222.1483610/30/2016 0:000.3076690.2212870.0118440.0114910.4023480.002330.0071950.0011580.034678
1.42444326.5731310/29/2016 0:000.3063780.2219490.0108640.0126870.3803740.0022180.0069020.0011920.057436
1.38022124.0005410/28/2016 0:000.3024590.2565550.0174030.0147040.3688360.0021330.006990.0010240.029897
1.46369429.0866610/27/2016 0:000.2874840.271150.0185150.015810.3651930.0021910.0070615.98E-040.031999
1.422426.4484310/26/2016 0:000.3281960.2520570.0198630.016090.3431490.0020670.0065840.0011820.030811
1.40672225.510710/25/2016 0:000.330310.2488140.0221910.0209470.3437040.002110.0066680.0010630.024193
1.43172327.0223510/24/2016 0:000.3246750.234140.0219340.0186870.3537230.0021890.0068390.0011010.036712
1.31705620.751810/23/2016 0:000.305710.2046170.0149120.0145710.3909130.0023580.0073590.0012670.058293
1.35298722.5417210/22/2016 0:000.3267480.2201160.0112210.0164190.3837770.0023160.0068758.23E-040.031705
1.42574726.6530610/21/2016 0:000.3442490.2341230.0116680.0238990.3479890.0023550.0058137.52E-040.02915
1.48698830.6893710/20/2016 0:000.3590370.234060.0134290.025910.3353160.0022230.0053847.47E-040.023893
1.49579431.3179810/19/2016 0:000.3671940.2464870.0157030.023970.3250890.0019240.0054269.10E-040.013297
1.43679627.3398510/18/2016 0:000.3295680.2536620.0158860.0203110.3287910.0019250.0053140.0010160.043527
1.50429531.9370510/17/2016 0:000.3208110.2424110.0180570.0202660.3424160.0021980.0063449.88E-040.04651
1.38565424.3026410/16/2016 0:000.3152840.2219630.0126440.0172780.3786910.0024770.0076910.0011090.042864
1.40089925.1709410/15/2016 0:000.3206770.2279910.0109340.0199320.3708650.0021640.0077840.0012380.038415
1.3617523.0011910/14/2016 0:000.34680.2427620.0122580.0179640.3593220.0025410.0071640.0011560.010033
1.41832326.2013210/13/2016 0:000.3382150.2453810.0141920.0187070.3529590.0021740.0071177.38E-040.020515
1.42849326.8221110/12/2016 0:000.3255140.2387710.0156470.0249040.3495680.0016810.0073218.95E-040.035698
1.43720427.3655110/11/2016 0:000.3309220.2471090.0188380.0224270.3513680.0016810.0076398.82E-040.019133
1.37747623.8493310/10/2016 0:000.320770.2484940.0171440.0214360.3634570.0017450.0074768.63E-040.018616
1.2923719.6051610/9/2016 0:000.2933630.2453030.0112070.017880.3974490.0018810.0082423.86E-040.024289
1.3576822.7866110/8/2016 0:000.3159070.2501890.0088170.01970.3747380.0017940.0078041.39E-040.020912
1.40241825.2591310/7/2016 0:000.311130.2717120.0138160.0269980.3364980.0023620.0067568.04E-040.029923
1.43960527.5172510/6/2016 0:000.305450.2874650.0165010.0297330.3381290.004360.006877.93E-040.010699
1.46429829.1271510/5/2016 0:000.3252450.2588980.0132560.0225140.3367340.0041150.0065467.58E-040.031934
1.41152325.7942410/4/2016 0:000.3352090.2680180.0173740.0200410.3350420.003030.0071384.96E-040.013652
1.44835428.0771910/3/2016 0:000.329610.2735140.0183430.0158650.3483080.0029980.0076778.55E-040.00283
1.28557419.3007510/2/2016 0:000.311570.2607140.0088770.0109820.3926690.0028850.0088566.32E-040.002816
1.34383822.0718110/1/2016 0:000.3225770.251390.0103750.0108350.3841110.0028670.008174.61E-040.009214
1.30615820.237579/30/2016 0:000.3251460.2377330.0151540.0149210.3665180.0028920.0074872.66E-040.029883
1.28212619.148129/29/2016 0:000.3374220.2327090.0147390.0181570.35390.0026950.0074141.87E-040.032777
1.30286220.084559/28/2016 0:000.3448840.2393310.0094070.0186190.3585850.0026880.0076525.61E-040.018274
1.32667321.216489/27/2016 0:000.3347290.2389280.0094060.0172570.3526590.0027170.007766.86E-040.035859
1.28947219.474769/26/2016 0:000.3451170.239010.012330.0157220.3467850.0027390.0072317.25E-040.030342
1.39962125.096949/25/2016 0:000.3445970.2214440.0093370.0148220.3840540.0030890.005960.0010070.01569
1.37140323.518149/24/2016 0:000.3712330.2390740.0104330.0139170.3488560.0021940.0057798.59E-040.007654
1.48853730.799039/23/2016 0:000.3803550.2608330.0134690.0124780.3175670.0027210.0064098.19E-040.005349
1.52900333.806729/22/2016 0:000.3817720.2615430.012570.0113630.3163560.0023230.0063469.20E-040.006807
1.40466325.390019/21/2016 0:000.378630.2556740.012450.0116460.3207010.0024530.006624.73E-040.011352
1.46057528.878539/20/2016 0:000.3727870.27080.0123030.0127990.3159950.0023410.006194.20E-040.006365
1.52676233.632729/19/2016 0:000.3602710.280570.0134620.013690.3164780.0026740.0066533.13E-040.005888
1.5853538.490229/18/2016 0:000.3467730.2636570.0125870.0115870.3486870.0012720.0075777.93E-040.007066
1.37399723.659049/17/2016 0:000.3597410.2463810.0091240.0095880.3501740.001120.0076980.0010130.01516
1.50768832.187569/16/2016 0:000.3424520.2632660.0133060.0100080.3405149.94E-040.0074847.82E-040.021194
1.3736623.640719/15/2016 0:000.3614780.262370.0105260.0096040.3376280.0010440.0077080.0010280.008615
1.54224934.853749/14/2016 0:000.3558530.2867060.0130890.0119940.3169820.0016640.0068860.0010180.005807
1.53995934.670449/13/2016 0:000.3464810.2821270.0144590.0118290.3228580.0011240.0066520.0011590.01331
1.50459931.959449/12/2016 0:000.3450860.2749110.0134830.0119260.3348380.0021490.0072390.0011310.009237
1.40851425.616179/11/2016 0:000.3569750.2737990.0074480.0213590.3190580.0021270.0065720.0010020.011661
1.54371834.97189/10/2016 0:000.3742150.268410.0154040.0227460.2937180.0019370.0064447.78E-040.016348
1.51973233.092729/9/2016 0:000.3848730.281820.014570.0217970.2809760.0020410.0061578.42E-040.006924
1.569137.076629/8/2016 0:000.3725740.2800020.0142980.0216050.2864040.0022660.0059198.99E-040.016033
1.50486931.979339/7/2016 0:000.3523320.2985230.0117980.0200450.2886170.0019870.0057367.52E-040.020209
1.57114637.251689/6/2016 0:000.3317530.2958120.0136290.0193240.3080890.0026040.0065859.32E-040.021272
1.27216918.714129/5/2016 0:000.3204750.2557150.013020.0153790.3655340.0024370.0077880.0010180.018634
1.24148617.437559/4/2016 0:000.3235920.2495810.0106590.013020.3840620.002580.0080570.0012230.007228
1.22048616.614459/3/2016 0:000.3132260.2675440.0094260.0123020.374720.0024920.0076625.88E-040.01204
1.29860719.888739/2/2016 0:000.3302990.2788320.0113480.0149090.340760.0023210.0066217.10E-040.0142
1.41086125.754969/1/2016 0:000.3656390.2762390.0068480.0222190.3041320.00370.0060566.21E-040.014546
1.48201230.339738/31/2016 0:000.3725550.2771540.0162860.0203230.2980820.0042590.006367.63E-040.004219
1.46721229.323258/30/2016 0:000.3786910.2772720.0155060.0196450.2975350.0021320.0060838.47E-040.002288
1.48325230.426538/29/2016 0:000.3776950.2809090.0132870.0201930.2951650.0020160.0063867.66E-040.003581
1.42009626.308518/28/2016 0:000.3803940.2614540.0102270.0185610.3147510.0021070.0069718.09E-040.004729
1.37211223.556568/27/2016 0:000.3746780.2693360.0132110.0200720.3083230.002060.0068789.85E-040.004457
1.59092738.987638/26/2016 0:000.3797520.2970640.0170190.0218360.2680880.0029220.0064149.34E-040.005971
1.6994350.0538/25/2016 0:000.4047720.3129650.0146870.0232830.2235330.0025020.0069299.79E-040.010351
1.4454527.890118/24/2016 0:000.3554350.2593790.0144650.0170360.3266570.0021610.0064090.0011250.017331
1.23091817.018378/23/2016 0:000.3469610.2527820.0153920.0183030.3473440.0022640.0068440.0011680.008941
1.34247622.002728/22/2016 0:000.3349790.274820.0155290.0181080.3410220.0021850.0060790.0012420.006035
1.34448422.104658/21/2016 0:000.3331370.271550.0102250.016670.3398540.0022390.0069948.86E-040.018445
1.44693727.985788/20/2016 0:000.3421070.2804370.0153770.0175020.3195540.0021740.0071129.20E-040.014817
1.46152528.941758/19/2016 0:000.3558810.2989330.0158190.0161710.2978510.0020030.0062566.73E-040.006413
1.5661436.824788/18/2016 0:000.362770.2941420.0160840.0149640.2961610.001970.0061228.29E-040.006958
1.56158436.44058/17/2016 0:000.3630720.3016670.017010.0191520.2828740.0026680.0057649.52E-040.006842
1.52567933.548938/16/2016 0:000.3554490.2978490.0148080.0180450.2868310.0076040.0062338.87E-040.012294
1.45808528.713458/15/2016 0:000.3630650.2943860.0150490.0180850.2909760.0060140.0064098.82E-040.005134
1.47950930.165398/14/2016 0:000.3748240.2871460.0105530.0175840.2915110.003250.0063359.84E-040.007812
1.65535145.222138/13/2016 0:000.3673220.3050720.0128070.0194330.27580.002460.0060269.49E-040.010132
1.70671550.899628/12/2016 0:000.3718330.3113550.0122050.0233760.2610880.0047170.0053538.71E-040.009203
1.79620962.547348/11/2016 0:000.3737330.3069220.0153370.0211730.2637340.0058260.0054478.32E-040.006997
1.7098951.273128/10/2016 0:000.3680760.3010840.0170330.0182120.2822190.0031040.006068.39E-040.003373
1.50582232.049578/9/2016 0:000.3591060.2904630.0136490.0119180.308230.0020750.00679.06E-040.006953
1.4636229.081698/8/2016 0:000.3615250.2810090.0150060.0129080.3126050.0020380.006847.29E-040.00734
1.39623624.902128/7/2016 0:000.3739230.2616750.010120.015360.3247830.0021530.0072460.0011290.00361
1.39740424.969158/6/2016 0:000.3721020.2778890.0131590.0156040.3038780.0020120.0066058.38E-040.007911
1.41025825.719218/5/2016 0:000.361910.2875560.01530.0176780.3005050.0020130.0063639.38E-040.007736
1.49605431.336788/4/2016 0:000.3348950.3083120.0139860.0198870.3083910.0028820.0066360.0010540.003958
1.43079826.964848/3/2016 0:000.3772260.2921350.0145270.0179430.2853530.0031280.0063370.0010610.00229
1.45215928.324298/2/2016 0:000.3801530.2947870.0147890.0176990.2807380.002880.0064256.86E-040.001844
1.50589632.0558/1/2016 0:000.3783280.2915160.0165240.0185660.2820690.003010.0064276.17E-040.002943
1.57796837.841447/31/2016 0:000.3825640.2698380.0120570.017120.3056610.0025070.0065917.48E-040.002915
1.44521127.874727/30/2016 0:00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus Concepts Through Functions, A Unit Circle Approach To Trigonometry

Authors: Michael Sullivan, Michael Sullivan III

3rd Edition

0321925866, 9780321925862

More Books

Students also viewed these Mathematics questions