Math 144 major assignment 2

This assignment uses a scoring guide. Review the scoring guide on the last tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion.

Grading Sheet
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 the entire group with an Excel formula 14
Lodging Expenses identified and calculated for the entire group with an Excel formula 14
Food Expenses identified and calculated for the entire group with an Excel formula 14
Entertainment Expenses identified and calculated for the entire group with an Excel formula 14
Total Budget 2
Question 1 total 60 0
Loans
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Possible Points Points Earned Comments
Calculations for both loans are correct 21
Explain in 25 to 100 words which loan is the best option and why. 14
Question 2 total 35 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 6
Range, Minimum, Maximum 3
Standard Deviation 4
Frequency Distribution 6
Histogram 6
z-Score 5
Question 3 total 30 0
Worksheet 1
Total for Worksheet 1 125 0
Budget Expenses
Location
Port Angeles, WA and The Olympic Peninsula Budget Total: $ 8,546.80
Transportation
Item Qty Price each Total price Source
Description numbers Number or NA Formulas Link or citation
Flight from Fairbank to Seattle 5 $ 78.00 $ 390.00 https://www.alaskaair.com
Flight from Seattle to Fairbank 5 $ 79.00 $ 395.00
Seattle Ferry 5 $ 8.45 $ 42.25 https://wave2go.wsdot.com
Return from Ferry ( Seattle Bainbridge) 5 $ 8.35 $ 41.75
Car rental 1 $ 465.00 $ 465.00 https://www.dollar.com
(Add rows as needed)
Lodging
Item Qty Price each Total price
Description numbers Number or NA Formulas Link or citation
Sheraton Seattle hotel room 1 (nightly) 6 $ 212.00 $ 1,272.00 https://www.expedia.com/Sheraton-Seattle-Hotel
Sheraton Seattle hotel room 2 (nightly) 6 $ 212.00 $ 1,272.00
Sheraton hotel room 3 (nightly) 6 $ 212.00 $ 1,272.00
(add rows as needed)
Food
Item Qty Price each Total price
Description numbers Number or NA Formulas Link or citation
breakfast (average cost on hotel breakfast menu) 40 $ 10.45 $ 418.00 https://www.thewaffler.com/
Lunch (average cost on restaurant menu) 40 $ 14.89 $595.60 http://marinationmobile.com/
Dinner (average cost on restaurant menu) 40 $ 23.33 $ 933.20 https://canlis.com/
Snacks (daily budget per person) 40 $ 12.00 $ 480.00
(add rows as needed)
Entertainment and Misc.
Item Qty Price each Total price
Numbers numbers Number or NA Formulas Link or citation
Bike Rental for mountain 5 $ 30.00 $ 150.00 www.soundbikeskayaks.com
Kayak Whale Tour 5 $ 80.00 $ 400.00 https://www.atkayaking.com
Paddle Tour 5 $ 79.00 $ 395.00 https://www.atkayaking.com
Marine Life Tour 5 $ 5.00 $ 25.00 https://feiromarinelifecenter.org
(add rows as needed)
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.

https://www.alaskaair.com/ https://wave2go.wsdot.com/ https://feiromarinelifecenter.org/ https://www.dollar.com/ https://www.expedia.com/Sheraton-Seattle-Hotel http://www.soundbikeskayaks.com/ https://www.atkayaking.com/ https://www.atkayaking.com/
Loans
Loans
Loan A Loan B
Principal (P) (same for both loans) $ 12,000.00 $ 12,000.00
rate ( r) 9.40% 5.40%
# of Compoundings per year (n) 12 12
time in years (t) 5 3
Payment (PMT) $ 251.44 $ 361.81
Total Paid $ 15,086.18 $ 13,025.15
Interest Paid $ 3,086.18 $ 1,025.15
Source https://www.creditkarma.com https:/https://www.wellsfargo.com/personal-credit/personal-loan//www.wellsfargo.com/personal-credit/rates/

Please note that the Confidence Interval Explanation document is provided for reference and assistance with Major Assignment 2.