Regression analysis of annual sales

Reference no: EM1396674

Reliable Furniture is a family business that has been selling to retail customers in the Chicago area for many years. They advertise extensively on radio and TV, emphasizing their low prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months.

a) The owner wants to forecast sales based on advertising expense. Which variable is the dependent variable? Which variable is the independent variable?

b) the coefficient of determination.(R2) = 0.9308 what does this mean?

c) The regression analysis formula is y= 2.2x + 1.5 What sales would we expect if we spent 2.5 million in advertising? 5 million?
Month Advertising Expense ($ Million) Sales Revenue ($ Million)

July 2 7

August 1 3

September 3 8

October 4 10

d) Draw a scatter diagram.

e) Draw the regression line.

f) Determine the coefficient of correlation.

Reference no: EM1396674

Questions Cloud

Demand function for daily attendance : Calculate the price that the Plaza Movie House will charge for admission to movies in the long run and what will be the number of patrons per day at that price?

Minimization and maximization lp model : Distinguish between a minimization and maximization LP model. Other than minimizing costs and maximizing profits, give a real-world example of where you would want to minimize something or maximize something.

Competitive or noncompetitive inhibitor of enzyme reaction : You are studying compound X and are trying to determine whether it is a competitive or a non-competitive inhibitor of an enzyme reaction catalyzed by the enzyme zyrase.

General rule paper must contain directly quoted materials : As general rule, no more than 15% to 20% of your paper must contain directly quoted materials. Do you agree with this rule?

Regression analysis of annual sales : Reliable Furniture is a family business that has been selling to retail customers in the Chicago area for many years. They advertise extensively on radio and TV, emphasizing their low prices and easy credit terms.

Problem related to poisson distribution with mean : A store selling newspapers orders only x=4 of a certain newspaper because the manager does not get many calls for that publication. If the number of requests per day follows a Poisson distribution with mean 3.

Assumptions and requirements for lp model : What are the assumptions and requirements for an LP model to be formulated and used? Under what conditions will an LP problem: be unbounded? be infeasible? have more than one optimal solution?

Calculate how you will accomplish this task : Calculate how you will accomplish this task.

Estimate the diameter of the specimen : The 4X objective has a field of view of 3mm. If you viewed a specimen through the 10X objective and the specimen spanned approximately 50% of the field of view!

User Account

All Pages