Purchase Solution

Regression Model Applied to sales

Not what you're looking for?

Ask Custom Question

A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representatives travel per month and the amount of sales (in thousands of dollars) per month. Find the equation of the regression line for the given data. Predict the value of sales when the sales representative travel 8 miles. Predict the value of sales when tthe sales representative traveled 11 miles.

Miles Traveled x 2 3 10 7 8 15 3 1 11
Sales y 31 33 78 62 65 61 48 55 120

Purchase this Solution
Solution Summary

The solution determines the relationship between the number of miles the manager's sales representatives travel per month and the amount of sales per month. The regression line model was computed to predict values of either sales or distance traveled.

Solution Preview

PLEASE REFER TO THE ATTACHED FILE FOR A DETAILED COMPUTATION.

The equation of the regression line is:

Yc = a + bX
Yc = 37.9056 + 3.5284X

Find the equation of the regression line for ...

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Introduction to Finance

This quiz test introductory finance topics.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

View More Free Quizzes
Related BrainMass Solutions

  • Least squares regression line

    Regression analysis was applied between sales in ($1000) and advertising(in $100), and the following regression function was obtained: Y = 61 +4.1X Based on this regression line, if advertising is $10,000, the point estimate for sales (in dollars) is

  • Regression Analysis: Bikes

    354384 Applied Statistics for Mountain Bikes: Regression model, ANOVA table, t statistic Need the three attached problems completed.

  • Forecasting for WidgeCorp: Applied Managerial Decision-Making

    130006 Forecasting for WidgeCorp: Applied Managerial Decision-Making WidgeCorp is considering branching out into cold beverages. You have been asked to come up with a regression model to forecast monthly sales of cold beverages for the next year.

  • WidgeCorp

    263874 WidgeCorp: Regression model to forecast monthly sales of cold beverages WidgeCorp is considering branching out into cold beverages.

  • Regression analysis for sales and earnings

    Regression model, Coefficient of correlation, coefficient of determination, regression equation and a scatter diagram are determined based on the data.

  • Question on use of regression output in business

    In such a case, one of the highly correlated variables needs to be dropped from the model or transformation need to be applied to ensure that correlation is not high.

  • Hypothesis Testing, Regression Analysis and ANOVA

    A regression model relating x, number of sales persons at a branch office, to y, annual sales at the office ($1000s), has been developed. The computer output from a regression analysis of the data follows.

  • Applied Statistics for Health Care

    437729 Applied Statistics for Health Care What are some situations where regression would be more appropriate than ANOVA? What are a few day-to-day (or work) situations in which regression is used (consciously or not)?

  • Sales of product influenced by salesperson's characteristics

    DESCRIPTION If the Sales of a product are influenced by the following factors, then we have to formulate a Multiple Regression Model using Sales as dependent variable and given five factors as the independent variables.

  • Forecasting using Excel

    Hence the estimated model is significant in predicting the sales. Since the model is able to explain only 18.8% of the variability in Sales, we cannot conclude that it is a good model to predict the sales.

View More Related Solutions