Purchase Solution

Simple Linear Regression -- Sales

Not what you're looking for?

Ask Custom Question

Simple Linear Regression -- Sales
"A recent study was conducted to determine the relation between advertising expenditures and sales of widgets for the first year of production.
"
You would like to determine the effect of your ad expenditures in predicting sales.
the following data was collected:
Ad Expenditures Sales 1. Produce a scatterplot with linear trendline
40,000 289,000
55,000 423,000
35,000 250,000
50,000 400,000
43,000 335,000
60,000 470,000
52,000 408,000
39,000 320,000
47,000 415,000
38,000 389,000

2. Produce the regression equation for the ad expenditures predicting sales.

x

3. What is the slope of the line? x

4. What is the estimated sales if the ad expenditures are $65,000? x

5. Interpret in words the R square value (coefficient of determination).

x

Purchase this Solution
Solution Summary

Simple Linear Regression is offered. The effects of ad expenditures in predicting sales are determined.

Solution provided by:
Sandhya Sharma, MSc
Education
  • BSc, Meerut University
  • MSc, Meerut University
  • MPhil, Institute of Advanced Studies
  • MSc, AIT
Recent Feedback
  • "Perfect, thank you so much!!! I will definitely request you in the future! You are amazing!"
  • "Thank you. "
  • "Thank you so much I have two more that I need your help with if your available."
  • "Thank you, I was wondering why you rejected me the first time."
  • "Thanks again."
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

View More Free Quizzes
Related BrainMass Solutions

  • Forecast using simple linear regression

    166156 Forecast using simple linear regression This problem has to be done in Excel. Prepare a forecast, using simple linear regression, for each quarter of the next year from the following past 2 years' quarterly sales information.

  • Simple and Multiple Regression

    Develop simple linear regression models for predicting sales as a function of the number of each type of ad. Compare these results to a multiple linear regression model using both independent variables.

  • Simple Exponential Smoothing

    A Linear Regression equation was obtained using the client's data. The Linear Regression equation was then used to forecast the sales for Year 2.

  • Statistics: Analysis of a Scatterplot

    Simple linear regression results are provided.

  • Simple regression analysis

    Example : We can use simple linear regression analysis techniques to identify the relationship between sales and advertisement cost. Here 'sales' is the dependent variables. We can expect a increase in sales due to advertisement.

  • Forecasting for WidgeCorp: Applied Managerial Decision-Making

    Please research about regression analysis, and provide detailed discussion about various types of regression including simple and multiple regression as well as linear and non-linear regression along with real world examples and at least three references

  • Correlation and Regression

    Simple linear regression Scatterplots First, let look at two simple linear regressions: (1) between newspaper ads and sales and (2) between radio/TV ads and sales. This will tell us if increasing spending on ads will increase sales.

  • Simple Linear Regression Model in Sales Data

    78865 Linear regression Sales date for two years are as follows. Data are aggregated with two months of sales in each period. (see chart in attached file) a. Plot the data b. Fit a simple linear regression model to the sales data. c.

  • Data Forecasting Using Simple Linear Regression Model

    The solution computes and forecasts using a simple linear regression model.

View More Related Solutions