MAT 144 Grand Canyon University Algebra Worksheet

Please answer directly on the worksheet. also please review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion. Please review scoring chart on first slide of excel. I live in McDowell County, WV and will be traveling to Miami Florida with 6 friends (that should answer the questions needed for assignment). Thank you tremendously!

Budget Expenses
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Points Possible
Points Earned
Comments
Location identified
2
Travel Expenses identified and calculated for
9
the entire group with an Excel formula
Lodging Expenses identified and calculated for
the entire group with an Excel formula
Food Expenses identified and calculated for the
entire group with an Excel formula
Entertainment Expenses identified and
calculated for the entire group with an Excel
formula
Total Budget
Budget Expenses total
9
9
9
7
45
0
Loans
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Possible Points
Points Earned
Comments
PMT Calculation
12
Total cost of Loan
6
Total Interest Paid
4
Explain in 25 to 100 words which loan is the
8
best option and why.
Question 2 total
30
0
Stats
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Points Possible
Points Earned
Comments
Mean, Median, Mode
9
Range, Minimum, Maximum
9
Standard Deviation
4
z-Score
4
Set up of Bins (Low and High Formulas)
8
Frequency Columns
8
Histogram
8
Stats total
50
0
Major Assignment 1
Total for Major Assignment 1
125
0
Location
Transportation
Item
Description
Qty
Price each
numbers Number or NA
Total price
Formulas
Source
Link or citation
Total price
Formulas
Link or citation
Total price
Formulas
Link or citation
(Add rows as needed)
Lodging
Item
Description
Qty
Price each
numbers Number or NA
(add rows as needed)
Food
Item
Description
Qty
Price each
numbers Number or NA
(add rows as needed)
Entertainment and Misc.
Item
Numbers
(add rows as needed)
Qty
Price each
numbers Number or NA
Total price
Formulas
Link or citation
Input Name Here
Formula Required
Number/Text
Budget Total:
Each cell is color coded as indicated to the left. The ce
will change to grey after it has been completed.
formula
You are going on a dream vacation with five of your closest friends for a week. Since you are
taking a math course, your friends asked you to come up with a budget to see how much it
will cost each of you. Please identify your location in the US (input in Cell D2) and then
determine the total costs (for everyone going) – remember to be thorough so the group does
not run out of money. Your expense list must include the following (this means that you
cannot book an all-expenses paid trip):
•Travel expenses, such as plane or bus fare, local travel within the area.
•Lodging expenses. If you plan to camp, you will include expenses for your camping gear.
•Food expenses while you are on your trip. One way to do this is to research cost of living in
your destination county to find out what a local family would expect to budget to pay for
food. Another is to research local restaurants and groceries.
•Entertainment or activity expenses and/or miscellaneous expenses that may occur.
d as indicated to the left. The cell
y after it has been completed.
Formula Required
Number/Text
Loans
Loan A
Principal (P) (same for both loans)
number
rate ( r)
number
# of Compoundings per year (n)
number
time in years (t)
number
Payment (PMT)
formula
Loan B
number
number
number
number
formula
Total Paid
Interest Paid
Source
formula
formula
Link or citation
formula
formula
Link or citation
Suppose you all decide you want to finance
a good source). Make sure the interest rate
monthly payment amount, the total amoun
pay. NOTE: You can find loan rates on maj
information, feel free to use one of the lin
Loan payment formula: PMT = P*(r/n)/(1 –
PMT is the payment required to pay off a lo
You must use Excel formulas including cell
paid.
Discuss which loan would be a better option and why: (8 points!)
ou all decide you want to finance the trip with a loan. Find two different available offers (the internet is
rce). Make sure the interest rate and loan length are both different in each option. Calculate the
ayment amount, the total amount you will pay over the life of the loan and the total interest you will
E: You can find loan rates on major bank and credit union websites without providing personal
n, feel free to use one of the links here.
ent formula: PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t))
payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.
use Excel formulas including cell references to calculate the loan payment, total paid and interest
er option and why: (8 points!)
Link to Credit Card Inter
NerdWalle
Credit Karm
Top10Personal
Link to Credit Card Interest Rate Source
NerdWallet
Credit Karma
Top10PersonalLoans
Height
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Input name below to
generate the data
Full Name
Formula Required
Number/Text
Descriptive Statistics
Mean
Median
Mode
Range
Minimum
Maximum
Standard Deviation
Your height (in inches)
z score for your height
Bin Width
formula
formula
formula
formula
formula
formula
formula
number
formula
Histogram – Bin width
formula
The Height Data is named height,
use this name in your formu
Low
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
High
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
(remem
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
ght Data is named height, you may
e this name in your formulas.
Frequency Distribution
Bins
Cumulative Frequency
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
auto
formula
(remember to create the Histogram, too).
Histogram Here
Frequency
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
formula
Using the randomizing data set of 102 heig
Excel formulas with cell references find the
Statistics:
• Mean
• Median
• Mode
• Range
• Minimum
• Maximum
• Standard deviation
• The z score for your height (use the com
standard deviation)
Also, using Excel formulas with cell referen
following:
• Frequency distribution
• Histogram – Create a Graphical Represe
andomizing data set of 102 heights provided and using
ulas with cell references find the following Descriptive
n
um
um
rd deviation
core for your height (use the computed mean and
eviation)
Excel formulas with cell references complete the
ncy distribution
am – Create a Graphical Representation of the Data