pany B (B). The returns are calculated using end-of-year prices (adjusted for dividends and stock sp he average returns over the 10-year period for portfolios comprised of A and B using the following, respective, weightings: (1.0, e average apoualeturns over the 10 oarseriod for A and B are 17 389 and 13.26% redactie. Aleo calculate the portfolio 10-year pel 0.81953 respectively Data Table - with 100% C Retum TB = 13.26% (Click on the icon here in order to copy its contents of the data table below into a spreadsheet.) vith 90% Cod Return B = 13.26% with 80% Cod Year 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 A Returns - 4.1% 1.7% 31.6% - 12.6% 30.4% 25,4% 22.9% 50.1% 35.5% 30.9% 27.8% 4.3% 45.2% B Returns 17.4% - 7.2% - 25.3% -3.6% 11.5% 10.4% 4.3% 43.4% 42.9% 40.8% 12.4% - 0.2% 25.6% Return 18 = 13.26% with 70% Cor Return B = 13.269 Print Done The bouwing table contains al runs for the ads of Company and Company the culted in and of year prices adjusted for lands and led Use the formation for Company And Company (6) to create an Excel prado calculates the reageren over the year periode pelos com o A and the following repeche 110.000 TL 02.07.000 05.1046), 03, 07.02. 03.01.09 10 The age are 10 year period for And1730d 135 Acheporte standard deviation over 10 yede with each porto prition The Mandard deviation we 10-year period to company and company and the contro con 23.207 and 1993 respect Review Tale 52) Enter the return and standarden for sport with 100% Company And Chandles Portio We Potilaatun Portfolio Stand Devon WA Ender the average return and standard deviation for a portion sien was Company At 198 Commy new below and time and places) Powe WA 08 01 Enter the average return and standard de porte Company and Company Porto We Puttede eRobom Put and Det WA 12 02 Enter the average and standard deviation for a portalu w 7 Company Come Random Port Average Porto Santos WA 17 07 Windows The following table class returns for the stocks of Company AA and Corpery (B) Therefore wested using and of year prices junted for dividends and stock in the woman to Cand Company (1) to create an Excel spreadsheet that calculate the rage use the typeriod for parties comprised of Aanding the ring respective, weging ( 19.10.2015 05.04 06.03.07. 02.001, (0.109) and (00.10). The average and returns over the 10 year period for A de 17 30% and 1320 respectively, kde the poolest over 10 years with each portale comption. The standard deviation over the 16 your period for company and Cigany and air contentocent 1990 and 1963 way of Rew Tale 52) Enter the average reum and standard deviation for a pontolio win Cos Company And Company in the table below and towe decides Portfolio Wigs Portfolio Average Partendard win A 1 06 Er the weagereum and sandard deviation for a portfolio with 50 mpany A and 50% Company in the low round decimal) Portfolio Wees Portfolio Aversa fleum - 1730% 05 05 Enter the average return and wandard deviation for a periode withos Ceny A ON Company in the table below to two decimal places Portfolio Weight Polis Aweg Return WA We 06 Enter the average return and standard deviation for a portfolio with 305 Can A and 70s Company in the bande Polo Weight Portfolio Arca Ratam Portfolio Standard SA 1320 1320 17.30 13.20 07 su Windora The lowing the consum for the stocks of Company and CompanyThe armed wing your sted for diventando pete for Command Company to create and cow 10 yw pod for portales comprised and the folosing spedir 05021020165 with each portale comportion The standardeve the 10 y pored Com And Company and concowe 230 and 195352 2. pectively se calculate the porte standard devitheto yuaration Enter the average rutumn and standard deviation for a proto when Company And To Company that we decide Average Rem WA 17.30 3209 03 OT Enter the top twn and standard deviation for a petite wil Compens Aand bers. Company in the table baten Stand tu tus decimal pron) Pamais Maini| Portfolio Aree Run Portal Standard Destion WA 02 00 Enter the average return and standard deviation foxsporto 10 Comandos Company Partia Ratan Standard wat t) 2.1 Enter the age tun und standard deviation for a pontos Com A und 180 Company in the under den places Portfolio Walch Sandarden MA WA 10