The parking rates for a parking garage are shown. The garage does not allow any overnight parking and it rounds the time up

An insurance company crashed four cars in succession at 5 miles per hour. The cost of repair for each of the crashes was $421,$465,$412,$218. Compute the range of data

Use excel to do all calculations. Please show all work.

Certain car manufacturers install a gauge that tells the driver how many miles they can drive until they will run out of gas. A study was conducted to test the accuracy of these gauges. Each driver was assigned a certain gauge reading until empty to watch for. When their car announced it had that many miles remaining until empty, they began to measure their distance traveled. After they ran out of gas, they reported the distance they were able to drive (in miles) as well as the gauge reading they were assigned (in miles). Here is computer output showing the regression analysis:   Identify and interpret the slope of the regression line used for predicting the actual distance that can be driven based on the gauge reading. (A) Slope = 1.1889. The predicted distance the drivers were able to drive increases by 1.1889 miles for each additional mile reported by the gauge. (B) Slope = 0.0457. The predicted distance the drivers were able to drive increases by 0.0457 miles for each additional…