Are the estimated coefficients statistically significant

Reference no: EM133561534

Assignment: Activities- Regression Analysis

In this activity, the object is to estimate a demand function. Begin by accessing the data file ‘DataRegression.xlsx'. The data consist of quantity (‘average number of coach seats') and price (‘average price'). Coach seats refers to the seats on a particular airline.

1. Run a regression of ‘Average number of coach seats' on ‘Average Price'. This gives a demand function. Use either the ‘data analysis' package in Excel or my preference R. Provide the summary statistics. Are the estimated coefficients statistically significant?

2. Use the demand function to predict the number of seats that would be purchased if the price were to $255 for the four quarters in year 5.

3. Next regress price on quantity and provide the summary statistics. Are the estimated coefficients statistically significant? Do the estimated coefficients differ once the inverse demand function has been converted back to the normal specification?

4. Now re-estimate the demand function by including in addition to the ‘average price', the ‘average competitor price' and the ‘average income'. Interpret each of the estimated coefficients. Are the estimated coefficients statistically significant? How do the results differ from those in (1)?

5. Repeat the prediction in (2). Is the prediction the same? If not, why?

6. Repeat (4) but, instead of quantity Q as the dependent variable, take the natural logarithm of the dependent variable, ln(Q), and make the dependent variable.

Reference no: EM133561534

Questions Cloud

Write a paper about the specific career role : Conduct comprehensive research on the aspects - Responsibilities associated with the chosen role - Salary expectations for the entry position in this field

Discuss how the time value of money works : Explain difference between nominal, periodic and effective interest rates. Discuss how time value of money works and why it is an important concept in finance.

Licensed practical nurse negligent : Andrea, a licensed practical nurse (LPN), works in Dr. Meyer's private facility. Explain how Dr. Meyer could defend himself against a negligence lawsuit.

Describe the chemical and electrical processes used : Describe the chemical and electrical processes used in neurotransmission. Why are depolarizations referred to as excitatory postsynaptic potentials

Are the estimated coefficients statistically significant : Use either the ‘data analysis' package in Excel or my preference R. Provide the summary statistics. Are the estimated coefficients statistically significant?

What are some of the modern technologies utilized : What are some of the modern technologies utilized in healthcare settings today? What technologies do you use in your current clinical setting?

Define a target architecture for archihospital : Define a target architecture for ArchiHospital. Consider the business capabilities, business, information, application, and technology layers

How would you determine the suitability of the external : What information should be conveyed when engaging the services of an external specialist for advice or further training? How would you determine the suitability

What are the benefits and limitations of an ehr : Electronic Health Records have become arguably one of the most important technological advancements in healthcare. What are the benefits and limitations

User Account

All Pages