Charlie Ticket Bus $1.50 $2.00 Subway $2.00 $2.50 Table 6.21. MBTA fare increases [R187] a. What are the relative and absolute changes in the Charlie Card bus fare? You don't have to do this in your head, without a calculator, but you should be able to. b. Create a spreadsheet for these data, with eight rows (one for each of the eight categories) and three columns, for the category name, the existing fare and the proposed fare. Create a properly labeled bar graph to display the data. c. Label the next two columns appropriately to hold the relative and absolute changes. Fill those columns with Excel formulas to compute the correct values. Do not compute the values elsewhere and enter them in the spreadsheet as numbers. [See the back of the book for a hint.]
Charlie Ticket Bus $1.50 $2.00 Subway $2.00 $2.50 Table 6.21. MBTA fare increases [R187] a. What are the relative and absolute changes in the Charlie Card bus fare? You don't have to do this in your head, without a calculator, but you should be able to. b. Create a spreadsheet for these data, with eight rows (one for each of the eight categories) and three columns, for the category name, the existing fare and the proposed fare. Create a properly labeled bar graph to display the data. c. Label the next two columns appropriately to hold the relative and absolute changes. Fill those columns with Excel formulas to compute the correct values. Do not compute the values elsewhere and enter them in the spreadsheet as numbers. [See the back of the book for a hint.]
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
Question
![### Table 6.21. MBTA Fare Increases [R187]
| Charlie Ticket | Existing Fare | Proposed Fare |
|----------------|---------------|---------------|
| Bus | $1.50 | $2.00 |
| Subway | $2.00 | $2.50 |
---
### Questions:
**a.** What are the relative and absolute changes in the Charlie Card bus fare? You don’t have to do this in your head, without a calculator, but you should be able to.
**b.** Create a spreadsheet for these data, with eight rows (one for each of the eight categories) and three columns, for the category name, the existing fare and the proposed fare. Create a properly labeled bar graph to display the data.
**c.** Label the next two columns appropriately to hold the relative and absolute changes. Fill those columns with Excel formulas to compute the correct values. Do not compute the values elsewhere and enter them in the spreadsheet as numbers. [See the back of the book for a hint.]
**d.** Imagine that you are addressing a public meeting about these fare increases. How would you argue that an unfair burden is being placed on people who pay using a Charlie Ticket? How would you argue that senior citizens are most hard hit?
**e.** Find the mean of the relative percent increases. Explain why the answer is not the 23 percent quoted in the headline.
**f.** What extra information would you need to check that the correct mean is 23 percent?
### Detailed Explanation of the Table:
The table labeled "Table 6.21. MBTA Fare Increases" presents fare prices for two categories of transportation: Bus and Subway, both with their existing and proposed fare values.
- For the Bus, the existing fare is $1.50, proposed to increase to $2.00.
- For the Subway, the existing fare is $2.00, proposed to increase to $2.50.
These details will be used to answer questions related to calculating relative and absolute changes in fares, creating spreadsheets, and discussing the impacts of these fare increases in a hypothetical public meeting. The questions provide a comprehensive approach to understanding fare changes, including mathematical calculations (both relative and absolute changes), skills in creating visual data representations (bar graphs), and critical thinking about fare policy's societal impact.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F55458ab0-3660-41bb-9c6c-5d0ceb887617%2Fedf678cf-ac8f-4f57-a76b-6d263ec5574e%2Ffuxc41_processed.jpeg&w=3840&q=75)
Transcribed Image Text:### Table 6.21. MBTA Fare Increases [R187]
| Charlie Ticket | Existing Fare | Proposed Fare |
|----------------|---------------|---------------|
| Bus | $1.50 | $2.00 |
| Subway | $2.00 | $2.50 |
---
### Questions:
**a.** What are the relative and absolute changes in the Charlie Card bus fare? You don’t have to do this in your head, without a calculator, but you should be able to.
**b.** Create a spreadsheet for these data, with eight rows (one for each of the eight categories) and three columns, for the category name, the existing fare and the proposed fare. Create a properly labeled bar graph to display the data.
**c.** Label the next two columns appropriately to hold the relative and absolute changes. Fill those columns with Excel formulas to compute the correct values. Do not compute the values elsewhere and enter them in the spreadsheet as numbers. [See the back of the book for a hint.]
**d.** Imagine that you are addressing a public meeting about these fare increases. How would you argue that an unfair burden is being placed on people who pay using a Charlie Ticket? How would you argue that senior citizens are most hard hit?
**e.** Find the mean of the relative percent increases. Explain why the answer is not the 23 percent quoted in the headline.
**f.** What extra information would you need to check that the correct mean is 23 percent?
### Detailed Explanation of the Table:
The table labeled "Table 6.21. MBTA Fare Increases" presents fare prices for two categories of transportation: Bus and Subway, both with their existing and proposed fare values.
- For the Bus, the existing fare is $1.50, proposed to increase to $2.00.
- For the Subway, the existing fare is $2.00, proposed to increase to $2.50.
These details will be used to answer questions related to calculating relative and absolute changes in fares, creating spreadsheets, and discussing the impacts of these fare increases in a hypothetical public meeting. The questions provide a comprehensive approach to understanding fare changes, including mathematical calculations (both relative and absolute changes), skills in creating visual data representations (bar graphs), and critical thinking about fare policy's societal impact.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 7 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON