0% found this document useful (0 votes)
10 views8 pages

Regression Analysis of Apple Stock Returns

Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views8 pages

Regression Analysis of Apple Stock Returns

Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Manar Alsayah

Leen Bou Yahya

Exercise 1 In this exercise, we will build a regression model for predicting stock returns,
similar to what we have learned in lecture. The data file is [Link]. This data tracks
the monthly performance of the stock of Apple. There are 264 months in the data. The
variables in the data are the following. ]

• Month: time variable


• AppleReturn: monthly % change (i.e., return or avkastning) in the value of Apple
stock
• MarketReturn: monthly % change (i.e., return or avkastning) in the value of the
whole stock market
• SP500Return: monthly % change (i.e., return or avkastning) in the value of the
S&P 500 Index (the 500 largest companies in the U.S.) bonds)

You can load the [Link] data into Stata by using the command import delimited

(a) Estimate the SRM of AppleReturn (y variable) on MarketReturn (x variable).


(i) What is the equation of the sample regression line?

(ii) Interpret the estimated coefficients b0 and b1.

Intercept (b0) = 0.0152902

• This means when the market return is 0%, Apple stock is expected to have a
return of 1.53%

Slope (b1) = 1.345951

• This means that for every 1% increase in the market return, Apple stock’s return
is expected to increase by 1.35%
(b) Estimate the MRM regression of AppleReturn (y variable) on MarketReturn and
SP500Return (x variables).

(i) What is the equation of the sample regression line?

The equation of the sample regression line:

Apple^Return = 0.122065 + 3.017439 x MarketReturn – 1.764322 x SP500Return

(ii) Interpret the estimated coefficients b0, b1, and b2.

Intercept (b0) = 0.122065

• This means when both the market return and SP500 return are 0%, Apple’s stock
return is expected to be 1.22%

Market Return coefficient (b1) = 3.017439

• This means that for every 1% increase in the market return, Apple’s stock return
is expected to increase by 3.02%

SP 500 Return coefficient (b2) = - 1.764322

• Which means that for every 1% increase in the SP 500 return, Apple’s stock
return is expected to fall by 1.76%

(iii) Does the model have explanatory power?


No, because the R-squared is 0.2055, that means that the model has limited
explanatory power.

(iv) Does the model satisfy the MRM conditions? Hint: create the different plots and
figures we learned in lecture.

(c) Find the correlation of AppleReturn, MarketReturn, and SP500Return. Are there any
variables that are highly correlated? Which ones? Hint: use the command correlate.

The variables that are highly correlated are Market Return and SP 500 Return, as their
correlation coefficient is 0.9824, which is very close to 1.

(d) Looking at the results in parts (a)–(c), are there any signs of collinearity? Explain.
Yes, there are signs of collinearity. Market Return and SP 500 Return have a high
correlation of 0.9824, meaning they are very similar. This can make it hard to figure out
the individual effect of each variable on Apple Return, leading to less reliable results in
the regression.

(e) How would you suggest improving the MRM in part (b), or would you just leave it as
is?

To improve the MRM in part (b), i would suggest removing one of the correlated
variables (Market Return or SP 500 Return) to reduce collinearity.

Exercise 2 The supermarket company Rema1000 has a loyalty program through their
app Æ. In June 2022, the company changed the structure of the program. Now,
customers receive coupons with person- alized discounts in the Æ app.

Suppose that Rema1000 has asked you to investigate if the coupons lead to higher
spending. You are given a dataset of 1000 Æ app users in June 2022. The data has the
following variables: the amount of money spent by the user at Rema1000 (kroner),
whether the user used a coupon (Yes/No), whether the user is a student (Yes/No). See
the figure below for what the data looks like.

You want to use these data to estimate the effect of coupons on Æ users’ spending.
Note: There is no dataset for this question. You are asked to explain how you would do
the analysis if you had the data.

(a) You hypothesize that even if you compare two different users who both used a
coupon, a user who is a student will generally have lower spending than a user who is
not a student.
(i) Write the population regression model that would allow you to test this hypothesis.
Explain each variable in your model. Explain the meaning of each coefficient in your
model.

Common questions

Powered by AI

To improve the explanatory power of the regression model for Apple's stock returns, one could consider reducing collinearity by removing one of the highly correlated independent variables, such as either MarketReturn or SP500Return. This would help in reducing redundancy in the explanatory variables and improve the clarity of the individual impact on AppleReturn. Additionally, incorporating other relevant predictors that could impact Apple stock returns might also help in boosting the model's explanatory power .

A simple regression model for predicting stock returns may have limitations such as ignoring other relevant variables that might influence returns, leading to omitted variable bias. In the Apple example, relying solely on the MarketReturn to predict AppleReturn doesn't account for other influential factors like industry trends or economic indicators. This could limit the model's accuracy and comprehensiveness. Additionally, if there is multicollinearity or autocorrelation in time series data, it further diminishes the precision of the regression estimates .

Removing one highly correlated variable, such as either MarketReturn or SP500Return, can help improve the regression model by addressing multicollinearity. When variables are highly correlated, it becomes challenging to isolate the impact of each variable independently. By eliminating one, the model becomes more parsimonious and it clarifies the distinct effects of remaining variables, leading to more reliable and interpretable coefficient estimates, reducing the variability and potential instability in the model predictions .

A high R-squared value does not necessarily indicate a good regression model. It simply shows the proportion of variance in the dependent variable that is predictable from the independent variable(s). In the case of Apple's stock exercise, despite having a regression line, the R-squared value of 0.2055 illustrates limited explanatory power. The presence of collinearity impacts the reliability of the coefficients independently, thus even if R-squared were higher, it could mask significant deficiencies in the model such as multicollinearity issues or model misspecification .

In the regression model for Apple's stock returns, the intercept (b0) represents the expected value of the dependent variable (AppleReturn) when all independent variables (MarketReturn and SP500Return) are zero. In the simple regression model of AppleReturn on MarketReturn, the intercept (b0) is 0.0152902, which means when the market return is 0%, Apple's stock is expected to have a return of 1.53% . In the multiple regression model, the intercept is 0.122065, indicating an Apple stock return of 1.22% when both the market return and SP500 return are 0% .

The high correlation coefficient of 0.9824 between the market return and the S&P 500 return indicates a strong linear relationship between these two variables, suggesting that they move together closely. In the context of Apple's stock return model, this strong correlation can lead to multicollinearity issues, making it difficult to reliably estimate each variable's independent effect. It implies that changes in the broader market context are reflected proportionately in the S&P 500, which could dominate the influence on Apple's stock returns .

In a regression model analyzing the effect of coupons on spending, each coefficient provides insights into the relationship between predictor variables and spending. For example, the coefficient of the coupon variable would indicate the change in spending associated with using a coupon. A positive coefficient would suggest that coupon users spend more compared to non-users. Additionally, if a student variable is included, its coefficient would capture the difference in spending between students and non-students, implying the potential moderation effect of the student status on coupon effectiveness .

Collinearity refers to a situation where two or more independent variables in a multiple regression model are highly correlated. This can pose problems for estimating the individual effect of each variable, as it makes it difficult to separate out the impact of each on the dependent variable. In the context of the Apple stock return model, the high correlation of 0.9824 between MarketReturn and SP500Return suggests that these two variables are very similar. This high level of collinearity means it can be difficult to determine the individual impact of each variable on AppleReturn, leading to less reliable estimations .

The population regression model proposed for analyzing coupon effects on spending would include spending as the dependent variable, and coupon usage and student status as independent variables. The model would look like: Spending = β0 + β1(Coupon) + β2(Student) + ε, where β0 is the intercept, β1 is the coefficient for coupon usage indicating how spending levels change when using a coupon, β2 is the coefficient for student status reflecting spending variations between students and non-students, and ε is the error term capturing unobserved factors influencing spending .

The proposed analysis suggests using a regression model to estimate the effect of personalized coupons on spending behavior. By setting up a population regression model where the dependent variable represents the amount of money spent, and the independent variables include the use of a coupon and student status, one can analyze how coupon usage impacts spending levels. The hypothesis is that even among coupon users, student spending might differ due to budget constraints or other factors, allowing for a comparative analysis to isolate the coupon's impact .

You might also like