Excel File Edit View Insert Format Tools Window Help O M C $ 2 Q g Fri Apr 1 5:11 PM AutoSave OFF n A E ? C ... 3 landscape (1) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman v 10 AA = ab Wrap Text v General Insert v EX AP- O. X Delete v Paste E Merge & Center v $ ~ % 9 508 28 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data A1 fx B C D E F G H I J K L M N 0 P Q R S T U V Home Value ($1000) Landscape Expenditures ($1000) 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 437 12.1 464 14 635 17.9 356 13.9 19 20 21 26 34 35 36 37 38 39 40 41 Data + Ready - + 100% A ? W XChrome File Edit View History Bookmarks Profiles Tab Window Help O M C $ 2 Q g Fri Apr 1 5:11 PM ... To-Do TODA X Course Hero X U HW 4 X MindTap - Cc X [Solved] The X Course Hero X Course Hero X G The America X C David's Land x + C ng.cengage.com/staticb/ui/evo/index.html?deploymentld=5996522222582380391258745959&eISBN=9780357131596&snapshotld... " * & G mos MAID YouTube M Gmail G= News x Translate U Dashboard | Home - MyUI N Notion - The all-i... O Your Sets | Quizlet G Google Drive: Fre... I Office of the Regi... Mail - Schwan, Da... Danielle v CENGAGE | MINDTAP Q Search this course My Home HW 4 X 1. Courses Hint(s) Check My Work (1 remaining) 2 Catalog and Study Tools 3 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 Un predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Click on the datafile logo to reference Rental Options 4. O the data. 5. College Success Tips DATA file Career Success Tips If required, enter negative values as negative numbers. a. Select a scatter diagram with home value as the independent variable. A- RECOMMENDED FOR YOU A. [Landscape Expenditures ($1000) 20 Communicating with Your Instructor 15 ? Help Give Feedback N landscape (1).xIsx landscape.xIsx P 11 Contracts Pa....pptx Show All APR 1 A ?Chrome File Edit View History Bookmarks Profiles Tab Window Help O M C $ 2 Q g Fri Apr 1 5:11 PM ... To-Do TODA X Course Hero X U HW 4 X MindTap - Cc X [Solved] The X Course Hero X Course Hero X G The America X C David's Land x + C ng.cengage.com/staticb/ui/evo/index.html?deploymentld=5996522222582380391258745959&eISBN=9780357131596&snapshotld... " * & G mos MAID YouTube M Gmail G= News x Translate U Dashboard | Home - MyUI N Notion - The all-i... O Your Sets | Quizlet G Google Drive: Fre... I Office of the Regi... o Mail - Schwan, Da... Danielle v CENGAGE | MINDTAP Q Search this course My Home HW 4 X 4YV DYv Courses B. [Landscape Expenditures ($1000) Catalog and Study Tools Un Rental Options 20 College Success Tips Career Success Tips 15 A- RECOMMENDED FOR YOU 10 5 Communicating with Your Instructor Home Value ($1000) 200 400 600 800 ? Help C. [Landscape Expenditures ($1000 ) Give Feedback N 20 landscape (1).xIsx landscape.xIsx P 11 Contracts Pa....pptx APR 1 4 ?Chrome File Edit View History Bookmarks Profiles Tab Window Help O M C $ 2 Q g Fri Apr 1 5:12 PM ... To-Do TODA X Course Hero X U HW 4 X MindTap - Cc X [Solved] The X Course Hero X Course Hero X G The America X C David's Land x + C ng.cengage.com/staticb/ui/evo/index.html?deploymentld=5996522222582380391258745959&eISBN=9780357131596&snapshotld... " * & G mos MAID YouTube M Gmail G= News x Translate U Dashboard | Home - MyUI N Notion - The all-i... O Your Sets | Quizlet G Google Drive: Fre... I Office of the Regi... Mail - Schwan, Da... Danielle v CENGAGE | MINDTAP Q Search this course My Home HW 4 X Courses C. [Landscape Expenditures ($1000) Catalog and Study Tools Un 20 Rental Options College Success Tips 15 Career Success Tips A- RECOMMENDED FOR YOU 10 15 Communicating with Your Instructor Home Value ($1000) 200 400 600 800 - Select your answer - v ? Help b. What does the scatter plot developed in part (a) indicate about the relationship between the two variables? Give Feedback The scatter diagram indicates a - Select your answer - | linear relationship between the two variables. N c. Use the least squares method to develop the estimated regression equation (to 5 decimals). y = ac + d. For every additional $1000 in home value, estimate how much additional will be spent on landscaping (to 2 decimals). landscape (1).xIsx landscape.xIsx P 11 Contracts Pa....pptx APR 1 NO 4 INChrome File Edit View History Bookmarks Profiles Tab Window Help O M C $ 2 Q g Fri Apr 1 5:12 PM ... To-Do TODA X Course Hero X U HW 4 X MindTap - Cc X [Solved] The X Course Hero X Course Hero X G The America X C David's Land x + C ng.cengage.com/staticb/ui/evo/index.html? deploymentld=5996522222582380391258745959&eISBN=9780357131596&snapshotld... " * & G mos MAID YouTube M Gmail G= News x Translate U Dashboard | Home - MyUI N Notion - The all-i... O Your Sets | Quizlet G Google Drive: Fre... I Office of the Regi... Mail - Schwan, Da... Danielle v CENGAGE | MINDTAP Q Search this course My Home HW 4 X Courses Home Value ($1000) Catalog and Study Tools 200 400 600 800 Un Rental Options - Select your answer - v College Success Tips b. What does the scatter plot developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates a - Select your answer - | linear relationship between the two variables. Career Success Tips c. Use the least squares method to develop the estimated regression equation (to 5 decimals). A- RECOMMENDED FOR YOU y = a + d. For every additional $1000 in home value, estimate how much additional will be spent on landscaping (to 2 decimals). OH $ e. Use the equation estimated in part (c) to predict the landscaping expenditures for a home valued at $575,000 (to the nearest whole number). $ Communicating with Your Instructor Hint(s) Check My Work (1 remaining) ? Help O Icon Key Give Feedback Exercise 14.09 (Least Square Method) Question 3 of 5 Save Submit Assignmen ..... landscape (1).xIsx landscape.xIsx P 11 Contracts Pa....pptx APR 1 4 W O