We are interested in exploring the relationship between the weight of a vehicle and its fuel efficiency (gasoline mileage). The data in the table show the weights, in pounds, and fuel efficiency, measured in miles per gallon, for a sample of 12 vehicles.
Find the equation of the best fit line.
ŷ = _______ x + ________
Weight | Fuel Efficiency |
---|---|
2695 | 25 |
2510 | 26 |
2680 | 29 |
2770 | 38 |
3000 | 23 |
3410 | 24 |
3640 | 20 |
3700 | 25 |
3880 | 21 |
3900 | 21 |
4060 | 20 |
4710 | 16 |
We can use here Excel for regression equation
Step 1) Enter data in Excel .
Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok
ŷ = -0.0061 x + 44.7242
Get Answers For Free
Most questions answered within 1 hours.