Purchase Solution

Regression analysis of annual sales based on advertising expense

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

The solution gives the details of regression analysis of annual sales based on advertising expense. Estimation of regression coefficients, correlation and interpretations of results are included. Model adequacy and scatter diagram are also given.

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Standard Error Estimates

    SOURCE DF SS MS X3 = advertising expense (in $ thousands).

  • Regression analysis for advertising expense.

    Estimate sales when $3 million is spend on advertising. Please see the attachments The solution provides step by step method for the calculation of regression model for advertising expense.

  • Regression Analysis - Writing equation and interpretation

    You gather some historical data on Sales and Advertising expenses and run a simple regression using Sales as the dependent variable and Advertising Expense as the independent variable.

  • Quantitative Analysis using Regression Modelling

    Analysis, Scatter Plot Matrix and Regression Analysis] The solution is comprised of detailed regression analysis pertaining to three problems related to Quantitative Analysis.

  • Regression Analysis

    55956 Regression Analysis Sales and Advertising expenses are used for the simple regression data attached. Sales is the dependent variable and Advertising Expense is the independent variable.

  • Hagerty's Furniture Regression Analysis

    Below is information on sales and advertising expense for the last four months.

  • Multiple Regression Analysis on Store Profession

    X2 = population of the region (in millions). X3 = advertising expense (in $ thousands). The sample data were run on MINITAB, with the following results.

  • Week 9 Stats HW Studyguide

    increase of $1 in advertising is correlated with an increase of $2 in sales. increase of $1 in advertising is correlated with an increase of $100 in sales.

  • Scatter diagram, regression

    A research project involves predicting monthly sales based on the annual amount spent on placing ads on bus benches. A sample of quick-print firms revealed these advertising expenses and sales.

View More Related Solutions