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: 439 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 > Business & Finance Posted 20 Jun 2017 My Price 10.00

Here is the stock price history of “HighTech” and “LowTech” corporations.

Here is the stock price history of “HighTech” and “LowTech” corporations.

1.a. The annual returns for each stock.

1.b. The mean (average) return for the period of 10 years for each firm. Which stock has the higher average return?

1.c. The variance and the standard deviation of returns, for the period of 10 years for each firm. Which stock is riskier?

1.d. The covariance and correlation of the returns for each firm. Use two formulas to compute the correlation: The Excel formula Correl and the definition

 

 

                

1.e. If you had to choose between the two stocks, which would you choose? Explain briefly.

 

Answers

Alpha Geek
(8)
Status NEW Posted 20 Jun 2017 12:06 PM My Price 10.00

-----------

Attachments

file 1497961670-2253307_1_636331323600737354_Returns-sheet.xlsx preview (107 words )
AB-----------CHi-----------gh -----------Tec----------- St-----------ock----------- Pr-----------ice-----------Low----------- Te-----------c S-----------toc-----------k S-----------har-----------e P-----------ric-----------eAn-----------nal----------- Re-----------tur-----------ns -----------for----------- Hi-----------gh -----------Tec-----------hAn-----------nal----------- Re-----------tur-----------ns -----------for----------- Lo-----------w T-----------ech-----------1.a-----------)1.-----------b)A-----------ver-----------age----------- Re-----------tur-----------n f-----------or -----------Hig-----------hTe-----------chA-----------ver-----------age----------- Re-----------tur-----------n f-----------or -----------Low-----------Tec-----------hIf----------- we----------- co-----------mpa-----------re -----------the----------- av-----------era-----------ge -----------ret-----------urn-----------s f-----------or -----------Hig-----------h T-----------ech----------- an-----------d L-----------ow -----------Tec-----------h t-----------hen----------- we----------- ca-----------n s-----------ee -----------tha-----------t L-----------ow -----------Tec-----------h h-----------as -----------Hig-----------her----------- Re-----------tur-----------n1.-----------C)V-----------ari-----------anc-----------e f-----------or -----------Hig-----------h T-----------ech-----------Sta-----------nda-----------rd -----------Dev-----------iat-----------ion----------- fo-----------r H-----------igh----------- Te-----------chV-----------ari-----------anc-----------e f-----------or -----------Low----------- Te-----------chS-----------tan-----------dar-----------d D-----------evi-----------ati-----------on -----------for----------- Lo-----------w T-----------ech-----------Ple-----------ase----------- No-----------te:----------- We----------- ca-----------n n-----------ot -----------cal-----------cul-----------ate----------- th-----------e r-----------etu-----------rns----------- fo-----------r
Not Rated(0)