Reference no: EM131655538
Question: Refer to the Grinfield Service Company discussed in Problem.
a. Develop the least squares regression equation for these variables. Plot the regression line on the scatter plot.
b. Develop a 95% confidence interval estimate for the increase in sales resulting from increasing the advertising budget by $50. Interpret the interval.
c. Discuss whether it is appropriate to interpret the intercept value in this model. Under what conditions is it appropriate? Discuss.
d. Develop a 90% confidence interval for the mean sales amount achieved during all weeks in which advertising is $200 for the week. e. Suppose you are asked to use this regression model to predict the weekly sales when advertising is to be set at $100. What would you reply to the request? Discuss.
Problem: The Grin field Service Company's marketing director is interested in analyzing the relationship between her company's sales and the advertising dollars spent. In the course of her analysis, she selected a random sample of 20 weeks and recorded the sales for each week and the amount spent on advertising. These data are contained in the data file called Grin field.
a. Identify the independent and dependent variables.
b. Draw a scatter plot with the dependent variable on the vertical axis and the independent variable on the horizontal axis.
c. The marketing director wishes to know if increasing the amount spent on advertising increases sales. As a first attempt, use a statistical test that will provide the required information. Use a significance level of 0.025. On careful consideration, the marketing manager realizes that it takes a certain amount of time for the effect of advertising to register in terms of increased sales. She therefore asks you to calculate a correlation coefficient for sales of the current week against amount of advertising spent in the previous week and to conduct a hypothesis test to determine if, under this model, increasing the amount spent on advertising increases sales. Again, use a significance level of 0.025.