Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Forecasting
- /
- How to interpret R-square trend?

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 02-29-2016 01:49 AM
(909 views)

Hi all,

Appreciate if you could help me with these questions.

When I calculate beta between a stock vs an index. R-square represents how much the index returns explain the stock price returns.

However, if I see a declining/increasing trend in RSQ (Beta could stay unchanged), how could I interpret that trend now?

Now if I calculate RSQ for all index members, sum them together and see a trend, what is the implication from the trend there?

Thank you.

Dennis

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

*Beta*, I guess is a linear regression slope. *Members*, I guess are stocks that make up a market index (a weighted sum). What is RSQ?

PG

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

My guess is RSQ represents R-Square.

Did you include more independent variables into or exclude some variables from the model? That may cause the change in R-Square.

Are you trying to measure the relationship between variables or to do forecasting? R-Sqaure measures the goodness-of-fit. If you would like to evaluate the forecasting performance, you may want to do out-of-sample test. Here is a good paper

L. J. Tashman, “Out-of-sample tests of forecasting accuracy: an analysis and review,” *Int. J. Forecast.*, vol. 16, no. 4, pp. 437–450, 2000.

http://www.sciencedirect.com/science/article/pii/S0169207000000650

Thanks,

Rain

Check out the time series and forecasting tasks in SAS Studio! They provide an easy point-and-click interface for Time Series Data Preparation, Time Series Exploration, and Time Series Modeling and Forecasting.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Totally aware of the concepts but I got some troubles interpreting the results here.

I'm doing 1 factor analysis only so I do not use many variables.

Definitely I want to do forecasting. The issue here is, if I do rolling regression day by day and see a declining trend in R-square. That seems to indicate that my independent (even though the index is not that independent) variable has less and less power in predicting the future price. Hence, what I can think of is, waiting to see when R-square is trending up to decide to reuse the model again.

Thanks for sharing the paper. I'll take a look.

In the meantime, hope someone could help clarify the sum of R-square trending issue.

Dennis

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

**If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. **

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.