Can you help me walk through the Excel steps to answer this question? I think the analysis to be ran is regression but I am not sure.

Emily Smith decides to buy a fuel-efficient used car.Here are several vehicles she is considering, with the estimated cost to purchase and the age of the vehicle.

DATA:

Y X

Vehicle Estimated Cost Age

Honda Insight $7,562 9

Toyota Prius $12,648 4

Toyota Prius $12,722 6

Toyota Echo $6,437 9

Honda Civic Hybrid $15,807 7

Chevrolet Prizm $10,424 12

Mazda Protg $10,000 8

Toyota Corolla $13,530 10

Acura Integra $9,110 6

Scion xB $3,120 10

Scion xA $12,993 7

Mazda3 $2,279 9

Mini cooper $16,768 4

\f