Reference no: EM131223628

Details:

Answer directly on the worksheet. Include your excel worksheet and copy your histogram into this file.

This assignment uses a scoring guide. Review the scoring guide prior to beginning the assignment to become familiar with the expectations for successful completion.

Answer directly on the worksheet.  Include your excel worksheet and copy your histogram into this file.

• 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 and then determine the total costs - remember to be thorough so the group does not run out of money.  All trips require transportation, lodging, and food so these are a must for the trip.  If you are planning a trip out of the US then you will need to include passport, and possibly visa, fees.  Your best source of information for these estimates will most likely be the internet so be sure and note the sources. 
• Suppose you all decide you want to finance the trip with a loan.  Find two different available offers (the internet is a good source) and discuss which one would be a better option.   Make sure the interest rate and loan length are both different in each option. 
• Using the data set of 102 random heights provided 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)