Question

In: Operations Management

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands...

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape.

Home
Value
($1,000)
Landscaping
Expenditures
($1,000)
242 8.1
321 10.8
198 12.2
340 16.2
300 15.6
400 18.9
800 23.5
200 9.5
521 17.5
547 22.0
437 12.1
464 13.5
635 17.9
356 13.9

(a)

Develop a scatter diagram with home value as the independent variable.

A scatter diagram has a horizontal axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25 and a vertical axis labeled "Home Value ($1,000)" with values from 0 to 900. The scatter diagram has 14 points. A pattern goes up and right from (8.1, 198) to (23.5, 800). The points are scattered moderately from the pattern.

A scatter diagram has a horizontal axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25 and a vertical axis labeled "Home Value ($1,000)" with values from 0 to 900. The scatter diagram has 14 points. A pattern goes down and right from (6.5, 800) to (21.9, 198). The points are scattered moderately from the pattern.

A scatter diagram has a horizontal axis labeled "Home Value ($1,000)" with values from 0 to 900 and a vertical axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25. The scatter diagram has 14 points. A pattern goes up and right from (198, 8.1) to (800, 23.5). The points are scattered moderately from the pattern.

A scatter diagram has a horizontal axis labeled "Home Value ($1,000)" with values from 0 to 900 and a vertical axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25. The scatter diagram has 14 points. A pattern goes down and right from (198, 21.9) to (800, 6.5). The points are scattered moderately from the pattern.


(b)

What does the scatter plot developed in part (a) indicate about the relationship between the two variables?

The scatter diagram indicates a negative linear relationship between home value and landscaping expenditures.The scatter diagram indicates a positive linear relationship between home value and landscaping expenditures.    The scatter diagram indicates a nonlinear relationship between home value and landscaping expenditures.The scatter diagram indicates no apparent relationship between home value and landscaping expenditures.

(c)

Use the least squares method to develop the estimated regression equation. (Let x = home value (in thousands of $), and let y = landscaping expenditures (in thousands of $). Round your numerical values to five decimal places.)

ŷ =

  

(d)

For every additional $1,000 in home value, estimate how much additional will be spent (in $) on landscaping. (Round your answer to the nearest cent.)

$  

(e)

Use the equation estimated in part (c) to predict the landscaping expenditures (in $) for a home valued at $575,000. (Round your answer to the nearest dollar.)

$

Solutions

Expert Solution

A.scatter diagram with home value as the independent variable.

Scatter diagram has a horizontal axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25 and a vertical axis labeled "Home Value ($1,000)" with values from 0 to 900. The scatter diagram has 14 points. A pattern goes up and right from (8.1, 198) to (23.5, 800). The points are scattered moderately from the pattern.

A scatter diagram has a horizontal axis labeled "Home Value ($1,000)" with values from 0 to 900 and a vertical axis labeled "Landscaping Expenditures ($1,000)" with values from 0 to 25. The scatter diagram has 14 points. A pattern goes up and right from (198, 8.1) to (800, 23.5). The points are scattered moderately from the pattern.

B. What does the scatter plot developed in part (a) indicate about the relationship between the two variables?

The scatter diagram indicates no apparent relationship between home value and landscaping expenditures.

C.

Estimated regression equation ŷ can be determined as below

HOME VALUE X LANDSCAPING EXPENDITURE Y X-X0 Y-Y0 (X-X0)2 (Y-Y0)2 (X-X0)*(Y-Y0)
242 8.1 -169.5 -7.021429 28730.25 49.30046 1190.132143
321 10.8 -90.5 -4.321429 8190.25 18.67474 391.0892857
198 12.2 -213.5 -2.921429 45582.25 8.534745 623.725
340 16.2 -71.5 1.078571 5112.25 1.163316 -77.11785714
300 15.6 -111.5 0.478571 12432.25 0.229031 -53.36071429
400 18.9 -11.5 3.778571 132.25 14.2776 -43.45357143
800 23.5 388.5 8.378571 150932.3 70.20046 3255.075
200 9.5 -211.5 -5.621429 44732.25 31.60046 1188.932143
521 17.5 109.5 2.378571 11990.25 5.657602 260.4535714
547 22 135.5 6.878571 18360.25 47.31474 932.0464286
437 12.1 25.5 -3.021429 650.25 9.129031 -77.04642857
464 13.5 52.5 -1.621429 2756.25 2.629031 -85.125
635 17.9 223.5 2.778571 49952.25 7.720459 621.0107143
356 13.9 -55.5 -1.221429 3080.25 1.491888 67.78928571
Mean 411.5 15.12143 SUM 382633.5 267.9236 8194.15

ŷ= b0+b1 X

b1=

b1= 8194.15/382633.5

b1=0.02142

Consider ŷ =15.12143, x = 411.5

Subsitute in ŷ= b0+b1 X

Now 15.12143= b0 + 0.02142 X 411.5

b0= 6.3071

ŷ= 6.3071+0.02142 X

D. For every additional $1,000 in home value, the landscapping expenditure will be-

ŷ= 6.3071+0.02142 X

=6.3071+0.02142*1000

=27.7271

=$27.73 (Rounded up to nearest cent)

E. For a home valued at $575,000

Landscapping Expenditure will be given by,

ŷ= 6.3071+0.02142 X

=6.3071+0.02142*575000

=12322.8071

=$12323 rounded up to nearest dollar


Related Solutions

David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands...
David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Home Value ($1,000) Landscaping Expenditures ($1,000) 242 8.1 321 10.8 198 12.2 340 16.2 300 15.6 400 18.9 800 23.5 200 9.5 521 17.5 547 22.0 437 12.1 464 13.5 635 17.9 356 13.9...
Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow....
Data on advertising expenditures and revenue (in thousands of dollars) for the Four Seasons Restaurant follow. Advertising Expenditures Revenue 1 20 2 33 4 44 6 40 10 52 14 53 20 54 a. Let X equal advertising expenditures and Y equal revenue. Complete the estimated regression equation below (to 2 decimals). y =( )+( )x b. Compute the following (to 1 decimal). SSE ( ) SST ( ) SSR ( )MSR ( ) MSE ( ) c. Test whether...
The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also...
The following data gives the monthly sales (in thousands of dollars) for different advertising expenditures (also in thousands of dollars) and sales commission percentages. Sales                    245      138      352      322      228      275      560      366 Advertising          16.5     18.0     22.3     18.4     19.0     19.5     30.0     18.6 Commission        10.5     2.0       4.0       3.5       4.5       1.8       9.0       8.5 What amount of sales would...
A survey collected data on annual credit card charges in seven different categories of expenditures:
  A survey collected data on annual credit card charges in seven different categories of expenditures: transportation, groceries, dining out, household expenses, home furnishings, apparel, and entertainment. Using data from a sample of 42 credit card accounts, assume that each account was used to identify the annual credit card charges for groceries (population 1) and the annual credit card charges for dining out (population 2). Using the difference data, with population 1 − population 2, the sample mean difference was...
Suppose for a paper in Professor Hughes' class, you collected data on campaign expenditures by incumbents...
Suppose for a paper in Professor Hughes' class, you collected data on campaign expenditures by incumbents and challengers in state legislative elections where the race was competitive (i.e., the election winner received less than 60% of the vote). The mean of campaign expenditures (measured in $1,000s) by the 51 challengers in these races is 156.0 with a standard deviation of 24.0, while the mean of campaign expenditures by the 51 incumbents is 162.5 with a standard deviation of 18.0. Treating...
Science MajorsA bank has collected data on the opening balances of new home loans issued in...
Science MajorsA bank has collected data on the opening balances of new home loans issued in the final quarter of 2018. The dataset of 200 observations is contained in the file: Home Loans (THA 1).xlsx. Based on the data, answer the following questions. Using the Pivot Tablein Excel, construct a frequency distribution tableof Opening Balance and a histogramdisplaying the table. Suggested class intervals: 0 – 200,000; 200,000 – 400,000, etc. Obs Home Loan, Open. Bal. 1 544,723 2 686,461 3...
Science MajorsA bank has collected data on the opening balances of new home loans issued in...
Science MajorsA bank has collected data on the opening balances of new home loans issued in the final quarter of 2018. The dataset of 200 observations is contained in the file: Home Loans (THA 1).xlsx. Based on the data, answer the following questions. An observation is a suspected outlier if it is more than 1.5 times the inter-quartile range (1.5 ´IQR)below Q1 or above Q3. Calculate the lower and upper ‘fences’ for this data and report the total number outliers...
Science MajorsA bank has collected data on the opening balances of new home loans issued in...
Science MajorsA bank has collected data on the opening balances of new home loans issued in the final quarter of 2018. The dataset of 200 observations is contained in the file: Home Loans (THA 1).xlsx. Based on the data, answer the following questions. By comparing Q2 and the sample mean comment on the skewness of the data. Explain your answer briefly. Obs Home Loan, Open. Bal. 1 544,723 2 686,461 3 422,582 4 373,228 5 369,600 6 353,011 7 259,339...
Chase Bank account division has collected data on the age of credit accounts. The data collected...
Chase Bank account division has collected data on the age of credit accounts. The data collected indicate that the age of the accounts follows a normal distribution with mean 18 years and standard deviation 6 years. a. What proportion of the accounts are between 20 and 32 years old? b. What is the number of years in which 75% of all accounts are above?
Creative Landscaping wishes to increase their market share. They are looking into exhibiting at the Home...
Creative Landscaping wishes to increase their market share. They are looking into exhibiting at the Home and Garden Show in May. The cost of exhibit space is $25,000. Creative Landscaping will use leftover brochures from previous trade shows. They will not incur any additional labor expenses to participate in the exhibit. They will, however, have transportation costs of $750 to transport goods to and from the exhibit. Resources indicate they can expect a $60,000 increase in revenues next year as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT