Explore BrainMass

Explore BrainMass

    Reid Sanders Case Study: Linear Regression Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Chapter 8 Problem 25 Reid Sanders. The following data were collected on the study of the relationship between a company's retail sales and advertising dollars: Retail Sales ($) Advertising ($) 29,789 16,893 35,434 18,398 38,732 20,376 43,585 22,982 46,821 25,732 49,283 27,281 52,271 32,182 55,289 35,298 57,298 36,281 58,293 38,178

    (a) Obtain a linear regression line for the data.
    (b) Compute a correlation coefficient and determine the strength of the linear relationship.
    (c) Using the linear regression equation, develop a forecast of retail sales for advertising dollars of $40,000.

    Please provide the solution in Excel.

    © BrainMass Inc. brainmass.com April 3, 2020, 11:03 pm ad1c9bdddf

    Solution Preview


    (Please see attached Excel file for calculations in Excel)

    Retail Sales ($) Advertising ...

    Solution Summary

    This solution helps answer questions regarding linear regression analysis of a case study involving Reid Sanders. It provides a linear regression line, computes a correlation coefficient, determines the strength of the linear relationship, and develops a forecast of retail sales. The solution is provided in Excel.