- Joined
- 4/5/11
- Messages
- 1
- Points
- 11
I'm making a model with a goal of showing the relation between historical oil prices, NG prices, and Exxon's upstream earnings per barrel.
I'd like to end up visualizing the data with a 3d surface chart. My goal is to show what price levels represent a net loss, as well as the probability that those scenarios could happen.
My first idea was to just calculate NG price/BOE and earnings/BOE, and oil price and then run a regression. It's a good fit, but it doesn't take into account the production volume (i.e. since NG production in BOEs is about 75% of oil, it won't have as much of an effect on earnings).
What should I do?
I can use Excel and Matlab.
I'd like to end up visualizing the data with a 3d surface chart. My goal is to show what price levels represent a net loss, as well as the probability that those scenarios could happen.
My first idea was to just calculate NG price/BOE and earnings/BOE, and oil price and then run a regression. It's a good fit, but it doesn't take into account the production volume (i.e. since NG production in BOEs is about 75% of oil, it won't have as much of an effect on earnings).
What should I do?
I can use Excel and Matlab.
