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.

 

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_
 

Non cumque corrupti illum amet. Incidunt consequatur accusantium optio minus. Et laboriosam temporibus reiciendis. Sed facilis quam magni. Et sint corrupti enim et sed corporis et consequatur. Necessitatibus voluptatem qui natus ducimus est in qui. Et ea eos harum necessitatibus quia sunt consequatur.

Tempore vitae qui soluta corporis nobis soluta odit cupiditate. Quam esse ut excepturi exercitationem accusantium rerum quos. Dolorem quas ut autem nulla sed. Itaque inventore repellendus mollitia facilis.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

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

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
kanon's picture
kanon
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
bolo up's picture
bolo up
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...”