8.a) Consider the data below for Alaska Airlines and for American West Airlines. Construct a bar graph which breaks down the data by airline and by city, and which shows, for each airline, the percentage of on-time flights at each city.
I've considered your statement. Now what?
8.a) Consider the data below for Alaska Airlines and for American West Airlines. Construct a bar graph which breaks down the data by airline and by city, and which shows, for each airline, the percentage of on-time flights at each city.
b) Consider the data below for Alaska Airlines and for American West Airlines. Construct a bar graph which has only two bars. One bar should represent the percentage of on-time flights flown by Alaska Airlines (with all data from all cities used to calculate the percentage). The other bar should represent the percentage of on-time flights flown by American West (with all data from all cities used to calculate the percentage).
Data for Alaska Airlines:
On Time-Delayed
Los Angeles 497-62
Phoenix 221-12
San Diego 212-20
San Francisco 503-102
Seattle 1841-305
Data for American West:
On Time-Delayed
Los Angeles 694-117
Phoenix 4840-415
San Diego 383-65
San Francisco 320-129
Seattle 201-61
To construct a bar graph that breaks down the data by airline and by city, and shows the percentage of on-time flights for each airline at each city, you will need to follow these steps:
1. Start by gathering the necessary data. You mentioned that the data is available for Alaska Airlines and American West Airlines. Make sure you have the data for both airlines and the on-time flight percentages for each city they operate in.
2. Organize the data in a table format with columns for the airlines, cities, and on-time flight percentages. Here's an example:
| Airline | City | On-Time Flights (%) |
|------------------|---------------|---------------------|
| Alaska Airlines | City A | XX% |
| Alaska Airlines | City B | XX% |
| American West Airlines | City A | XX% |
| American West Airlines | City B | XX% |
Replace "City A" and "City B" with the actual cities they operate in, and "XX%" with the corresponding on-time flight percentages.
3. Calculate the percentage of on-time flights for each city and airline combination. This can be done by dividing the number of on-time flights by the total number of flights and multiplying by 100. Round the result to the nearest whole number. For example, if Alaska Airlines had 80 on-time flights out of a total of 100 flights in City A, the calculation would be: (80/100) * 100 = 80%.
4. Once you have calculated the on-time flight percentages for each city and airline combination, you can proceed to create the bar graph. Use a spreadsheet software like Microsoft Excel or Google Sheets to make the task easier.
5. In the spreadsheet, enter the cities in the vertical axis (y-axis) and the airlines in the horizontal axis (x-axis).
6. Plot the on-time flight percentages as bars for each airline and city combination. Each bar should represent the on-time flight percentage for a particular city and airline.
7. Apply different colors or patterns to differentiate the bars for each airline. This will make it easier to interpret the graph.
8. Add a legend or labels to indicate which airline each color or pattern represents.
9. Finally, add a title to the graph that summarizes its content and makes it clear what information is being conveyed.
By following these steps, you should be able to create a bar graph that breaks down the data by airline and city, displaying the respective on-time flight percentages.