Purchase Solution

Regression Analysis of Pet Food Data

Not what you're looking for?

Ask Custom Question

The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. A random sample of 12 equal-sized stores is selected, with the following results (see attachment called PetFood).

A. Construct a scatter plot. For these data b0 = 145 and b1 = 7.4
B. Interpret the meaning of the slope, b1, in this problem.
C. Predict the weekly sales of pet food for stores with 8 feet of shelf space for pet food.

The marketing manager used shelf space for pet food to predict weekly sales (see attachment PetFood). For those data, SSR=20,535 and SST=30,025

D. Determine the coefficient of determination, r2, and interpret its meaning.
E. Determine the standard error of the estimate.
F. How useful do you think this regression model is for predicting sales.

G. Perform a residual analysis for this data (see attachment PetFood). Evaluate whether the assumption of regression have been seriously violated.

Please use Excel.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation of various aspects of Regression Analysis as it pertains to the given problem. Supplemented with EXCEL output and text, this step-by-step explanation of this complicated topic provides students with a clear perspective of Regression Analysis.

Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • 6 Hypothesis Testing Questions

    ANSWER: Problem 14.22 In problem 14.3 (above), the marketing manager used shelf space for pet food to predict weekly sales. Perform a residual analysis for these data. Based on the results obtained, a.

  • Regression analysis

    124846 Regression analysis for Business Statistics - Effect of Shelf Space on Sales of Pet Food. Problem #1 The marketing manager of a large supermarket chain would like to determine the effect of shelf space on the sales of pet food.

  • Conducting Simple Regression and Interpretating the Results

    For these data, b0 = 145 and b1 = 1 7.4 b) Interpret the meaning of the slope, b1, in this problem c) Predict the weekly sales of pet food for stores with 8 feet of shelf space for pet food. 2.

  • Simple linear regressions and predictions

    For these data, bo = 145, and b1 = 7.4. b. Interpret the meaning of the slope b1, in this problem. c. Predict the weekly sales of pet food for stores with 8 sf of shelf space for pet food. Please see the attached files.

  • Regression/Confidence Intervals for Marketing Department

    600965 Regression/Confidence Intervals for Marketing Department The marketing department of a large supermarket chain would like to determine the effect of shelf space devoted to pet food on the sales of pet food.

  • Case study solution with the help of statistical techniques

    The data as downloaded is formatted correctly for regression analysis, so you will have to transform your data prior to estimating the ANOVA.

  • MCQs: Correlation & Regression

    290600 Statistics Correlations: Sales of pet food The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food.

  • ANOVA and Regression problems

    The data as downloaded is formatted correctly for regression analysis, so you will have to transform your data prior to estimating the ANOVA.

  • ANOVA & Regression Analysis for Beast Buy

    416604 ANOVA & Regression Analysis for Beast Buy You work in the shipping and logistics department for Beast Buy, an American mail order company that specializes in pet food for VERY exotic pets.

View More Related Solutions