Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / You work as an economist for a major oil company. The CEO asks for the following in a meet...

You work as an economist for a major oil company. The CEO asks for the following in a meeting: Should the company lower/raise the price of natural gas in the state of ______________? What is the

You work as an economist for a major oil company. The CEO asks for the following in a meeting:

Should the company lower/raise the price of natural gas in the state of ______________?

What is the price elasticity of demand (show the Excel regression output)?

What will happen to our revenue if we do lower/raise the price?

What do you recommend?

 

Instructions

1)Download the data into Excel

2)Isolate the price data and sales data into one sheet

3)Make sure the dates line up

4)Calculate the natural logarithm of each variable

5)Make sure version of Excel has Data Analysis add-in

6)Run a regression of price (x variable) and sales (y variable) with output in new worksheet

7)The coefficient is your elasticity

Data:

http://www.eia.gov/naturalgas/data.cfm#consumption

 

Aug 23 2021 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions