Need help with this
Check My Work (5 remaining) eBook Companies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011 Hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. The following data show the number of cars in service (1000s) and the annual revenue ($millions) for six smaller car rental companies (Auto Rental News website, August 7, 2012). Excel file: data14-09.xlsx Company Cars (1000s) Revenue ($millions) U-Save Auto Rental System, Inc. 11.5 118 Payless Car Rental System, Inc. 10.0 135 ACE Rent A Car 90 100 Rent-A-Wreck of America 5.5 37 Triangle Rent-A-Car 4.2 40 Affordable/Sensible 3.3 32 If required, enter negative values as negative numbers. a. Select a scatter diagram with the number of cars in service as the independent variable. 1. 160 140 120 100 Annual Revenue ($millions) 80 60 40 20 O 0 2 4 6 8 10 12 14 Cars in Service (1000s)Cars in Set-rice (1000.) EEEE I I 883 Annual Revenue (smilnmm) D 2 4 5 3 10 12 14 Cu: in Service (1000:) o EEEE SSE Alumnl Revenue (smim'm) o 2 4 a a JD 12 14 Cars in Set-rice (1000.) a 7 Select your answer 7 V I3. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables7 7 Select your answer , v c. Use the least squares method to deveiup the estimated regression equation (to 3 decimals). 5' = + z d. For every additional car placed in service, estimate how much annual revenue will change. Use estimated value rounded to 3 decimals. Select yuur answer - v by: e. Fox Rent A Car has 11.000 cars in service. Use the estimated regression equation developed in part (c) to predict annual revenue for Fox Rent A Car. Round your answer to nearest whole value