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

Finance Mar 23, 2022

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.

Expert Solution

PFA

Download Solution Attachment (PDF/Doc)

Archived Solution

Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In

Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution

Get Custom Quote