Question

1. Suppose a manager wants to predict Sales from Number of Sales people working. Sales (in...

1. Suppose a manager wants to predict Sales from Number of Sales people working.

Sales (in 1000)

Number of Sales People Working

10

11

13

14

18

20

20

22

22

26

2

3

7

9

10

10

12

15

16

20

a) Is this simple or multiple linear regression? Explain. Identify the independent and dependent variable(s).

b) State the least squares regression line for this data.

c) Interpret the intercept and slope in the regression model.

d) If 18 people are working, what Sales do you predict?

e) By looking at your answer in part (d) above, what is the value of the residual, if sales are actually 25,000? Does the predicted value over-estimates or underestimates the sales? Explain.

Homework Answers

Answer #1

a. Independent Variable: Number of Sales People Working

Dependent variable: Sales (in 1000)

It is simple linear regression.

b.

The regression equation is
Sales (in 1000) = 8.101 + 0.91341 Number of Sales People Working

c.

When Number of Sales people working=0, even then Sales are 8101. When we increase 1 unit of number of sales people working then sales are increased by 913.

d. Predicted Sale=(8.101 + 0.91341*18)*1000=24542.38

e. Residual=25000-24542.38=457.62

The predicted value underestimates the sales.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The accompanying data show the number of people working and the sales for a small bookstore....
The accompanying data show the number of people working and the sales for a small bookstore. The regression line is given below. The bookstore decides to have a gala event in an attempt to drum up business. They hire 98 employees for the day and bring in a total of $40,000. Complete parts a through d below. Sales=8.431+0.879 Number of Salespeople Working Full data set    Number of Salespeople Working Sales (in $1000's) 2 11 3 10 7 14 9...
A study gathers data on the outside temperature during the winter, in degrees Fahrenheit, and the...
A study gathers data on the outside temperature during the winter, in degrees Fahrenheit, and the amount of natural gas a household consumes, in cubic feet per day. Let the temperature be the explanatory variable and gas consumption the response variable. Assume that the relationship between these two variables is linear. The least-squares regression line for predicting gas consumption from the outside temperature is: Consumption = 1360 - 20*Temperature In the equation, gas consumption is the response (dependent or predicted)...
Zenith Computers, Texas would like to predict weekly Internet sales based on the number of orders....
Zenith Computers, Texas would like to predict weekly Internet sales based on the number of orders. Data (over 15 weeks), relating the sales volume (in thousands of dollars) to the number of orders were available. Regression analysis was performed using Excel. Output related to the regression is given below. Week Orders Sales ($1000) 1 265 15.3 2 150 18.4 3 131 11.6 . . . . . . SUMMARY OUTPUT Regression Statistics Multiple R 0.795 R Square 0.632 Adjusted R...
A least squares regression line to predict a student’s Stat145 test score (from 0-to-100) from the...
A least squares regression line to predict a student’s Stat145 test score (from 0-to-100) from the number of hours studied was determined from a class of 55 Stat145 students: ̂ = 46.2 + 2.71x. One student in the class studied for 16 hours and scored 87 on the exam. (a) (5 pts.) What is the predicted value of this student’s Stat145 exam score? (b) (5 pts.) What is the residual for this student? (c) (5 pts.) Explain what the slope...
The number of cars sold in a day at a particular dealership can be predicted from...
The number of cars sold in a day at a particular dealership can be predicted from the number of sales people working by using the following regression equation: y¯=2.198+0.521x Interpret the slope of this equation.
Number of Police Officers (X)    Number of Crimes (Y) 0    10 20    10...
Number of Police Officers (X)    Number of Crimes (Y) 0    10 20    10    30    40 a. Calculate the correlation coefficient and the covariance b. Calculate the regression coefficient of the slope. c. State the regression equation. d. Interpret the meaning of the intercept and slopes in this equation. Be sure to explain using units. e. Predict the number of crimes when the number of police officers is 7.
1. The following data have been observed on the dependent variable Y and on an explanatory...
1. The following data have been observed on the dependent variable Y and on an explanatory variable X: yi 22 38 16 39 55 xi 10 35 20 30 20 (a) Calculate the ordinary least squares (OLS) estimates of the intercept and slope parameters. (b) Calculate the sample variance of both variables (S²x and S²y) and the sample correlation between X and Y . Explain what the calculated value of the correlation means.
Colleges use SAT scores to predict how students will perform at the college level. Suppose the...
Colleges use SAT scores to predict how students will perform at the college level. Suppose the entering freshmen at a certain college have mean SAT Scores of 1200, with a standard deviation of 113. In the first semester these students attained a mean GPA of 2.57, with a standard deviation of 0.46. A scatterplot showed the association to be reasonably linear, and the correlation between SAT score and GPA was 0.39. a) Write the equation of the regression line. b)...
Predict a student’s GPA (y) based upon the number of hours studied per week (x). Hours/week...
Predict a student’s GPA (y) based upon the number of hours studied per week (x). Hours/week GPA 5 2.5 10 3.1 12 3.3 20 3.8 15 3.7 12 3.5 If you used the least-squares regression line to predict the GPA of a student who studied 40 hours per week that would be: a) residual b) interpolation c) extrapolation d) r2
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number...
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number of grams of protein each ate per day was related to diastolic blood pressure.   The resulting regression formula will be used by medical personnel to predict blood pressure in a weight loss clinic in downtown Pittsburgh. Subject Grams of protein Diastolic BP 1 4 73 2 6.5 79 3 5 83 4 5.5 82 5 8 84 6 10 92 7 9 88 8...