M2623 Worksheet 8 Name: Complete the following exercises on a separate sheet of paper and in Excel. Vou may use the textbook, your notes, the intemet, and a calculator as resources. Your responses must include appropriate math and/or explanation. Show your work and lustlfy your reasoningl Some exercises may require you to make assumptions or look up additional information. State any assumptions or sources in your response. 1. (6.12.6) 4 pts Cash-strapped T proposes 23 percent fare increase. On March 28, 2012, the Massachusetts Bay Transportation Authority (META) provided the fare data in Table 6.21. Riders can pay with a stored-value Charlie Card or with 3 Charlie Ticket bought on the spot. FareCategory Current Proposed Charlie Card Bus 31.25 51.50 Subway $1.70 5200 Senior Bus $0.40 $0.75 Senior Subway $0.60 8100 Student Bus $0.60 $0.75 Student Subway $0.85 $1.00 Char] ckel Bus $1.50 $2.00 Subway 2.00 $2.50 Table 6.21. mm {are increases [R137] 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