Construct confidence interval around forecast

Reference no: EM13755825

Complete the following questions using the spreadsheet, "data attached." Begin by entering the data provided on a separate Excel spreadsheet and label the tab "handout." Complete the following steps for this assignment.

1. Use regression to estimate the demand function. Show the results.

2. Write the subsequent demand equation, with Qd as the dependent variable; Price, Advertising, Product Development, and Rel Price as the independent variables.

3. How strong is the relationship between the quantity demanded and the set of independent variables? List and briefly interpret at least two measures of this strength.

4. Which variable is most important in determining quantity demanded? Justify the reasoning?

5. Solve for the price elasticity of demand. Classify the product's demand as elastic or inelastic. Price elasticity of demand can be found by the following equation:

ep = (coefficient of price variable x average price) / (average Qd)
Average values for all variables are below.
Qd	626,271
Price	$ 10.06
Advertising	$ 181,000
Product Development	$ 125,417
Rel Price	$ 10.16

6. Solve for the cross price elasticity of demand. Classify the relationship between these products as complements or substitutes. The formula for this coefficient is similar to the one for price elasticity:

Ex: (coefficient of Rel Price variable x average value of Rel price)/(average Qd)

The average variable levels are listed in part (f) above.

7. Forecast Qd if:

Price $10.00

Advertising $150,000

Product Development $150,000

Rel Price $10.25

Construct a 95% confidence interval around this forecast.

Attachment:- problemdata.rar

Reference no: EM13755825

Questions Cloud

Undivided ownership of property : Question 1: With regard to undivided ownership of property, what is the right of survivorship? When does it exist?

What relations between depression and political instability : What was the relationship between the Great Depression and political instability?

Complete the supply and demand simulation : Complete the Supply and Demand Simulation - Write a 700 - 1,050-word paper summarizing the content of the simulation, and address the following:

Discuss primary advantages of gui over a textual interface : Discuss the primary advantages of GUI over a textual (command-line) interface in Linux system administration. Describe two (2) Fedora/Red Hat Enterprise Linux (RHEL) GUI desktop managers and explain how they generally function.

Construct confidence interval around forecast : Write the subsequent demand equation, with Qd as the dependent variable; Price, Advertising, Product Development, and Rel Price as the independent variables - important in determining quantity demanded? Justify the reasoning?

Write essay that discuss sectionalism in american history : Write an essay in which you discuss sectionalism in American history in the first half of the nineteenth century (roughly 1800-1860).

Cost estimation for software development projects : Predict the challenges of cost estimation for software development projects where requirements are usually not clear in early stages of the project

Write paper on with great moustache come great responsiblity : Write a paper on With Great Moustache Comes Great Responsibility?

Create a class library project for the data tier : The company has asked you to build a prototype of an n-tier system using the Northwind database as an example. Create the Data Access tier and Data tier projects: Create a class library project for the Data tier

User Account

All Pages