Messages
Proposals
Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.
Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support
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/
I have selected the Loan A to fund the vacation. The payment might be interest rate might be higher but the payment is lower over the 5 years plan and dividing the payment between 5 individuals the payment will be easier.
Suppose you all decide you want to finance the trip with a loan. Find two different available offers (the internet is a good source). Make sure the interest rate and loan length are both different in each option. Calculate the monthly payment amount, the total amount you will pay over the life of the loan and the total interest you will pay. NOTE: Do not provide personal information on the internet. You can find loan rates on major bank and credit union websites without providing personal information. Loan payment formula: PMT = P*(r/n)/(1 - (1 + r/n)^(-n*t)) PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years. You must use Excel formulas including cell references to calculate the loan payment, total paid and interest paid. Discuss which loan would be a better option and why: (14 points!)
https://www.wellsfargo.com/personal-credit/rates/ https://www.creditkarma.com/
Stats
Data
69.3 ← 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. Frequency Distribution
72.1 ← Low High Bins Cumulative Frequency Frequency
68.2 ← 61.4 62.78 60.7 - 62.25 3 3
68.8 ← 62.78 64.16 62.25 - 63.81 8 5
67.1 ← 64.16 65.55 63.81 - 65.36 4 4
69.7 ← 65.55 66.93 65.36 - 66.92 14 10
72.4 ← 66.93 68.31 66.92 -68.47 18 18
67.0 68.31 69.69 68.47-70.03 30 12
67.2 69.69 71.07 70.03 - 71.58 14 14
76.6 71.07 72.45 71.58- 73.14 34 20
71.2 72.45 73.84 73.14 - 74.69 11 11
74.2 73.84 75.22 74.69 - 76.25 12 1
75.7 75.22 76.60 76.25 - 77.80 3 3
66.4 Descriptive Statistics (remember to create the Histogram, too).
72.9 Mean 69.4
70.4 Median 69.5
63.5 Mode 67.1
62.7 Range 15.2
61.9 Minimum 61.4
70.5 Maximum 76.6
68.8 Standard Deviation 3.3
66.8 Your height 62
72.3 z score for your height -2.26
65.9
66.7
68.6
70.9 BIN WIDTH 1.38
68.1
71.4
66.1
72.3
73.5
67.8
72.5
72.3
67.6
73.3
71.5
73.5
71.7
69.6
72.4
76.4
72.7
64.9
71.0
68.6
69.7
70.5
72.2
67.1
73.2
71.4
67.7
61.4
65.7
76.4
71.1
65.0
69.9
70.6
71.9
69.9
69.3
70.4
71.2
67.1
71.7
65.1
67.9
71.9
67.1
62.9
69.0
67.4
67.3
71.0
73.3
72.9
63.9
69.0
71.4
68.2
68.6
63.6
67.7
72.0
69.8
68.2
66.6
66.7
68.8
66.7
65.5
70.7
72.8
66.2
68.5
63.4
72.7
72.3
68.1
Using the data set of 102 random heights provided use 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 mean and standard deviation)
Frequency 3 5 4 10 18 12 14 20 11 1 3
Frequency 3 5 4 10 18 12 14 20 11 1 3
Frequency 3 5 4 10 18 12 14 20 11 1 3
Frequency 3 5 4 10 18 12 14 20 11 1 3
Data
Generated Data
70.9
64.8
66.0
68.4
69.2
72.8
65.4
62.5
67.0
67.6
69.6
62.7
67.8
64.2
68.9
66.6
65.7
71.3
63.4
68.4
62.3
66.4
62.3
61.8
62.8
68.2
67.9
71.5
69.5
66.6
70.8
71.7
62.9
70.5
59.1
69.7
70.7
62.2
75.4
68.8
62.6
68.5
73.6
69.1
67.8
62.4
64.7
68.9
68.6
73.1
73.3
73.5
69.9
71.2
64.5
71.8
69.7
68.2
69.3
70.8
65.0
68.8
69.1
67.1
67.6
65.6
73.2
63.1
69.9
75.2
71.5
71.6
64.8
69.0
71.5
78.4
65.0
66.8
69.7
72.2
69.9
71.4
76.6
70.7
68.7
70.5
62.2
67.5
71.6
73.8
67.0
63.8
71.8
68.5
68.4
68.3
62.9
63.1
67.6
70.9
69.0
74.7
| Writer | Writer Name | Amount | Client Comments & Rating |
|---|---|---|---|
ONLINE |
Instant Homework Helper |
$36 |
She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up! |
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
Custom Original Solution And Get A+ Grades
| Writer | Writer Name | Offer | Chat |
|---|---|---|---|
ONLINE |
University Coursework HelpHi dear, I am ready to do your homework in a reasonable price. |
$142 | Chat With Writer |
ONLINE |
Homework GuruHi dear, I am ready to do your homework in a reasonable price and in a timely manner. |
$142 | Chat With Writer |
ONLINE |
Top Essay TutorI have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades. |
$145 | Chat With Writer |
ONLINE |
Helping HandI am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements. |
$140 | Chat With Writer |
ONLINE |
Essay & Assignment HelpI have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks! |
$135 | Chat With Writer |
ONLINE |
Innovative WriterI have read and understood all your initial requirements, and I am very professional in this task, I would be the best choice for this project, I am a PhD writer with 6-7 years of experience and can deliver quality notes to tight deadlines. I can generally compile up to 10 pages of lecture notes per day. I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time |
$135 | Chat With Writer |
Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.