Question: Spring Break is coming and its time to make your plans. Below (in question 4) is a list of possible destinations for your trip. Give
Spring Break is coming and its time to make your plans. Below (in question 4) is a list of possible destinations for your trip. Give the following information to assist in planning your trip and finding the information needed for this project.
1. You are leaving from: John F. Kennedy International Airport
2. Date of departure: February 16, 2020
3. Date of return: February 23, 2020
You are to use the Internet to search for the lowest airfares from your town to the destination on the given dates and find the distance from your airport to that city.
4. Complete the following table of information for your Spring Break adventure. The cost is for one person on a roundtrip ticket. A maximum of two stops in route is allowed, for both directions of the trip.
| Destination | Distance | Airline | Departing flight number | Roundtrip cost |
| Miami | 2,208 mi | American Airlines | 2452 | $721.60 |
| San Diego | 4,852 mi | JetBlue | 89 | $492.87 |
| San Juan | 3,242 mi | Delta | 3121 | $634.51 |
| Los Angeles | 4,872 mi | JetBlue | 355 | $315.53 |
| Chicago | 1,440 mi | Delta | 4897 | $196.60 |
| Seattle | 4,794 mi | JetBlue | 263 | $254.68 |
| Salt Lake City | 3,940 mi | JetBlue | 71 | $678.36 |
| Boston | 370 mi | JetBlue | 1418 | $136.59 |
| Honolulu | 9,922 mi | Hawaiian Airlines | 51 | $915.20 |
| Denver | 3,242 mi | JetBlue | 97 | $466.35 |
5. Make a scatter plot of the distance versus cost. Use the distance as the independent variable on the horizontal axis. Make appropriate scales for the axes.
6. Look at the scatterplot above to answer the following: How is the cost of the trip associated with the distance of the trip?
7. Use a straight edge to approximate a line of best fit to the data. Do this by hand. You will be asked to make the line in Excel in a later question. Approximate the slope of the line (you can take two points on the line and calculate change in y/ change in x) and the y intercept (where you cross y-axis). Write the equation of your estimated line, Y = (slope)X + intercept
8. On a scale of 0 to 1, how good does the line fit the data? 0 = no fit and 1 = a perfect fit. Use any decimal value between 0 and 1.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
