Regression Analysis

Hi guys,

I'm studying for CFA Level II at the moment and am covering the quants section of the course. Level II quants is mostly about using regression analysis. I find the whole process interesting and it is something I would like to learn, however I have yet to see anyone actually use any of this stuff on the job.

I am a trainee corporate credit analyst and most of what I do revolves around forecasting financials and computing ratios. There are a few examples where I think a regression model could be used to forecast sales, such as for oil & gas companies with regards to oil prices, however beyond that I think the scope is limited.

Is there anyone in the industry who could comment on this or shed some light on their own experiences? Is it worth my while devoting time to learning this stuff or is it a load of fluff?

Thanks!

 

Simple OLS it's ok for most simple stuff (assuming you know how to read the outputs and understand if the model makes sense).

For pair trading the best is to learn co-integration.

For advance electricity pricing I would recommend learning about regime-switching (this one is a pretty advance topic)

Happy to help with any question you may have regarding this stuff.

absolutearbitrageur.blogspot.com
 

We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

Follow me on Twitter: https://twitter.com/_KarateBoy_
 
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

lol

 
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

What about the Durbin-Watson? People tend to look at the p-values (for variables and for the overall model), Adj. R-Squared but tend to forget the DW.

absolutearbitrageur.blogspot.com
 
Best Response
blastoise:
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

lol

<span class=keyword_link><a href=//www.wallstreetoasis.com/finance-dictionary/what-is-a-hedge-fund-HF>HF</a></span>:
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

What about the Durbin-Watson? People tend to look at the p-values (for variables and for the overall model), Adj. R-Squared but tend to forget the DW.

LDNBNKR:
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

wow... at a lackj of words

If I'm doing something wrong, just let me know.

Granted that the sample size is small, but I calculate a correlation between residuals of 0.22. So 2*(1-0.22) = 1.56. Dl and Du are about ~1 and ~1.3, respectively.

But I've used this method in combination with qualitative factors to forecast future GMs and I've been accurate within 10bps.

http://i39.tinypic.com/qrxamv.jpg

Follow me on Twitter: https://twitter.com/_KarateBoy_
 
KarateBoy:
We use it all the time too.

As an example, the primary driver between one of our covered companies is the mix between product segment X and Y. So I ran a regression on change in mix to consolidates GP (R^2 = 95%+). Now, I can model the growth of each product line separately and have gross margin as an output. This effectively reduces my margin of error.

wow... at a lackj of words

 

Level 2 candidate here as well...

I do equity research for a hedge fund.

I've used regression analysis a few times, particularly when a company (let's say retailer) pre-announces sales figures. You want to get EPS and can make educated assumptions about margins, whether OpEx goes up or down, etc.

I've found regression useful in supporting my assumptions - Marketing Expense growth is 85% correlated with sales growth, for example.

I'd never use it for forecasting though. Maybe in a world without management commentary or where all you are given is an income statement data set.

 

I used it in IB all the time. Specifically to estimate what a client company's newly issued debt would be rated in comparison to it's peers based on a number of multiples and metrics.

'We're bigger than U.S. Steel"
 

ARCH and ARIMA for forecasting

Plenty of basic OLS is used in sales forecasting

Making money is art and working is art and good business is the best art - Andy Warhol
 

Personally, if a simple regression works well (with good p-values, Adj. R-squared and DW) I prefer to use it. I tend to see GARCH more as a way of getting rid of volatility clustering.

absolutearbitrageur.blogspot.com
 

Sure. I always try to start with as simple of a model as possible. Problem is almost all of what I work with is going to have autocorrelation or volatility clustering as you mentioned out the ass.

Making money is art and working is art and good business is the best art - Andy Warhol
 
dwight schrute:
Sure. I always try to start with as simple of a model as possible. Problem is almost all of what I work with is going to have autocorrelation or volatility clustering as you mentioned out the ass.

Tough luck man :)

I was just going over two stock series and although the simple regression seems to work well there is volatility clustering, so GARCH it was.

absolutearbitrageur.blogspot.com
 

Thanks for the affirmation. I didn't think I was doing anything blatantly wrong either - I guess others are quick to assume/judge.

I'm a numbers guys but I don't use math as my safety blanket! because I don't believe one can simple model the future based on historic trends. That is why I added the phase "combined with qualitative factors."

The model atop that I posted is not a simple "change in mix model." I did a little more work with the data - but that's not for public consumption.

Follow me on Twitter: https://twitter.com/_KarateBoy_
 

Eius dolor error vero dolor dolore dignissimos. Consequatur error perferendis ratione quod.

Aut veniam sunt laudantium libero. Occaecati quibusdam dolorem rerum qui unde. Similique sint itaque et perferendis aut. Sunt aliquid sit quibusdam debitis ipsa minus magni.

Perferendis odio beatae similique consequatur eum quisquam voluptas. Vel aliquid culpa voluptatem ut. Doloribus modi asperiores recusandae.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Perella Weinberg Partners New 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • William Blair 02 98.3%
  • Lazard Freres 07 97.7%
  • Morgan Stanley 03 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Moelis & Company 06 97.7%
  • Credit Suisse 04 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (23) $378
  • Associates (95) $261
  • 3rd+ Year Analyst (14) $181
  • 2nd Year Analyst (69) $168
  • Intern/Summer Associate (34) $167
  • 1st Year Analyst (210) $160
  • Intern/Summer Analyst (154) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”