Bus5Sbf Statistics For Business And Assessment Answer


Write down the sampling distribution of sample means for both stocks when a sample of 36 months is taken. Use the sampling distributions of part (a) above to answer the following parts.
b. What is the probability of observing average return of at least 4% in both stocks
c. What is the likelihood of loss in a sample of 36 periods for both stocks

Before investing in one of the two stocks based on higher risk-return relationship, you further want to determine
whether both stocks have same population average return. Perform an appropriate hypothesis test using information in your actual sample of 56 observations and report your findings. Also, which stock will you prefer and why.

Create two new columns in Excel for excess return on your preferred stock (yt) and excess market return (xt) by subtracting the 10-year T-Bill rate from both series as follows.
Excess return on your preferred stock: yt = rt - rf,t
Excess return on market: xt = rM,t - rf,t.
Answer:
DateYahooGoogleS&P 500CloseYahoo ReturnsGoogle ReturnsS & P RetunsExcess returns (Market)Excess returns -Yahoo (Preferable Stock)
01-06-201215.83578.4818121362.1600341.6590.06328.72741.2519-0.2401-1.4288
01-07-201215.84631.2369381379.3199461.492-7.80987.91271.95710.3951-9.3718
01-08-201214.65683.2142331406.5799561.5628.68989.65052.39470.75777.0528
01-09-201215.98752.4342041440.6700441.6375.2419-10.3521-1.9988-3.68483.5559
01-10-201216.84678.4373781412.1600341.68610.85032.62150.2843-1.32179.2443
01-11-201218.77696.4578861416.1800541.6065.84601.28190.7043-1.05174.0900
01-12-201219.9705.4432371426.1899411.756-1.36616.60634.91982.9348-3.3511
01-01-201319.629999753.6209721498.1099851.9858.21175.84791.1000-0.78806.3237
01-02-201321.309999799.0063481514.6800541.8889.9100-0.87883.53551.68358.0580
01-03-201323.530001792.0155641569.1899411.8524.97413.75391.79240.11743.2991
01-04-201324.73822.3123781597.5699461.6756.15525.50322.0550-0.10903.9912
01-05-201326.299999868.8346561630.739992.164-4.55071.0448-1.5113-3.9893-7.0287
01-06-201325.129999877.9595951606.2800292.47811.13510.83484.82782.23488.5421
01-07-201328.09885.3193971685.729982.593-3.5142-4.7108-3.1798-5.9288-6.2632
01-08-201327.120001844.5812381632.9699712.74920.13743.36812.93160.316617.5224
01-09-201333.169998873.5118411681.5500492.615-0.695816.26144.36301.8210-3.2378
01-10-201332.9399991027.7583011756.5400392.54211.56902.77602.76630.02538.8280
01-11-201336.981056.6888431805.8100592.7418.94425.60802.3289-0.69715.9182
01-12-201340.4399991117.6416021848.3599853.026-11.60235.2374-3.6231-6.2911-14.2703
01-01-201436.0099981177.7365721782.5899662.6687.12672.89434.22131.56334.4687
01-02-201438.6699981212.3216551859.4499512.658-7.4327-8.63760.6908-2.0322-10.1557
01-03-201435.9000021112.0009771872.3399662.7230.1392-75.01030.6182-2.0298-2.5088
01-04-201435.950001525.2180181883.9499512.648-3.68316.11852.0812-0.3758-6.1401
01-05-201434.650002558.3570561923.5699462.4571.37582.71171.8879-0.6281-1.1402
01-06-201435.130001573.7048951960.229982.5161.9172-0.6417-1.5195-4.0755-0.6388
01-07-201435.810001570.0349731930.6700442.5567.26910.00003.69641.35344.9261
01-08-201438.509998570.0349732003.3699952.3435.65381.0026-1.5635-4.07153.1458
01-09-201440.75575.7791751972.2900392.50812.2272-3.21732.2936-0.04149.8922
01-10-201446.049999557.5492552018.0500492.33511.6503-3.13402.42370.22979.4563
01-11-201451.740002540.3464972067.5600592.194-2.4060-2.8891-0.4197-2.5897-4.5760
01-12-201450.509998524.958742058.8999022.17-13.82091.5308-3.1533-4.8283-15.4959
01-01-201543.990002533.0565191994.989991.6750.65714.37065.34393.3419-1.3449
01-02-201544.279999556.8710942104.52.0020.3607-1.8800-1.7549-3.6889-1.5733
01-03-201544.439999546.4995732067.8898931.934-4.2990-1.69020.8485-1.1975-6.3450
01-04-201542.57537.3400272085.510012.0460.8654-0.97811.0437-1.0513-1.2296
01-05-201542.939999532.1099852107.3898932.095-8.8834-2.2041-2.1236-4.4586-11.2184
01-06-201539.290001520.510012063.1101072.335-6.901118.39181.9550-0.2500-9.1061
01-07-201536.669998625.6099852103.8400882.205-8.47581.9000-6.4625-8.6625-10.6758
01-08-201533.689999637.6099851972.1800542.2-15.3013-4.6861-2.6799-4.7399-17.3613
01-09-201528.91608.4199831920.0300292.0620.872015.55407.97195.820918.7210
01-10-201535.619999710.8099982079.3601072.151-5.21514.37520.0505-2.1675-7.4331
01-11-201533.810001742.5999762080.4099122.218-1.64012.1686-1.7686-4.0376-3.9091
01-12-201533.259998758.8800052043.9399412.269-11.9626-2.1215-5.2068-7.1378-13.8936
01-01-201629.51742.9500121940.239991.9317.4423-6.2739-0.4137-2.15375.7023
01-02-201631.790001697.770021932.229981.7414.66186.54286.39054.604512.8758
01-03-201636.810001744.9500122059.739991.786-0.5721-7.22730.2696-1.5494-2.3911
01-04-201636.599998693.010012065.3000491.8193.59585.98051.5208-0.31321.7618
01-05-201637.939999735.7199712096.9499511.834-1.0066-6.11190.0911-1.3969-2.4946
01-06-201637.560001692.0999762098.8601071.4881.663410.50873.49902.04100.2054
01-07-201638.189999768.7899782173.6000981.45811.2796-0.2266-0.1220-1.69009.7116
01-08-201642.75767.0499882170.9499511.5680.81541.3262-0.1235-1.7315-0.7926
01-09-201643.099998777.2899782168.270021.608-3.66250.9284-1.9617-3.7957-5.4965
01-10-201641.549999784.5399782126.1499021.834-1.2838-3.43613.36040.9924-3.6518
01-11-201641.02758.0399782198.8100592.368-5.89961.80151.8037-0.6753-8.3786
01-12-201638.669998771.8200072238.8300782.4790.59304.58230.8451-1.6049-1.8570


Buy Bus5Sbf Statistics For Business And Assessment Answers Online

Talk to our expert to get the help with Bus5Sbf Statistics For Business And Assessment Answers from Assignment Hippo Experts to complete your assessment on time and boost your grades now

The main aim/motive of the finance assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignment help Australia. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at www.assignmenthippo.com are so much skilled, capable, talented, and experienced in their field and use our best and free Citation Generator and cite your writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Bus5Sbf Statistics For Business And Assessment Answer Assignment Help Online

Want to order fresh copy of the Sample Bus5Sbf Statistics For Business And Assessment Answers? online or do you need the old solutions for Sample Bus5Sbf Statistics For Business And Assessment Answer, contact our customer support or talk to us to get the answers of it.

Assignment Help Australia
Want latest solution of this assignment

Want to order fresh copy of the Bus5Sbf Statistics For Business And Assessment Answers? online or do you need the old solutions for Sample Bus5Sbf Statistics For Business And Assessment Answer, contact our customer support or talk to us to get the answers of it.


); }