Purchase Solution

Regression analysis for advertising expense.

Not what you're looking for?

Ask Custom Question

Ann's furniture store is a family business that has been selling to retail customers in the Chicago area for many years. They advertise extensively on radio, TV, and the Internet, emphasizing the low prices and easy credit terms. The owner would like to review the relationship between sales and the amount spend on advertising. Below is the information on sales and advertising expenses for the last four months.

Month Advertising Expense ($million) Sales Revenue ($million)
July 2 7
August 1 3
September 3 8
October 4 10

A. The owner wants to forecast sales on the basis of advertising expense. Which variable is the dependent variable? Which variable is the independent variable?

B. Determine the coefficient of correlation.

C. Interpret the strength of the correlation coefficient.

D. Determine the coefficient of determination. Interpret.

E. Determine the regression equation.

F. Interpret the values of a and b.

G. Estimate sales when $3 million is spend on advertising.

Attachments
Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of regression model for advertising expense. Formula for the calculation and Interpretations of the results are also included.

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.

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.

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

  • Regression analysis of annual sales based on advertising expense

    132567 Regression analysis of annual sales based on advertising expense Reliable Furniture is a family business that has been selling to retail customers in the Chicago area for many years.

  • Regression Analysis - Writing equation and interpretation

    It means that Advertisement Expense is a significant variable in determining the sales for the firm.

  • 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.

  • Multiple Regression Analysis on Store Profession

    For each store she gathered the following information Y = total sales last year (in $ thousands). X1 = number of competitors in the region. X2 = population of the region (in millions). X3 = advertising expense (in $ thousands).

  • Hagerty's Furniture Regression Analysis

    140843 Hagerty's Furniture Regression Analysis Hagerty's Furniture is a family business that has been selling to retail customers in the Chicago area for many years.

  • Regression Analysis

    372277 Regression analysis in laymen terms Suppose your employer buys you a copy of Excel and you decide to learn regression analysis.

  • Confidence Interval,Hypothesis Testing & Regression Analysis

    The solution provides step by step method for the calculation of confidence intervals, testing of hypothesis and multiple regression analysis. Formula for the calculation and Interpretations of the results are also included.

  • Significance Level for Bryne Store Competitors

    What are the estimated sales for the Bryne store, which has four competitors, regional population of 0.4 (400,000), and advertising expense of 30 ($30,000)? We need to know the value(code assigned ) of bryne store in order to find b.

  • Regression Analysis in Business Research

    Describe the significance of the results to the organization as a whole The regression analysis revealed that the money spend for advertising have a significant impact on the orders received for the MobileMICROS.

View More Related Solutions