# CarWeight (lbs) Miles per Gallon3,765Car 119Car 23,96417Car 33,47021Car 43,17522Car 52,58027Car 63,73018Car 72,60526Car 83,772173,310Car 920Car 102,99125Car 112,75226An engineer wanted to determine how the weight of a car affects gas mileage. The accompanying datarepresent the weights of various domestic cars and their gas mileages in the city for a certain model year.Suppose that we add Car 12 to the original data. Car 12 weighs 3 comma 3053,305 pounds and gets1919 miles per gallona) Compute the linear correlation coefficient with Car 12 included.The linear correlation coefficient with Car 12 included is r-?(Round to three decimal places as needed.)b) Recompute the linear correlation coefficient with Car 13 included. How did this new value affect yourresult?The linear correlation coefficient with Car 13 included is r-?t) Why does this observation not follow the pattern of the data?

Question
56 views
check_circle

Step 1

Enter the data as shown in excel

Step 2

Apply the following formula in excel and click enter

Step 3

The correlation after adding car 12 is...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in