Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 346 Weeks Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Statistics Posted 01 May 2017 My Price 7.00

Using Probability Distributions Suppose the returns

Using Probability Distributions Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Excel® to answer the following questions:

a. What is the probability that in any given year, the return on long-term corporate bonds will be greater than 10 percent? Less than 0 percent

b. What is the probability that in any given year, the return on T-bills will be greater than 10 percent? Less than 0 percent?

c. In 1979, the return on long-term corporate bonds was -4.18 percent. How likely is it that such a low return will recur at some point in the future? T-bills had a return of 10.56 percent in this same year. How likely is it that such a high return on T-bills will recur at some point in the future?

 

Answers

Alpha Geek
(8)
Status NEW Posted 01 May 2017 10:05 AM My Price 7.00

-----------

Attachments

file 1493633689-answer1.docx preview (183 words )
U-----------sin-----------g P-----------rob-----------abi-----------lit-----------y D-----------ist-----------rib-----------uti-----------ons----------- Su-----------ppo-----------se -----------the----------- re-----------tur-----------ns -----------on -----------lon-----------g-t-----------erm----------- co-----------rpo-----------rat-----------e b-----------ond-----------s a-----------nd -----------T-b-----------ill-----------s a-----------re -----------nor-----------mal-----------ly -----------dis-----------tri-----------but-----------ed.----------- Ba-----------sed----------- on----------- th-----------e h-----------ist-----------ori-----------cal----------- re-----------cor-----------d, -----------use----------- th-----------e N-----------ORM-----------DIS-----------T f-----------unc-----------tio-----------n i-----------n E-----------xce-----------l®----------- to----------- an-----------swe-----------r t-----------he -----------fol-----------low-----------ing----------- qu-----------est-----------ion-----------s: ----------- a.----------- Wh-----------at -----------is -----------the----------- pr-----------oba-----------bil-----------ity----------- th-----------at -----------in -----------any----------- gi-----------ven----------- ye-----------ar,----------- th-----------e r-----------etu-----------rn -----------on -----------lon-----------g-t-----------erm----------- co-----------rpo-----------rat-----------e b-----------ond-----------s w-----------ill----------- be----------- gr-----------eat-----------er -----------tha-----------n 1-----------0 p-----------erc-----------ent-----------? L-----------ess----------- th-----------an -----------0 p-----------erc-----------ent----------- b-----------. W-----------hat----------- is----------- th-----------e p-----------rob-----------abi-----------lit-----------y t-----------hat----------- in----------- an-----------y g-----------ive-----------n y-----------ear-----------, t-----------he -----------ret-----------urn-----------
Not Rated(0)