Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Excel, make a regression: Y(stock return) = constant + Beta*X(Index returns) + Error terms Monthly Adj close Date KLCI Stock price Nov-20 1,562.71 10.08

Using Excel, make a regression: Y(stock return) = constant + Beta*X(Index returns) + Error terms

Monthly Adj close
Date KLCI Stock price
Nov-20 1,562.71 10.08
Oct-20 1,466.89 9.54
Sep-20 1,504.82 10.5
Aug-20 1,525.21 10.86
Jul-20 1,603.75 11.44
Jun-20 1,500.97 11.62
May-20 1,473.25 11.26
Apr-20 1,407.78 12.24
Mar-20 1,350.89 12.02
Feb-20 1,482.64 12.1
Jan-20 1,531.06 12.46
Dec-19 1,588.76 13.26
Nov-19 1,561.74 13.16

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

Personal Finance

Authors: Vickie L Bajtelsmit

2nd Edition

111959247X, 9781119592471

More Books

Students also viewed these Finance questions