The purpose of this exercise is to help you become more familiar with the data series in the spreadsheet " Com4fg3_Assignment Data_2021.xls" (Excel format). A) For company stock i (of your choice) in...

The purpose of this exercise is to help you become more familiar with the data series in the spreadsheet " Com4fg3_Assignment Data_2021.xls" (Excel format). A) For company stock i (of your choice) in the sheet “Stocks”, print and plot market log returns ???? ? ??? 1 ? ???? for 144 months in the data series, from January 2007 through December 2018. (Remember that the return is ??? ? ??? ??,??? ? 1 with ??? being the value of stock i in month t.) B) Next, using data from the "91-day TBill" columns Iin the sheet “Stat”, covering the January 2007 – December 2018 time span, construct the risk premium measure ????? ? ????? for any company of your choice. The TBill rate is expressed as an annual per cent. To convert the annual per cent ??into a monthly rate compute ??? ? ??. 01? · ?? ? 1? ? ?? ? 1.0 and ???? ? ??? 1 ? ???? (Note: It is possible that for some months the risk premium of a particular company's assets, or for the market as a whole, is negative. Does this occur in your sample?) Compute and print out sample means for ???? ??? ????. Note that these log returns are monthly, not annual.


Data DateCAE IncBallard Power SystemsBombardierMarket Return91 day T-billrl_jCAErl_Jballardrl_jBombrl_frl_m(rl_j-rl_f)_CAE(rl_j-rl_f)_ballard(rl_j-rl_f)_Bomb(rl_m-rl_f) 12/29/068.6256.663.3684651.054.1690.00340949870.01044525790.0070357592 1/31/079.3316.533.7948511.674.1620.0786772273-0.01971254130.11918799690.00340387950.01656208830.0752733478-0.02311642080.10262590860.0131582088 2/28/079.7647.073.888657-1.374.1760.04535996230.07945353660.02441870590.0034151175-0.0137947110.04194484480.07603841910.0382134169-0.0172098285 3/30/0710.456.373.9739351.334.1810.0678998259-0.10426101030.02169293390.00341913070.01321233150.0644806952-0.1076801410.00848060240.0097932008 4/30/0710.355.543.8971854.34.168-0.0096154587-0.1396049688-0.019502290.0034086960.042101176-0.0130241547-0.1430136648-0.06160346610.03869248 5/31/0711.114.914.5367674.094.2050.0708590839-0.1207205590.15196014620.00343839170.04008572350.0674206923-0.12415895060.11187442270.0366473319 6/29/0711.415.685.457765-1.344.3840.02664456020.14567729090.18482472150.0035819182-0.01349059020.0230626420.14209537270.1983153116-0.0170725084 7/31/0711.075.065.500402-3.034.537-0.0302514172-0.11558474940.00778181520.0037044186-0.0307685337-0.0339558358-0.1192891680.0385503489-0.0344729523 8/31/0710.974.735.2872091.14.309-0.0090744724-0.0674412808-0.03953067310.00352180890.01093994-0.0125962813-0.0709630897-0.05047061310.0074181312 9/28/0710.774.95.0399054.144.093-0.01839978310.0353100026-0.04790327470.00334847230.0405659617-0.02174825550.0319615303-0.08846923640.0372174894 10/31/0710.254.864.7755442.643.99-0.0494867856-0.0081967672-0.05387933860.00326570040.0260575343-0.052752486-0.0114624676-0.07993687290.0227918339 11/30/079.4734.55.159293-5.113.968-0.0788320587-0.07696104110.07729166050.0032480112-0.05245186-0.0820800699-0.08020905230.1297435205-0.0556998712 12/31/0710.715.225.082542-0.293.8730.12273223760.1484200051-0.01498802450.0031715866-0.00290421310.11956065090.1452484185-0.0120838113-0.0060757998 1/31/089.0784.584.221239-6.163.602-0.1653239804-0.1307984038-0.18568284330.0029532229-0.0635789816-0.1682772033-0.1337516267-0.1221038616-0.0665322046 2/29/089.984.424.801127-2.113.2760.0947291863-0.0355593020.12872199520.002689847-0.02132578670.0920393393-0.0382491490.1500477819-0.0240156337 3/31/089.3684.254.664682-1.132.48-0.063283464-0.0392207132-0.02883101720.0020435412-0.0113643301-0.0653270052-0.0412642543-0.0174666872-0.0134078712 4/30/089.3124.255.6283174.912.391-0.005995735300.18779079840.00197099250.0479326538-0.0079667278-0.00197099250.13985814470.0459616612 5/30/0810.64.256.7369292.592.7180.129550110100.17979371990.00223726420.02557027610.1273128459-0.00223726420.15422344380.0233330119 6/30/089.3013.956.319067-7.732.759-0.1307320799-0.073203404-0.06403261240.0022705951-0.0804511244-0.133002675-0.07547399920.016418512-0.0827217195 7/31/088.934.156.282003-1.392.424-0.04070552640.0493927553-0.0058826920.0019978993-0.0139975096-0.04270342570.0473948560.0081148176-0.015995409 8/29/089.0434.927.0608351.132.4940.01257458290.17020019630.11687443780.0020549480.01123663190.01051963480.16814524820.10563780590.0091816839 9/30/086.8813.954.946864-9.812.149-0.2732269875-0.2195929516-0.3558094760.0017734328-0.1032516298-0.2750004204-0.2213663844-0.2525578462-0.1050250626 10/31/085.7243.324.003689-18.331.93-0.1840961285-0.173750796-0.21153765440.0015942793-0.2024834486-0.1856904078-0.1753450753-0.0090542057-0.2040777279 11/28/085.1412.683.736777-7.711.874-0.1074202486-0.2141479884-0.06899271090.0015484117-0.0802343927-0.1089686603-0.21569640010.0112416818-0.0817828044 12/31/086.7671.343.8314861.51.1240.2748102442-0.69314718060.02502924230.00093187560.01488861250.2738783685-0.69407905620.01014062980.0139567369 1/30/095.9981.533.28882-7.520.934-0.12063177690.1325981214-0.15272387970.0007750212-0.0781777811-0.12140679810.1318231003-0.0745460986-0.0789528022 2/27/095.531.482.561817-9.880.852-0.0812382648-0.0332256476-0.24981206550.0007072424-0.1040280704-0.0819455072-0.0339328901-0.1457839951-0.1047353129 3/31/096.4021.972.5445088.830.4680.1464226260.285991455-0.00677946130.00038916590.08461684570.14603346010.285602289-0.0913963070.0842276798 4/30/096.3772.453.29432410.50.334-0.00391267420.21805448180.25826367650.00027790820.099845335-0.00419058240.21777657360.15841834150.0995674268 5/29/096.0412.053.2101646.680.197-0.0541282062-0.1782482314-0.02587896140.00016401860.0646635133-0.0542922248-0.17841225-0.09054247470.0644994947 6/30/095.8142.073.025973-0.210.238-0.0383007590.0097088141-0.05908933350.0001981173-0.0021022081-0.03849887630.0095106968-0.0569871254-0.0023003254 7/31/096.02523.3732288.150.2420.0356486772-0.03440142670.10863745680.00020144330.07834896640.0354472339-0.034602870.03028849030.0781475231 8/31/097.4321.893.5321763.030.2460.2098775221-0.05657035150.04604396220.00020476920.0298500220.2096727529-0.05677512070.01619394020.0296452527 9/30/097.6512.94.3887294.550.2280.02904135670.42813390790.21712555190.00018980170.04449523990.0288515550.42794410620.1726303120.0443054381 10/30/097.1272.353.896281-2.750.231-0.0709459697-0.2102954088-0.11901715510.0001922965-0.0278852035-0.0711382662-0.2104877053-0.0911319516-0.0280775 11/30/097.1862.383.976165.760.2280.00824430020.01268515950.0202940210.00018980170.05600219010.00805449840.0124953578-0.03570816910.0558123884 12/31/097.441.994.2601723.030.2120.0347361602-0.17896584890.06899300560.00017649520.0298500220.0345596649-0.17914234420.03914298370.0296735267 1/29/107.2372.364.494221-3.630.191-0.0276640930.17052698030.05348281420.0001590275-0.0369752361-0.02782312050.17036795280.0904580503-0.0371342636 2/26/107.5592.345.0738333.710.1720.0435321504-0.00851068970.12130419850.00014322050.03642835660.04338893-0.00865391010.08487584190.0362851362 3/31/108.4432.715.5553566.280.2350.11059878940.14679770550.09066595970.00019562270.06090693490.11040316670.14660208280.02975902480.0607113122 4/30/107.9152.414.7260651.930.351-0.0645780024-0.1173218874-0.16166957510.00029203050.0191161172-0.0648700328-0.1176139179-0.18078569230.0188240867 5/31/108.0942.074.345813-7.850.4160.0223633531-0.1520781402-0.08388007950.0003460074-0.08175250190.0220173457-0.1524241477-0.0021275777-0.0820985093 6/30/107.8811.644.336853-5.490.56-0.0266682471-0.2328523654-0.0020638830.0004654732-0.056464537-0.0271337202-0.23331783860.054400654-0.0569300101 7/30/108.3681.774.197386.960.5960.0599601080.0762833047-0.03268844880.00049531510.06728474680.05946479290.0757879897-0.09997319560.0667894317 8/31/108.5811.893.99922-4.440.6940.02513554950.0655972825-0.0483611790.0005765019-0.04541586350.02455904760.0650207806-0.0029453155-0.0459923654 9/30/109.1031.734.5486649.480.9060.0590535727-0.08845542060.12873422140.00075188290.09057169820.0583016898-0.08920730350.03816252320.0898198153 10/29/109.8051.834.5978753.90.9050.07428843010.05619455830.01076067680.00075105640.03825871210.07353737370.0554435019-0.02749803540.0375076557 11/30/109.6511.344.2539410.820.962-0.0158309227-0.3116463529-0.07774839290.00079815360.0081665627-0.0166290763-0.3124445064-0.08591495550.0073684091 12/31/109.91.54.5345196.841.0030.02547322020.11279549410.06387316660.00083201540.06616220230.02464120480.1119634788-0.00228903560.0653301869 1/31/1110.951.655.182941.990.9920.10080469910.09531017980.13365344880.00082293170.01970458330.09998176740.09448724810.11394886560.0188816515 2/28/1110.672.115.6830494.020.966-0.02590339090.24591265960.09211542170.00080145770.0394130024-0.02670484870.24511120190.05270241930.0386115447 3/31/1111.112.266.4832220.440.9420.04040953830.06867686580.13172972450.0007816310.00439034830.03962790730.06789523480.12733937620.0036087173 4/29/11111.966.4104792.790.972-0.0099503309-0.14242034-0.01128361390.00080641370.027517886-0.0107567446-0.1432267537-0.03880149990.0267114723 5/31/1110.711.76.160176-1.470.97-0.0267173883-0.1423162222-0.03982864660.0008047617-0.0148091157-0.0275221501-0.1431209839-0.0250195309-0.0156138774 6/30/1111.261.526.342699-1.870.9320.0500787383-0.11191791620.02919903910.0007733686-0.01887705580.0493053696-0.11269128480.0480760948-0.0196504244 7/29/1110.821.495.295365-2.280.932-0.0398603493-0.0199342149-0.1804724780.0007733686-0.0230639396-0.0406337179-0.0207075835-0.1574085384-0.0238373082 8/31/119.2981.344.37005-5.910.898-0.1515969501-0.106106506-0.19205745890.0007452709-0.060918415-0.152342221-0.1068517769-0.131139044-0.0616636858 9/30/118.5461.263.362282-8.570.885-0.084335986-0.061557893-0.26215454060.0007345253-0.0895965338-0.0850705114-0.0622924183-0.1725580068-0.0903310591 10/31/119.2411.483.79811211.560.8640.07818676770.16093036680.1218841910.00071716440.10939237680.07746960320.16021320240.01249181430.1086752123 11/30/118.8331.343.484676-0.450.897-0.0451553971-0.0993724738-0.08612903110.0007444443-0.0045101555-0.0458998415-0.1001169182-0.0816188757-0.0052545998 12/30/118.6321.13.74280.330.835-0.0230184798-0.19735943420.07145892440.00069318440.0032945669-0.0237116642-0.19805261860.06816435750.0026013825 1/31/129.6531.184.3033475.270.8420.11179251990.07020425870.13955909760.00069897330.05135829230.11109354660.06950528540.08820080530.050659319 2/29/129.3041.54.4053654.320.937-0.03682433270.23995066960.02343002430.00077749990.0422929122-0.03760183260.2391731697-0.01886288790.0415154123 3/30/128.9631.423.8635332.40.925-0.0373394228-0.0548082365-0.13124106650.00076758450.0237165266-0.0381070073-0.055575821-0.15495759310.0229489421 4/30/129.4631.423.90086-0.640.9930.054284465200.00961499180.0008237576-0.00642056780.0534607076-0.00082375760.0160355596-0.0072443254 5/31/128.8051.23.527573-6.681.015-0.0720697156-0.1683353148-0.10058694260.0008419238-0.0691357388-0.0729116394-0.1691772386-0.0314512037-0.0699776626 6/29/128.71.173.7759383.740.909-0.0119967163-0.0253178080.06803872960.00075436230.0367175829-0.0127510786-0.02607217030.03132114660.0359632207 7/31/128.8941.043.390831.010.9170.0220538664-0.1177830357-0.10757409950.00076097360.01004933590.0212928928-0.1185440093-0.11762343530.0092883622 8/31/128.8670.923.2875082.771.021-0.0030403717-0.1226023221-0.03094489820.00084687760.0273232956-0.0038872493-0.1234491997-0.05826819390.0264764181 9/28/129.3080.713.4904162.811.0170.048537725-0.25910870.05989109590.00084357510.02771243860.04769415-0.25995227510.03217865730.0268688635 10/31/129.7150.723.594466-1.620.9960.04279683740.0139862420.02937451370.000826235-0.01633265460.04197060240.0131600070.0457071683-0.0171588896 11/30/128.7340.653.3201520.660.991-0.1064476278-0.1022788491-0.07938487550.00082210590.0065783154-0.1072697337-0.103100955-0.08596319080.0057562095 12/31/128.9460.613.582821.310.980.0239830499-0.06351340570.07613963480.00081302130.01301493710.0231700287-0.0643264270.06312469770.0122019158 1/31/139.5680.653.7257515.330.9340.06721769220.06351340570.03911824240.00077502120.05192809290.0664426710.0627383846-0.01280985040.0511530717 2/28/138.9550.733.9544420.960.952-0.06621216170.11607217130.05957106180.00078989270.0095542128-0.06700205440.11528227860.0500168490.0087643201 3/28/138.8651.033.8632023.710.969-0.0101010960.3442695471-0.02334313080.00080393570.0364283566-0.01090503170.3434656113-0.05977148740.0356244209 4/30/139.7220.943.8344441.270.9820.0922804191-0.091434206-0.00747192940.00081467310.01262003140.091465746-0.0922488791-0.02009196080.0118053583 5/31/139.5611.754.5054712.530.997-0.01669903450.62149119170.16126799220.00082706080.0249852527-0.01752609530.62066413090.13628273950.0241581919 6/28/139.7861.94.509936-1.521.020.02326046880.08223809820.00099052660.000846052-0.01531670410.02241441680.08139204630.0163072307-0.0161627561 7/31/1310.4924.7797625.691.0190.06946962950.05129329440.05810779170.00084522630.0553400950.06862440320.05044806810.00276769670.0544948687 8/30/1310.11.544.615939-2.530.998-0.0378869986-0.2613647641-0.03487544030.0008278866-0.0256255476-0.0387148851-0.2621926507-0.0092498926-0.0264534342 9/30/1310.161.814.6392283.820.990.00592301830.16154442890.00503265890.00082128010.03748844440.00510173820.1607231488-0.03245578550.0366671643 10/31/1310.761.414.5908024.090.9370.0573771126-0.2497371409-0.01049323660.00077749990.04008572350.0565996127-0.2505146408-0.05057896010.0393082236 11/29/1310.711.374.6295442.790.914-0.0046576703-0.02877896460.00840363860.00075849440.027517886-0.0054161647-0.029537459-0.01911424740.0267593916 12/31/1312.231.614.4895152.640.9080.13271406520.1614234392-0.0307136970.00075353580.02605753430.13196052940.1606699033-0.05677123130.0253039985 1/31/1412.772.363.914934-3.420.890.04320672030.38242744-0.1369462070.0007386584-0.03479850550.0424680620.3816887817-0.1021477015-0.0355371639 2/28/1413.474.093.515654.720.8720.05336632040.549883351-0.10757404110.00072377850.04611993560.05264254190.5491595725-0.15369397670.0453961571 3/31/1413.224.854.0302490.620.853-0.0187341560.17043373490.13660373070.00070806930.0061808591-0.01944222530.16972566560.13042287160.0054727898 4/30/1413.1544.3244280.250.926-0.0053090758-0.19268434380.07045171670.00076841080.0024968802-0.0060774866-0.19345275470.06795483650.0017284694 5/30/1413.364.173.6183991.980.9240.01584340950.0416216747-0.17824821450.00076675820.01960652960.01507665130.0408549165-0.19785474410.0188397715 6/30/1412.744.413.7210092.820.928-0.0475185180.05595865360.02796320520.00077006350.0278097006-0.04828858140.05518859020.00015350460.0270396372 7/31/1412.74.333.681529-2.060.941-0.0031446567-0.0183071474-0.0106667130.0007808048-0.0208151397-0.0039254615-0.01908795230.0101484267-0.0215959445 8/29/1412.264.153.6124384.060.942-0.035260063-0.0424592078-0.01894526440.0007816310.0397974699-0.036041694-0.0432408388-0.05874273420.0390158389 9/30/1412.463.63.746671-2.450.9240.0161815829-0.14217448880.03648482170.0007667582-0.02480511890.0154148247-0.1429412470.0612899406-0.0255718771 10/31/1413.243.163.6870422.030.890.0607190371-0.1303618179-0.01604320180.00073865840.02009670170.0599803788-0.1311004762-0.03613990350.0193580433 11/28/1413.892.64.333022.220.8930.0479266063-0.19506058260.16144024790.00074113810.02195716740.0471854681-0.19580172070.13948308060.0212160292 12/31/1413.92.374.15-0.20.9010.0007196834-0.0926214899-0.04315642420.0007477504-0.0020020027-0.0000280671-0.0933692403-0.0411544216-0.0027497531 1/30/1514.421.992.9-3.470.7530.0367272917-0.1747553164-0.35839759730.0006253447-0.03531634510.036101947-0.1753806611-0.3230812521-0.0359416898 2/27/1513.912.882.66.150.505-0.03600812590.3696556554-0.1091992920.00041986240.0596830022-0.03642798830.369235793-0.16888229410.0592631398 3/31/1513.692.642.5-1.20.56-0.0159423666-0.087011377-0.03922071320.0004654732-0.0120725812-0.0164078398-0.0874768501-0.0271481319-0.0125380544 4/30/1513.862.692.441.110.6110.01234135450.0187622765-0.02429269260.00050774630.01103884710.01183360810.0182545301-0.03533153970.0105311008 5/29/1513.752.612.5810.667-0.0079681696-0.03019097230.05579135960.00055414130.0099503309-0.008522311-0.03074511360.04584102880.0093961895 6/30/1513.882.582.25-1.70.6070.009410131-0.0115608224-0.13685918270.0005044315-0.01714615880.0089056995-0.0120652539-0.1197130239-0.0176505903 7/31/1513.831.761.631.050.49-0.0036088094-0.3824755899-0.32235020140.00040741910.0104452579-0.0040162285-0.382883009-0.33279545930.0100378387 8/31/1513.491.771.29-5.930.386-0.02489147550.0056657375-0.23393779640.000321099-0.061131-0.02521257440.0053446386-0.1728067964-0.061452099 9/30/1513.271.621.67-3.350.393-0.0164428219-0.08855339730.25818140810.0003269116-0.0340739803-0.0167697334-0.08888030890.2922553884-0.0344008919 10/30/1513.851.951.427.530.4070.04277938430.1854032233-0.16216675480.00033853560.07259969240.04244084870.1850646877-0.23476644720.0722611568 11/30/1514.231.661.30.450.4280.0270671795-0.1610117702-0.08829260710.00035596890.00448990530.0267112106-0.1613677391-0.09278251240.0041339364 12/31/1514.482.151.34-2.440.4890.01741597490.25865023980.03030534950.0004065895-0.02470261260.01700938530.25824365020.0550079621-0.0251092022 1/29/1613.81.880.98-5.720.45-0.0480997948-0.1341960653-0.31287232130.0003742288-0.0589011079-0.0484740236-0.1345702941-0.2539712134-0.0592753367 2/29/1614.071.911.060.280.4560.0193762790.01583146520.07847161540.00037920810.00279608730.01899707090.01545225710.07567552810.0024168792 3/31/1614.241.811.327.020.4640.0120100349-0.05377639680.21936282850.00038584680.06784554690.0116241881-0.05416224360.15151728160.0674597001 4/29/1614.072.011.891.130.5-0.01201003490.10480787680.35894509250.00041571480.0112366319-0.01242574970.10439216190.34770846050.0108209171 5/31/1615.531.81.971.40.5440.098728766-0.11034805720.04145671370.00045220690.01390290520.0982765591-0.11080026410.02755380850.0134506982 6/30/1614.861.611.94-0.090.505-0.0441005979-0.1115524859-0.01534556970.0004198624-0.0009004052-0.0445204603-0.1119723483-0.0144451644-0.0013202677 7/29/1616.592.521.963.940.4880.11012706490.44802472250.01025650020.00040575990.03864362360.1097213050.4476189626-0.02838712340.0382378637 8/31/1617.812.742.150.450.5160.07095999310.08369901890.09252336890.00042898640.00448990530.07053100670.08327003250.08803346360.0040609189 9/30/1617.822.881.80.360.5210.00056132470.0498323737-0.17768117720.00043313340.00359353550.00012819140.0493992404-0.18127471270.0031604022 10/31/1618.022.631.78-2.030.5010.0111608301-0.090806448-0.01117330060.0004165444-0.02050887660.0107442858-0.09122299230.009335576-0.020925421 11/30/1618.952.551.884.550.4940.0503216793-0.0308904870.05465841250.00041073750.04449523990.0499109418-0.03130122450.01016317270.0440845024 12/30/1618.042.222.161.80.486-0.0492124169-0.13858616330.13883644490.00040410070.0178399181-0.0496165175-0.13899026390.12099652670.0174358175 1/31/1717.752.422.492.170.468-0.01620599870.08626034430.14217448880.00038916590.0214679066-0.01659516470.08587117830.12070658220.0210787407 2/28/1719.162.532.33.280.4730.07643925660.0444517626-0.07937358750.00039331470.03227356060.07604594190.0440584479-0.11164714810.0318802458 3/31/1719.592.942.040.240.5040.02219445940.1501902786-0.11995931510.00041903290.00239712460.02177542650.1497712457-0.12235643970.0019780917 4/28/1720.14.472.110.890.5520.02570058310.41897882730.03373813960.00045884030.00886062840.02524174280.4185199870.02487751120.0084017881 5/31/1721.043.732.440.990.5260.0457055728-0.1809801750.14531009180.00043728010.00985131610.0452682927-0.18141745510.13545877580.0094140359 6/30/1721.643.742.361.050.610.02811806610.0026773778-0.03333642030.00050691760.01044525790.02761114850.0021704601-0.04378167810.0099383402 7/31/1720.453.642.512.040.748-0.0565605715-0.02710192980.06162113410.00062120650.0201947073-0.057181778-0.02772313630.04142642680.0195735008 8/31/1719.953.912.50.160.741-0.02475373920.0715536923-0.00399202130.00061541270.0015987214-0.02536915180.0709382797-0.00559074260.0009833087 9/29/1721.225.852.262.570.9560.06171498980.4029042872-0.10092591860.00079319710.02537530630.06092179270.4021110901-0.12630122490.0245821092 10/31/1722.226.452.732.070.950.0460486510.09763846960.18893679590.00078824040.02048866640.04526041060.09685022920.16844812950.019700426 11/30/1722.146.1632.960.876-0.0036068569-0.04600335330.09431067950.00072708530.0291703773-0.0043339423-0.04673043860.06514030220.028443292 12/29/1722.795.563.031.270.9740.028935916-0.10247866930.00995033090.00080806560.01262003140.0281278503-0.1032867349-0.00266970050.0118119657 1/31/1822.154.563.485.341.183-0.0284843468-0.19827548470.13846967430.00098052810.0520230281-0.0294648749-0