FITM Monthly Cost Personal Hotspot & Tablets Verizon Data Plan Worksheet

Hi this is a project due soon, the instructors are in the pic named MTH001 and the other pics are for completing the paper. For anymore questions please feel free to ask.

Due Wednesday by 11:59pm Points 100 Submitting a file upload
Available Oct 2 at 12am – Dec 2 at 11:59pm 2 months
You will form groups of up to three students (groups of one are OK) and work together on a project this semester.
Hopefully, you will find this a fun application of the Precalculus material to “real world” questions. You will prepare a
project summary: a written report and/or a video of an oral presentation, to be uploaded to canvas. You will find it in
the assignments section in canvas. The deadline for the project upload is December 2, the last day of classes. You are
free to submit before then, but no late submissions will receive credit.
All project members must actively participate in the project summary. The summary should, of course, should be based
on the team’s own work. The project grade will count 10% toward your course grade.
Instructions:
1) Find classmates to make a group of up to three students. No more that three, but individual projects are fine too.
2) Pick end of chapter project from the textbook from Chapter 2-6. Some projects cover multiple pages, so make sure
your read all parts.
· Chapter 2: Choosing a Data Plan
• Chapter 3: Beta of a Stock
Chapter 4: Length of Day
• Chapter 5: Depreciation of Cars
• Chapter 6: Length of Day Revisited
3) Prepare a short (3+ pages) written report and/or a video presentation with all the parts of the project. Be sure to
answer all questions in the textbook and add your own conclusions about what you learned. Be sure to indicate all
team members, and all team members should upload the same files.
4) Your work will be evaluated and graded according to the following criteria:
• Was the project summary clear? Include a description of the problem and techniques used.
• Was correct mathematical notation used and were the mathematical techniques explained?
• Did the summary answer all questions correctly? Again, project descriptions may cover several textbook pages.
• Did the team use an innovative technique in finding or presenting their results, and/or make correct but creative
conclusions, and/or add anything beyond the textbook requirements?
Chapter Projects
Internet-based Project
I. Choosing a Data Plan Collect information from your family,
friends, or consumer agencies such as Consumer Reports.
Then decide on a service provider choosing the company that
you feel offers the best service. Once you have selected a
service provider, research the various types of individual plans
offered by the company by visiting the provider’s website.
Many cellular providers offer family plans that include
unlimited talk, text, and data. However, once a data cap has
been reached, service may be slowed, which prevents media
from being streamed. So, many customers still purchase data-
only plans for devices such as tablets or laptops. The monthly
cost is primarily determined by the amount of data used and
the number of data-only devices.
1. Suppose you expect to use 10 gigabytes of data for a
single tablet. What would be the monthly cost of each
plan you are considering?
2. Suppose you expect to use 30 gigabytes of data and want
a personal hotspot, but you still have only a single tablet.
What would be the monthly cost of each plan you are
considering?
3. Suppose you expect to use 20 gigabytes of data with three
tablets sharing the data. What would be the monthly cost
of each plan you are considering?
4. Suppose you expect to use 20 gigabytes of data with a
single tablet and a personal hotspot. What would be the
monthly cost of each plan you are considering?
5. Build a model that describes the monthly cost C, in dollars,
as a function of the number g of data gigabytes used,
assuming a single tablet and a personal hotspot for each
plan you are considering.
6. Graph each function from Problem 5.
7. Based on your particular usage, which plan is best for you?
Chapter Projects
2. Using Excel to draw a scatter plot. Treat the percentage
change in the S&P500 as the independent variable and the
percentage change in the stock you chose as the dependent
variable. The easiest way to draw a scatter plot in Excel
is to place the two columns of data next to each other
(for example, have the percentage change in the S&P500
in column F and the percentage change in the stock you
chose in column G). Then highlight the data and select the
Scatter Plot icon under Insert. Comment on the type of
relation that appears to exist between the two variables.
3. Finding beta. To find beta requires that we find the line of
best fit using least-squares regression. The easiest approach
is to click inside the scatter plot. Select the Chart Elements
icon (+). Check the box for Trendline, select the arrow
to the right, and choose More Options. Select Linear and
check the box for Display Equation on chart. The line of
best fit appears on the scatter plot. See below.
0.08
0.06
0.04
.
0.02
Internet-based Project
I. The Beta of a Stock You want to invest in the stock market
but are not sure which stock to purchase. Information is the
key to making an informed investment decision. One piece
of information that many stock analysts use is the beta of
the stock. Go to Wikipedia (http://en.wikipedia.org/wiki/
Beta_(finance)) and research what beta measures and what it
represents.
1. Approximating the beta of a stock. Choose a well-known
company such as Google or Coca-Cola. Go to a website
such as Yahoo! Finance (http://finance.yahoo.com/) and
find the weekly closing price of the company’s stock
for the past year. Then find the closing price of the
Standard & Poor’s 500 (S&P500) for the same time period.
To get the historical prices in Yahoo! Finance, select
Historical Data from the menu. Choose the appropriate
time period. Select Weekly and Apply. Finally, select
Download Data, and Open with Microsoft Excel. Repeat
this for the S&P500, and copy the data into the same
spreadsheet. Finally, rearrange the data in chronological
order. Be sure to expand the selection to sort all the data.
Now, using the adjusted close price, compute the percentage
change in price for each week, using the formula
-0.1
-0.05
D
0.05
0.1
X
-0.02
-0.04
-0.06
y = 0.9046x + 0.0024 R2 = 0.4887
Series 1 Linear (series 1)
P₂ – Po
% change =
Po
The line of best fit for this data is y = 0.9046x + 0.0024.
You may click on Chart Title or either axis title and insert
the appropriate names. The beta is the slope of the line of
best fit, 0.9046. We interpret this by saying, “If the S&P500
increases by 1%, then this stock will increase by 0.9%,
on average.” Find the beta of your stock and provide an
interpretation. NOTE: Another way to use Excel to find
the line of best fit requires using the Data Analysis Tool
Pack under add-ins.
For example, if week 1 price is in cell D1 and week 2 price
– D1
is in cell D2, then % change =
D1
Repeat this for
the S&P500 data.
D2 –
The following projects are available on the Instructor’s Resource Center (IRC):
II. Cannons A battery commander uses the weight of a missile, its initial velocity, and the position of its gun to determine where the
missile will travel.
III. First and Second Differences Finite differences provide a numerical method that is used to estimate the graph of an unknown function.
IV. CBL Experiment Computer simulation is used to study the physical properties of a bouncing ball.
Chapter Projects
Format Trendline
TRENDLINE OPTIONS
• TRENDLINE OPTIONS
Logarithmic
Bolynomial Order
Pager
Period 2
Average
Trendline Name
Automatic Linear Series)
Custom
Forecast
Eorward
0.0 period
Backward 0.0 period
Set Intercept
0.0
Display Equation on chart
Display -squared value on chart
Figure 52
Internet-based Project
I. Length of Day Go to http://en.wikipedia.org/wiki/Latitude and
read about latitude through the subhead “Preliminaries.” Now
go to http://www.orchidculture.com/COD/daylength.html.
1. For a particular day of the year, record in a table the
length of day for the equator (0°N), 5°N, 10°N,…, 60°N.
Enter the data into an Excel spreadsheet, Tl-graphing
calculator, or some other spreadsheet capable of finding
linear, quadratic, and cubic functions of best fit.
2. Draw a scatter diagram of the data with latitude as the
independent variable and length of day as the dependent
variable using Excel, a TI-graphing calculator, or some
other spreadsheet. The Chapter 3 project describes how
to draw a scatter diagram in Excel.
3. Determine the linear function of best fit. Graph the linear
function of best fit on the scatter diagram. To do this in
Excel, right click on any data point in the scatter diagram.
Now click the Add Trendline … menu. Under Trendline
Options, select the Linear radio button and select Display
Equation on Chart. See Figure 52. Move the Trendline
Options window off to the side and you will see the linear
function of best fit displayed on the scatter diagram. Do
you think the function accurately describes the relation
between latitude and length of day?
4. Determine the quadratic function of best fit. Graph the
quadratic function of best fit on the scatter diagram. To do
this in Excel, right-click on any data point in the scatter
diagram. Now click the Add Trendline …menu. Under
Trendline Options, select the Polynomial radio button with
Order set to 2. Select Display Equation on chart. Move the
Trendline Options window off to the side and you will see
the quadratic function of best fit displayed on the scatter
diagram. Do you think the function accurately describes
the relation between latitude and length of day?
5. Determine the cubic function of best fit. Graph the cubic
function of best fit on the scatter diagram. To do this in
Excel right-click on any data point in the scatter diagram.
Now click the Add Trendline …menu. Under Trendline
Options, select the Polynomial radio button with Order set
to 3. Select Display Equation on chart. Move the Trendline
Options window off to the side and you will see the cubic
function of best fit displayed on the scatter diagram. Do
you think the function accurately describes the relation
between latitude and length of day?
6. Which of the three models seems to fit the data best?
Explain your reasoning
7. Use your model to predict the hours of daylight on the day
you selected for Chicago (41.85 degrees north latitude).
Go to the Old Farmer’s Almanac or another website to
determine the hours of daylight in Chicago for the day you
selected. How do the two compare?
Citation: Excel © 2018 Microsoft Corporation. Used with permission from Microsoft.
The following project is available at the Instructor’s Resource Center (IRC):
II. Theory of Equations The coefficients of a polynomial function can be found if its zeros are known, which is an advantage of using
polynomials in modeling.
Chapter Projects
Figure 57. Move the Trendline Options window off to the
side, if necessary, and you will see the exponential function
of best fit displayed on the scatter plot. Do you think the
function accurately describes the relation between age of
the car and suggested retail price?
Format Trendline
Trendline Options
Trendline Options
Exponential
Linear
Logarithmic
Polynomial Order
o
Power
Moving
Internet-based Project
I. Depreciation of Cars Kelley Blue Book is a guide that provides
the current retail price of cars. You can access the Kelley Blue
Book online at www.kbb.com.
1. Identify three cars that you are considering purchasing,
and find the Kelley Blue Book value of the cars for 0
(brand new),1,2,3,4, and 5 years of age. Online, the value
of the car can be found by selecting Price New/Used.
Enter the year, make, and model of the new or used
car you are selecting. To be consistent, assume the cars will
be driven 12,000 miles per year, so a l-year-old car will
have 12,000 miles, a 2-year-old car will have 24,000 miles,
and so on. Choose the same options for each year,
and select Buy from a Private Party when choosing a price
type. Finally, determine the suggested retail price for cars
that are in Excellent, Good, and Fair shape. You should
have a total of 16 observations (1 for a brand new car, 3
for a 1-year-old car, 3 for a 2-year-old car, and so on).
2. Draw a scatter plot of the data with age as the independent
variable and value as the dependent variable using Excel,
a Tl-graphing calculator, or some other spreadsheet. The
Chapter 3 project describes how to draw a scatter plot
in Excel
3. Determine the exponential function of best fit. Graph the
exponential function of best fit on the scatter plot. To do
this in Excel, right click on any data point in the scatter
plot. Now select Add Trendline. Select the Exponential
radio button and select Display Equation on Chart. See
Average
Period 2:
Trendline Name
• Automatic Expon Series 1)
Gustom
Forecast
forward 00 periods
Backward 00 periods
Set Intercept
Display Equation on chart
Display B-squared value on chart
Figure 57
4. The exponential function of best fit is of the
form y = Ce”, where y is the suggested retail value of the
car and x is the age of the car (in years). What does the
value of Crepresent? What does the value of r represent?
What is the depreciation rate for each car that you are
considering?
5. Write a report detailing which car you would purchase
based on the depreciation rate you found for each car.
Citation: Excel 2018 Microsoft Corporation. Used with permission from Microsoft.
The following projects are available on the Instructor’s Resource Center (IRC):
II. Hot Coffee A fast-food restaurant wants a special container to hold coffee. The restaurant wishes the container to quickly cool the
coffee from 2009 to 130°F and keep the liquid between 110° and 130°F as long as possible. The restaurant has three containers to
select from. Which one should be purchased?
III. Project at Motorola Thermal Fatigue of Solder Connections Product reliability is a major concern of a manufacturer. Here a
logarithmic transformation is used to simplify the analysis of a cell phone’s ability to withstand temperature change.
Chapter Projects
8. Now, develop an Excel spreadsheet to analyze the various plans you are considering. Suppose you want a plan that
offers 50 gigabytes of shared data and costs $60 per month. Additional gigabytes of data cost $15 per gigabyte, extra tablets can
be added to the plan for $10 each per month, and each hotspot or laptop costs $20 per month. Because these data plans have a
cost structure based on piecewise-defined functions, we need an “if/then” statement within Excel to analyze the cost of the plan.
Use the accompanying Excel spreadsheet as a guide in developing your spreadsheet. Enter into your spreadsheet a variety of
possible amounts of data and various numbers of additional tablets, laptops, and hotspots.
B
C
D
$60
50
12
$15
1
2 Monthly fee
3 Allotted data per month (GB)
4 Data used (GB)
5 Cost per additional GB of data
6
7 Monthly cost of hotspot or laptop
8 Number of hotspots or laptops
9 Monthly cost of additional tablet
10 Number of additional tablets
11
12 Cost of data
13 Cost of additional devices/hotspots
14
15 Total Cost
16
$20
1
$10
2
=IF(B4