Homework answers / question archive / Fin4450 Technology assessment Questions: ( 5 credits) Please use the excel worksheet in the folder for following questions

Fin4450 Technology assessment Questions: ( 5 credits) Please use the excel worksheet in the folder for following questions

Finance

Share With

---

Fin4450 Technology assessment Questions: ( 5 credits)

Please use the excel worksheet in the folder for following questions. In the excel table listed are weekly S&P500 weekly return and Apple company weekly return in the last two years. 

Please create your excel worksheet with regression to answer following questions and also submit your excel work using the assignment excel submission link.

 

Step1: Run regression analysis, please make sure to pick up correct dependent variable and independent var.

Step2: Please use the assignment question link to submit answers to following questions on BB.

 

Questions:

 

What is slope of the regression analysis?  

 

 What is R^2 of your regression? 

 

How much is intercept?

 

How much is SSR for this regression?

 

Is market index return significant to your company return or not? Yes or No

 

Step3:

Please submit through excel submission link for excel file.