1 2 Travel Expenses1 OBJECTIVES Determine and interpret
1 -2 Travel Expenses-1 OBJECTIVES Determine and interpret cumulative frequency. Determine and interpret relative cumulative frequency. Slide 1
1 -2 Travel Expenses-2 OBJECTIVES Model a situation using a spreadsheet. Determine and interpret percentiles. Slide 2
Key Terms • • cumulative frequency relative frequency spreadsheet cell relative cumulative frequency percentile rank Slide 3
What will it cost to get there? • What costs are involved in traveling? • How can you plan for and budget for these expenses? Slide 4
Example 1 How many of the trips listed in the Summer Travel table were less than 1000 miles? Slide 5
Example 1 How many of the trips listed in the Summer Travel table were less than 1000 miles? Slide 6
Example 2 The Flyt Travel website reported the following airfare booking expenses for the week of July 4 th. What proportion of the tickets sold had a cost greater than or equal to $400 and less than or equal to $499. 99? Slide 7
Example 3 Write the spreadsheet formula that would find the sum of the relative frequencies. Slide 8
Example 3 Write the spreadsheet formula that would find the sum of the relative frequencies. = C 2 + C 3 + … + C 11 Or =SUM(C 2: C 11) Slide 9
Example 4 Determine the percent of the Flyt Travel bookings that are below $600. Slide 10
Example 4 Extend the relative frequency table on page 16 to determine the percent of the Flyt Travel bookings that are below $600. Slide 11
Example 5 Most cities have some form of taxicab services for short-distance trips. Usually the cab fares are either a flat fee for a specified distance or a metered fee. The metered cabs often start with an initial fee and then charge a fixed rate per fraction of a mile driven. In many cities, wait time and number of stops often affect the fare as well. The website taxifarefinder. com offers a ranking of cities by the cost of a hypothetical taxi trip of a given duration and distance. Of the top 80 most expensive cities, these are the initial cab fees in ranked order: What is the percentile rank of a $3. 00 initial cab fee? Slide 12
Example 5 Slide 13
- Slides: 13