1.a. Pick 10 cities that you would like to fly to. Look up the distance in miles between yourhome airport and each city you want to visit along with the cost of a flight. Use the same day andas close to the same time as you can for each flight. Enter this data in Excel using distance as thex value and price as the y value.

b. In Excel find the scatterplot, line of best, and r2value.

c. Run a hypothesis test to see if distance does a good job predicting price. Include the null andalternative hypothesis, p-value, and results.

d. Use the line of best fit to predict the distance of a $200 flight.