then wh Exercise 7.8.9. [S] [A][Section 7.5][Goal 7.2][Goal 7.5] Comparing telephone calling plans. A cell phone company has introduced a pay-as-you-go price structure, with three possibilities. Plan 1 Plan 2 Plan 3 $10 a month $15 a month $30 a month 10 cents per minute 7.5 cents per minute 5 cents per minute (a) For each plan, find a linear function that describes how the total cost for one month depends on the number of minutes used. (b) Construct a table in Excel showing the total cost for one month for each of the three plans. Organize your data this way: • Create a sequence of cells in column A for the various possible numbers of minutes. Label that column. Start with 0 minutes. What's a good step to use? What's a reasonable place to stop? • Use columns B, C and D for each of the three plans. The fixed charge and charge per call should be in cells in those columns too, so you can use the same formula everywhere in the data table. (That will call for clever use of the $ to keep Excel from changing row numbers and column letters when you don't want it to.) (c) Use Excel to draw one chart showing how the monthly bill (y-axis) depends on the number of minutes you use the phone (x-axis) for all three plans. (d) Write a paragraph explaining to your friend how she should go about choosing the plan that's best for her.
then wh Exercise 7.8.9. [S] [A][Section 7.5][Goal 7.2][Goal 7.5] Comparing telephone calling plans. A cell phone company has introduced a pay-as-you-go price structure, with three possibilities. Plan 1 Plan 2 Plan 3 $10 a month $15 a month $30 a month 10 cents per minute 7.5 cents per minute 5 cents per minute (a) For each plan, find a linear function that describes how the total cost for one month depends on the number of minutes used. (b) Construct a table in Excel showing the total cost for one month for each of the three plans. Organize your data this way: • Create a sequence of cells in column A for the various possible numbers of minutes. Label that column. Start with 0 minutes. What's a good step to use? What's a reasonable place to stop? • Use columns B, C and D for each of the three plans. The fixed charge and charge per call should be in cells in those columns too, so you can use the same formula everywhere in the data table. (That will call for clever use of the $ to keep Excel from changing row numbers and column letters when you don't want it to.) (c) Use Excel to draw one chart showing how the monthly bill (y-axis) depends on the number of minutes you use the phone (x-axis) for all three plans. (d) Write a paragraph explaining to your friend how she should go about choosing the plan that's best for her.
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
![on,
e
3
1
then when
Exercise 7.8.9. [S] [A][Section 7.5][Goal 7.2][Goal 7.5] Comparing telephone calling plans.
A cell phone company has introduced a pay-as-you-go price structure, with three
possibilities.
Plan 1
Plan 2
Plan 3
$10 a month
$15 a month
$30 a month
10 cents per minute
7.5 cents per minute
5 cents per minute
(a) For each plan, find a linear function that describes how the total cost for one month depends
on the number of minutes used.
(b) Construct a table in Excel showing the total cost for one month for each of the three plans.
Organize your data this way:
• Create a sequence of cells in column A for the various possible numbers of minutes.
Label that column. Start with 0 minutes. What's a good step to use? What's a reasonable
place to stop?
• Use columns B, C and D for each of the three plans. The fixed charge and charge per
call should be in cells in those columns too, so you can use the same formula everywhere
in the data table. (That will call for clever use of the $ to keep Excel from changing row
numbers and column letters when you don't want it to.)
(c) Use Excel to draw one chart showing how the monthly bill (y-axis) depends on the number
of minutes you use the phone (x-axis) for all three plans.
(d) Write a paragraph explaining to your friend how she should go about choosing the plan
that's best for her.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc8d5fe8-c51e-4914-8d45-6bcdd10da2fd%2F10c9564c-1b4a-453b-aba3-b4d0c13c911f%2Fd8kft_processed.jpeg&w=3840&q=75)
Transcribed Image Text:on,
e
3
1
then when
Exercise 7.8.9. [S] [A][Section 7.5][Goal 7.2][Goal 7.5] Comparing telephone calling plans.
A cell phone company has introduced a pay-as-you-go price structure, with three
possibilities.
Plan 1
Plan 2
Plan 3
$10 a month
$15 a month
$30 a month
10 cents per minute
7.5 cents per minute
5 cents per minute
(a) For each plan, find a linear function that describes how the total cost for one month depends
on the number of minutes used.
(b) Construct a table in Excel showing the total cost for one month for each of the three plans.
Organize your data this way:
• Create a sequence of cells in column A for the various possible numbers of minutes.
Label that column. Start with 0 minutes. What's a good step to use? What's a reasonable
place to stop?
• Use columns B, C and D for each of the three plans. The fixed charge and charge per
call should be in cells in those columns too, so you can use the same formula everywhere
in the data table. (That will call for clever use of the $ to keep Excel from changing row
numbers and column letters when you don't want it to.)
(c) Use Excel to draw one chart showing how the monthly bill (y-axis) depends on the number
of minutes you use the phone (x-axis) for all three plans.
(d) Write a paragraph explaining to your friend how she should go about choosing the plan
that's best for her.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 2 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