Question

In: Statistics and Probability

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 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 down and right from (198, 21.9) to (800, 6.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 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 "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.

(b)

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

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 a negative linear 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


Related Solutions

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...
A company has recorded data on the daily demand for its product (y in thousands of...
A company has recorded data on the daily demand for its product (y in thousands of units) and the unit price (x in hundreds of dollars). A sample of 15 days demand and associated prices resulted in the following data. x75 x2 437 y180 y2 2266 xy844 a. Using the above information, develop the least-squares estimated regression line and write the equation. b. Compute the coefficient of determination. c. Perform an F test and determine whether or not there is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT