PLEASE SOLVE AND ANSWER Use MS Excel to make the scatterplots and to verify the determined least-squares line using its
Posted: Mon May 16, 2022 8:07 am
PLEASE SOLVE AND ANSWER
Use MS Excel to make the scatterplots and to verify the determined least-squares line using its Trendline function.
5.39 • The article "California State Parks Closure List Due Soon" (The Sacramento Bee, August 30, 2009) gave the following data on y = number of employees in fiscal year 2007–2008 and x = total size of parks (in acres) for the 20 state park districts in California: Number of Employees, y Total Park Size, x 95 39,334 95 324 102 17,315 69 8,244 67 620,231 43,501 77 81 8,625 116 31,572 51 14,276 21,094 36 96 103,289 71 130,023
Total Park Size, x Number of Employees, y 76 16,068 112 3,286 43 24,089 87 6,309 131 14,502 138 62,595 80 23,666 52 35,833 a. Construct a scatterplot of the data. b. Find the equation of the least-squares line. c. Do you think the least-squares line gives accurate predictions? Explain. d. Delete the observation with the largest x value from the data set and recalculate the equation of the least-squares line. Does this observation greatly affect the equation of the line?
Use MS Excel to make the scatterplots and to verify the determined least-squares line using its Trendline function.
- Please Solve And Answer Use Ms Excel To Make The Scatterplots And To Verify The Determined Least Squares Line Using Its 1 (33.89 KiB) Viewed 46 times
- Please Solve And Answer Use Ms Excel To Make The Scatterplots And To Verify The Determined Least Squares Line Using Its 2 (41.98 KiB) Viewed 46 times
Total Park Size, x Number of Employees, y 76 16,068 112 3,286 43 24,089 87 6,309 131 14,502 138 62,595 80 23,666 52 35,833 a. Construct a scatterplot of the data. b. Find the equation of the least-squares line. c. Do you think the least-squares line gives accurate predictions? Explain. d. Delete the observation with the largest x value from the data set and recalculate the equation of the least-squares line. Does this observation greatly affect the equation of the line?