could you show the calculations in excel? Year20112012201320142015201620172018201920202021Stock XYZ3.424.910.530.616.025.727.320.715.326.939.0Broad MarketIndex FundDEF15.415.312.024.926.9-2.821.821.023.711.820.2Bond ABC4.97.812.25.113.17.68.86.012.911.013.9Sanders Insurance Company is trying to identify an investment plan for their unearned premiumreserves. They are considering three investment options. To the left are historical returns for eacchoption.For each option, do the following:1. calculate the average return.2. calculate the return standard deviations.3. calculate the coefficient of variation.Calculate the standard deviations two ways: using the Excel function and do the step-by-step processin Excel (difference column, square column, ...).Which investment option would you recommend to Sanders Insurance? Explain your decision.

Hi! Thank you for the question. As per the honor code, we are allowed to answer three sub-parts at a…

Answered: Year 2011 2012 2013 2014 2015 2016 2017…

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter8: Sequences, Series, And Probability

Section8.CR: Chapter Review

Problem 77E

See similar textbooks

Similar questions

Student loan debt is the only form of consumer debt that has grown since the peak of consumer debt in 2008. The average student loan of somebody younger than 30 is
Read the box "The Return to Education and the Gender Gap." The Return to Education and the Gender Gap Dependent variable: logarithm of Hourly Earnings. * Regressor Years of education Female Female x Years of education Potential experience Potential experience² Midwest South West Intercept (1) 0.1035** (0.0009) 1.533" (0.012) 0.208 (2) 0.1050** (0.0009) -0.263** (0.004) 1.629" (0.012) 0.1001" (0.0011) 0.258 -0.432** (0.024) 0.0121" (0.0017) 1.697** (0.016) (4) 0.1013** (0.0012) 0.258 -0.451" (0.024) 0.0134" (0.0017) 0.0136** (0.0012) -0.000184** (0.000021) -0.095" (0.006) -0.092** (0.006) -0.028"* (0.007) 1.328" R² The sample size is 52,970 observations for each regression. Female is an indicator variable that equals 1 for women and 0 for men. Midwest, South, and West are indicator variables denoting the region of the United States (0.023) 0.267
Help Anwser # 18 please
DUE SOON! Please help!
9. Coe 2
July 11, 2019, Nicholas's mobile home was totally destroyed in a disaster. The area was designated by the President to be a disaster area. On November 15, 2019, Nicholas's insurance company reimbursed him $12,000 for the mobile home. If Nicholas has a gain, when does the replacement period for the mobile home end? 12/31/2021. 12/31/2022. 12/31/2023. 12/31/2024..
Drop down options are -0.618033989 and 1.618033989
OPTION 1 start working with a $10,000bonus and then have yourboss pay you $10,000 perday for 3 full weeksincluding weekend Option 2 start working with a savingsaccount with a quarter in it andyour boss double it each day for 3full weeks including weekends 1.Before starting any work, make a guess. Tell me your choice and WHY you chose this option.Support your guess with information you have learned in this section. 2. For both scenarios: a. Identify each scenario as either linear or exponential .b. Create a general equation for each scenario. 3. Use the equations you found in part 2 to determine how much you would be making afterworking 7 days in both scenarios. 4. Use the equations from part 2 to determine how much you would be making after working14 days in both scenarios. 5. Calculate the total sum collected by both scenarios at the end of the 3 weeks. Clearlyidentify the value in each account at the end of 3 weeks. (Hint: Create a table of values forboth functions and then add.) 6.…
1,2,3,4 please Thank you very much % *
19. investment
Pre cap
An item is regularly priced at $55. It is now priced at a discount of 40% off the regular price. What is the price now? Continue O 2021 McGraw Hill LLC. A. P Type here to search

Recommended textbooks for you

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

SEE MORE TEXTBOOKS