07 Jan Standard deviation
Week 2 assignment
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
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!)
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)
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.