Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a xy spatter chart from the data on the Apple sheet. Add a trend line and calculate Beta and Slope for the data. DATE

Create a xy spatter chart from the data on the Apple sheet. Add a trend line and calculate Beta and Slope for the data.

DATE COMNAM TICKER vwretd RET 31/01/2007APPLE INC AAPL 0.019428 0.01049 28/02/2007APPLE INC AAPL -0.01396 -0.01306 30/03/2007APPLE INC AAPL 0.012949 0.098097 30/04/2007APPLE INC AAPL 0.039821 0.074158 31/05/2007APPLE INC AAPL 0.038932 0.214339 29/06/2007APPLE INC AAPL -0.01476 0.007005 31/07/2007APPLE INC AAPL -0.03176 0.079646 31/08/2007APPLE INC AAPL 0.011656 0.051002 28/09/2007APPLE INC AAPL 0.04086 0.108247 31/10/2007APPLE INC AAPL 0.025835 0.237701 30/11/2007APPLE INC AAPL -0.04922 -0.0407 31/12/2007APPLE INC AAPL -0.00442 0.087038 31/01/2008APPLE INC AAPL -0.06215 -0.31664 29/02/2008APPLE INC AAPL -0.02165 -0.07639 31/03/2008APPLE INC AAPL -0.01042 0.147816 30/04/2008APPLE INC AAPL 0.051105 0.212195 30/05/2008APPLE INC AAPL 0.023843 0.085082 30/06/2008APPLE INC AAPL -0.07843 -0.1129 31/07/2008APPLE INC AAPL -0.01333 -0.05071 29/08/2008APPLE INC AAPL 0.010564 0.066562 30/09/2008APPLE INC AAPL -0.09801 -0.32956 31/10/2008APPLE INC AAPL -0.1846 -0.05341 28/11/2008APPLE INC AAPL -0.08462 -0.13868 31/12/2008APPLE INC AAPL 0.022149 -0.07899 30/01/2009APPLE INC AAPL -0.07733 0.056005 27/02/2009APPLE INC AAPL -0.10018 -0.0091 31/03/2009APPLE INC AAPL 0.086693 0.177024 30/04/2009APPLE INC AAPL 0.109359 0.197013 29/05/2009APPLE INC AAPL 0.067789 0.079313 30/06/2009APPLE INC AAPL -0.0031 0.048745 31/07/2009APPLE INC AAPL 0.081718 0.14716 31/08/2009APPLE INC AAPL 0.031466 0.0295 30/09/2009APPLE INC AAPL 0.045235 0.101896 30/10/2009APPLE INC AAPL -0.028 0.016995 30/11/2009APPLE INC AAPL 0.057099 0.060531 31/12/2009APPLE INC AAPL 0.028419 0.054134 29/01/2010APPLE INC AAPL -0.0371 -0.08859 26/02/2010APPLE INC AAPL 0.034775 0.06538 31/03/2010APPLE INC AAPL 0.063605 0.14847 30/04/2010APPLE INC AAPL 0.020011 0.111021 28/05/2010APPLE INC AAPL -0.07914 -0.01613 30/06/2010APPLE INC AAPL -0.05072 -0.02083 30/07/2010APPLE INC AAPL 0.071554 0.022741 31/08/2010APPLE INC AAPL -0.04282 -0.05501 30/09/2010APPLE INC AAPL 0.091518 0.167215 29/10/2010APPLE INC AAPL 0.038532 0.060723 30/11/2010APPLE INC AAPL 0.005165 0.03379 31/12/2010APPLE INC AAPL 0.067152 0.03667 31/01/2011APPLE INC AAPL 0.019157 0.051959 28/02/2011APPLE INC AAPL 0.038164 0.040935 31/03/2011APPLE INC AAPL 0.003374 -0.01331 29/04/2011APPLE INC AAPL 0.028689 0.004656 31/05/2011APPLE INC AAPL -0.01493 -0.00657 30/06/2011APPLE INC AAPL -0.0184 -0.03496 29/07/2011APPLE INC AAPL -0.02247 0.163285 31/08/2011APPLE INC AAPL -0.05747 -0.01447 30/09/2011APPLE INC AAPL -0.08487 -0.00912 31/10/2011APPLE INC AAPL 0.113984 0.061523 30/11/2011APPLE INC AAPL -0.00623 -0.05578 30/12/2011APPLE INC AAPL 0.003701 0.059655

On the Apple Data sheet, what is the R2 value on your chart? Use only 3 decimal places in your answer.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Monetary Policy Strategy

Authors: Frederic S. Mishkin

1st Edition

0262513374, 978-0262513371

More Books

Students also viewed these Finance questions