Answered step by step
Verified Expert Solution
Question
1 Approved Answer
whole table isnt shown. please show what excel formula would be, etc. all help is appreciatied! data has already loaded W you. Find the change
whole table isnt shown. please show what excel formula would be, etc. all help is appreciatied!
data has already loaded W you. Find the change for both AMD and SPY (G19 hint}, Subtract the risk free rate, Learn CAGR [cells F17 and 017). Complete the bl Complete the green Chase Data > Data Analysis > Regression and gss AMD against SPY. Output in cell 12. plot on the Y-axis and SPY on the X-axis), Add a and the option and the Chart. the in 13.19 12 2s 12.52 12 7s 14.22 11, 84 11.12 26 11.38 11.38 10 73 57.03% =5QRT521 Annual weekly r, WEEKLY 246.88 247.41 244.12 2-12 _ 11 244.56 247.84 2'6_sg 249.19 249.44 2S1_23 25437 254.95 257.71 258.45 2sg_cg 257.86 260.36 26146 265.51 266.51 o. 0385% 0.339 0.0052 -oas -C. 01 -INTERCEPTO o_costsggsg e(E1g-E1gVE1g-Fa 7/17/17 7/.017 8/7/17 8/2017 8/28/17 g/a/17 9/11/17 9/18/17 g/2s/17 10/2/17 10/9/17 10/16/13 10/23/17 10/30/17 11/6/17 11/13/17 11/20/17 11/27/13 12/4/17 12/11/17 WEEKLY B. 88 13.12 12.23 12 12.43 13 81 -0.07 -0.07 Regressicm Output atl'12. 1) the of and in blue and a in the box, the equation in scatter *ot, the regression vales fcy intercept and variable. 2) If have a RZ value but the independent variables are Statistically Sienificant, t sions relatimships H r, generate tmt are relatively a IOW Thoughts the and the tStat in case?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started