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.]
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter3: Functions And Graphs
Section3.5: Graphs Of Functions
Problem 81E
Related questions
Question
![A+
F3
#
F
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.]
F4
4
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?
2 (6 14 13) 3 nts - The table below shows the salarestructure of two departments in a hypothetical
$
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?
Charlie Ticket
Bus
$1.50
Subway
$2.00
Table 6.21. MBTA fare increases [R187]
R
0-
F5
-
%
5
T
O +
F6
6
$2.00
$2.50
F7
Y
7
*4"
F8
&
7
F9
4.00
8
*
F10
(
9
F11
O
☆
0
F12
Hom
P](/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:A+
F3
#
F
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.]
F4
4
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?
2 (6 14 13) 3 nts - The table below shows the salarestructure of two departments in a hypothetical
$
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?
Charlie Ticket
Bus
$1.50
Subway
$2.00
Table 6.21. MBTA fare increases [R187]
R
0-
F5
-
%
5
T
O +
F6
6
$2.00
$2.50
F7
Y
7
*4"
F8
&
7
F9
4.00
8
*
F10
(
9
F11
O
☆
0
F12
Hom
P
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
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt