Question

In: Statistics and Probability

Data from a small bookstore are shown in the accompanying table. The manager wants to predict...

Data from a small bookstore are shown in the accompanying table. The manager wants to predict Sales from Number of Sales People Working. Complete parts a through h below.

Number of ales peaople working sale (in $1000)
2 10
3 12
5 14
8 15
10 19
10 21
13 21
14 22
17 22
19 27
x(bar)= 10.1 y(bar)=18.3
SD(x)=5.74 SD(y)=5.33

A) find the slope etimate, b1. B) What does b1 mean, in thi context? C) Find the intercept, b0. D) what does b0 mean in the context Is it meaningful? E) Write the equation that predicts Sales from Number of People Working F) If 18 people were working, what sales do you predict? G) If sales were actually $25,000, what' the value of the residual? H) is this an overestimate or an underestimate?

Solutions

Expert Solution

Cov(x, y) = 29.522, correlation between x and y = rxy = 0.9636

A) So, from the data, the estimate of slope = b1 = rxy * SD(Y) /SD(x) = 0.9636*5.33/5.74 = 0.895

B) This means that if the manager wishes to increase(decrease) his number of sales people by 1 person, then his sales will expected to be increased(decreased) by $0.895*1000 = $895

C) The intercept = b0 = y(bar) - b1 * x(bar) = 18.3-0.895*10.1 = 9.26

D) This means if there is no sales people working in the shop, then his estimated sales will be $9.26*1000 = $926

Well, if there is no sales people working, then practically there should not be any sales. So, in that sense, it might not be meaningful.

E) Sales (in $1000) = 9.26 + 0.895 * Number of sales people working

F) As the sales value were reported as multiple of $1000, we should invoke x = 18 in the above equation, then, we get,

Sales (in $1000) = 9.26 + 0.895*18 = 25.37

So, the estimate sales = $25.37*1000 = $25,370

So, the residual = Actual - Estimated = $25,370 - $25,000 = $370

H) As the estimated sale is higher than the actual sale, it is an overestimate.


Related Solutions

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 103 employees for the day and bring in a total of $ 41,000. Sales = 7.873 + 0.946(Number of Salespeople Working) Number of Salespeople Working // Sales 2 // 9 3 // 12 7 // 14 9 // 14 10 //...
The data in the accompanying table is from a paper. Suppose that the data resulted from...
The data in the accompanying table is from a paper. Suppose that the data resulted from classifying each person in a random sample of 45 male students and each person in a random sample of 92 female students at a particular college according to their response to a question about whether they usually eat three meals a day or rarely eat three meals a day. Usually Eat 3 Meals a Day Rarely Eat 3 Meals a Day Male 25 20...
Sales data were collected from a small bookstore. The following is an equation for the regression...
Sales data were collected from a small bookstore. The following is an equation for the regression line of the data. Sales = 9.12 + 0.818(Number of Salespeople Working) The assumptions and conditions for regression are​ met, and from​ technology, it is known that SE(b1) = 0.0920 and Se =1.640. Number of Salespeople Working // Sales (in $1000s) 1 // 11 2 // 10 6 // 12 9 // 16 9 // 18 10 // 20 13 // 19 14 //...
The accompanying data were read from graphs that appeared in an article. The variables shown are...
The accompanying data were read from graphs that appeared in an article. The variables shown are the number of acres burned in forest fires in the western United States and timber sales. Year Number of Acres Burned (thousands) Timber Sales (billions of board feet) 1945 209 2.0 1950 249 3.9 1955 250 4.3 1960 375 6.9 1965 72 9.8 1970 440 11.0 1975 179 11.2 1980 242 10.2 1985 437 10.1 1990 397 11.2 1995 171 3.7 (a) Compute the...
Use the data in the accompanying table that summarizes results from a clinical trial of a...
Use the data in the accompanying table that summarizes results from a clinical trial of a drug. Let A = Drug Treatment, B = Placebo headache No Headache total Drug Treatment (A) 122 585 707 Placebo ( B) 28 672 700 Total 150 1257 1407 Answer the following: 1. Find the probability that patient under treatment p(A) 2. Find p(B) 3. Find the probability a patient has a headache 4. Find the probability a patient has a headache and he...
1. Here are the data from a small bookstore: Number of Salespeople Working Sales (in $1000s)...
1. Here are the data from a small bookstore: Number of Salespeople Working Sales (in $1000s) 2 10 3 11 7 13 9 14 10 18 10 20 12 20 15 22 16 22 20 26 a. Compute the correlation coefficient between number of salespeople and sales. Interpret the correlation coefficient. 6 b. Assuming the conditions for regression are met, find the estimated least-squares regression line and predicted sales on a day with 12 employees working. 7 c. If you...
pls answer ASAP. THANKS Q1. Here are the data from a small bookstore: Number of Salespeople...
pls answer ASAP. THANKS Q1. Here are the data from a small bookstore: Number of Salespeople Working Sales (in $1000s) 2 10 3 11 7 13 9 14 10 18 10 20 12 20 15 22 16 22 20 26 a. Compute the correlation coefficient between number of salespeople and sales. Interpret the correlation coefficient. b. Assuming the conditions for regression are met, find the estimated least-squares regression line and predicted sales on a day with 12 employees working. c....
Listed in the accompanying data table are birth weights​ (g) from a sample of 26 births....
Listed in the accompanying data table are birth weights​ (g) from a sample of 26 births. When applying the Wilcoxon​ rank-sum test, what is the sum of the ranks for the sample of birth weights of​ girls? Girl 3700 1000 2200 4300 3100 1900 2700 3400 2900 2500 4000 3400 2700 3200 Boy 3600 2700 3700 4200 3600 1800 3400 3800 2700 3300 3400 300 The sum of the ranks for the sample of birth weights of girls is? .
The accompanying data table show the percentage of tax returns filed electronically in a city from...
The accompanying data table show the percentage of tax returns filed electronically in a city from 2000 to 2009. Complete parts a through e below. Year   Percentage 2000   25 2001   33 2002   37 2003   38 2004   48 2005   50 2006   55 2007   59 2008   62 2009   64 a) Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with alpha= 0.1. ​b) Calculate the MAD for the forecast in part a. c) Forecast the...
Given the accompanying network diagram, with times shown in days. Use Table B1 and Table B2....
Given the accompanying network diagram, with times shown in days. Use Table B1 and Table B2. a. Determine the expected duration of the project. (Round intermediate calculations to 2 decimal places and final answer to 1 decimal place.) Expected Duration             b. Compute the probability that the project will take at least 18 days. (Round intermediate calculations to 2 decimal places and "Probability" values to 4 decimal places.) Probability             Chuck’s Custom Boats (CCB) builds luxury yachts to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT