1. (6.12.6) 4 pts-Cash-strapped T proposes 23 percent fare increase. On March 28, 2012, the Massachusetts Bay Transportation Authority (MBTA) provided the fare data in Table 6.21. Riders can pay with a stored-value Charlie Card or with a Charlie Ticket bought on the spot. Fare Category Current Proposed Charlie Card Bus $1.25 $1.50 Subway $1.70 $2.00 Senior Bus $0.40 $0.75 Senior Subway $0.60 $1.00 Student Bus $0.60 $0.75 Student Subway $0.85 $1.00 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.] 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?