Essay Grade

Budget Expenses
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Points Possible
Location identified
Travel Expenses identified and calculated for
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
Question 1 total
Points Earned
Comments
2
14
14
14
14
2
60
0
Loans
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Possible Points
Calculations for both loans are correct
Explain in 25 to 100 words which loan is the
best option and why.
Question 2 total
Points Earned
Comments
21
14
35
0
Stats
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Mean, Median, Mode
Range, Minimum, Maximum
Standard Deviation
Frequency Distribution
Histogram
z-Score
Points Possible
6
3
4
6
6
5
Question 3 total
30
Points Earned
0
Worksheet 1
Total for Worksheet 1
125
0
Comments
Locatio
New York City Flight from Au
Transporta
Item
Qty
Airplane
Rental SUV
Price each
5
5
$363
$67
Lodgin
Item
Qty
Hampton Inn Manhattan/Times Square double beds
adjacent rooms
Price each
5
$328
Food
Item
Breakfast : Times Square Diner & Grill
Lunch: The Hard Rock Café
Dinner : The Four Seasons Restaurant
Qty
Item
Day 1: Madame Tussauds Museum
Day 2: Ripley’s Believe It or Not Times Square
Day 3: Encouter Ocean Odyssey
Day 4: The Museum of Modern Art
Qty
Price each
5
5
5
$28
$30
$59
5
5
5
5
Price each
$29,95
$25,60
$39,50
$25
5
$75
Entertainment
Day 5: Lion King Broadway tickets
Location
rk City Flight from Augusta to New York City
Transportation
Total price
1815
335
Lodging
Total price
1640
Food
Total price
140
150
295
Entertainment and Misc.
Total price
149,75
128
197,5
125
375
Location
t from Augusta to New York City
Transportation
Delta Airlines
Source
https://www.delta.com/?Log=1&mkcpgn=sezzzggusacspribd&clickid=_k_CjwKCAjw27jnBRBuEiwAdjQXDMVg3eS
BMBIwQ5FjMIp14fg6LvylyYiGtQelPgmdG6CqqGzRznDqxoC4eMQAvD_BwE_k_&tracking_id=284×9020804&s_kwcid=TC%7C848
9%7Cdelta%20airlines%7C%7CS%7Ce%7C268916594040&ad_id=268916594040&campaign=1400692046&adgro
up=60691739692&gclid=CjwKCAjw27jnBRBuEiwAdjQXDMVg3eSBMBIwQ5FjMIExpedia.com pick up from airport *TOTAL PRICE IS FOR 5 DAY RENTAL
Lodging
https://secure3.hilton.com/en_US/hp/reservation/book.htm?execution=e1s4
Food
https://www.timessquaredinerandgrill.com/?utm_source=GBL&utm_medium=GBL&utm_campaign=CustomAudience&utm_
https://www.timessquarenyc.org/locations/hard-rock-cafe
https://www.fourseasonsrestaurant.com/menus/
tainment and Misc.
https://www.madametussauds.com/new-york/en/tickets/
https://ripleysnewyork.com/buy-tickets/
https://natgeoencounter.com/ticketing
https://www.vividseats.com/concerts/piero-de-benedictis-tickets/piero-de-benedictis-sony-hall-6-21https://www.moma.org/tickets/select
3095867.html?utm_source=eventful&utm_medium=cpc&utm_campaign=Concert&utm_term=Piero%20de%20
Benedictis#showDetails=VB1999851007&qty=5
Budget Total:
$4.975
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 and then determine the total
costs – 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.
CustomAudience&utm_term=GBL&utm_content=GBL#!menu
Loans
Principal (P) (same for both loans)
rate ( r)
# of Compoundings per year (n)
time in years (t)
Payment (PMT)
Periodic Rate
Starting Payment Number
Ending Payment Number
Total Paid
Interest Paid
Source
Loans
Loan A
$4.975
19,95%
60
5
$131,67
0,003325
1
60
$
6.071,43
$
(2.925,12)
https://www.creditkarma.com/shop/personal-loans#newloans
Discuss which loan would be a better option and why: (14 points!) The best choice for the vacati
9.74%. Though the monthly payment is $28.25 more, overall the group would save more. The loa
because the interest paid over the life of the loan amounts to $782.22. Compared to Loan A, the
Loan B
$4.975
9,74%
36
3
$159,92
0,002705556
1
36
$
5.483,23
$
(782,22)
https://www.creditkarma.com/shop/personal-loans#newloans
Suppose you all decide you want to finance the
a good source). Make sure the interest rate and
monthly payment amount, the total amount you
pay. NOTE: You can find loan rates on major ba
information, feel free to use one of the links he
Loan payment formula: PMT = P*(r/n)/(1 – (1 +
PMT is the payment required to pay off a loan o
You must use Excel formulas including cell refe
paid.
Fair Credit Score: 640-699
nd why: (14 points!) The best choice for the vacation group to choose would be Loan B. Loan B has the low
more, overall the group would save more. The loan terms would be 3 years versus 5 years. Loan B would b
an amounts to $782.22. Compared to Loan A, the savings in interest paid with Loan B amounts to a differe
e you want to finance the trip with a loan. Find two different available offers (the internet is
sure the interest rate and loan length are both different in each option. Calculate the
ount, the total amount you will pay over the life of the loan and the total interest you will
ind loan rates on major bank and credit union websites without providing personal
to use one of the links here.
a: PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t))
quired to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.
rmulas including cell references to calculate the loan payment, total paid and interest
t Score: 640-699
Loan B has the lowest interest rate of
ears. Loan B would be the best choice also
amounts to a difference of $2,142.90.
Link to Credit Card Interest Rate So
NerdWallet
Credit Karma
Top10PersonalLoans
to Credit Card Interest Rate Source
NerdWallet
Credit Karma
Top10PersonalLoans
Data
66,5
73,8
67,6
70,9
63,5
67,3
63,7
67,8
71,4
67,4
65,2
69,6
68,5
72,3
65,2
73,7
68,6
66,4
70,7
65,7
67,2
70,6
66,2
73,5
68,2
73,2
65,7
72,6
67,2
69,7
64,7
67,2
68,9
68,6
64,1
68,3
62,0
64,1
71,7
60,9
65,7
70,6
67,2
66,6
74,7
←
←
←
←
←
←
←
Copy the data from the Data
tab. Make sure and paste as
“Values (V)” (icon with “123”)
so that this data does not
regenerate every time you
change the sheet.
Descriptive Statistics
Mean
Median
Mode
Range
Minimum
Maximum
Standard Deviation
Your height
z score for your height
Low
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
68,5
68,6
69,6
15,7
60,2
75,9
3,5023591
65
-1,009964
This was all covered in Topic 1 DQ 2 and
Topic 2 DQ 2.
Frequency Distr
High
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
Formula/Number
(remember to create the
72,5
64,4
69,2
69,6
66,9
65,7
62,4
67,4
63,7
74,3
70,7
71,8
64,7
70,3
70,2
68,4
64,1
69,6
60,2
70,3
68,1
72,2
67,4
61,2
69,6
65,5
68,6
69,6
65,8
75,9
72,7
67,7
63,0
68,8
73,0
71,6
68,6
72,1
71,6
65,5
72,4
68,8
61,1
72,0
63,6
73,5
71,3
70,3
70,5
70,6
69,4
72,5
66,0
72,9
71,2
73,1
71,5
Frequency Distribution
Bins
Cumulative Frequency
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
words or formula Formula
(remember to create the Histogram, too).
Frequency
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Histogram
Histogram must be built from the
Frequency column of the above table.
Using the data set of 102 random heights provide
Excel formulas to find the following:
– Mean
– Median
– Mode
– Range
– Minimum
– Maximum
– Standard deviation
– Frequency distribution
– Histogram
– The z score for your height (use the computed m
and standard deviation)
02 random heights provided use
the following:
n
height (use the computed mean
n)
Generated Data
65,7
65,1
68,4
61,4
67,7
63,3
68,9
67,3
59,9
66,4
73,1
63,7
75,3
65,4
65,2
68,0
67,7
69,3
66,6
71,5
63,7
72,1
70,5
63,4
71,7
70,4
70,4
66,9
74,9
69,2
70,3
68,5
73,8
69,2
72,0
62,8
67,0
67,7
69,1
61,0
58,1
69,8
74,4
67,2
63,9
66,6
65,4
65,7
71,3
67,7
68,3
73,5
69,3
72,9
68,3
67,7
70,7
66,3
63,0
67,5
64,0
63,7
65,1
66,0
63,7
66,9
68,3
70,7
68,0
72,0
66,2
68,6
67,9
69,2
67,4
61,7
67,8
65,9
77,0
66,6
62,8
72,4
62,8
68,5
71,5
66,5
65,9
65,2
68,1
68,1
67,2
58,1
69,6
64,5
67,0
72,4
72,6
66,5
73,1
57,5
66,7
74,5

Purchase answer to see full
attachment