Location Transportation Item Description Qty Price each numbers Number or NA Total price Formulas (Add rows as needed) Lodging Item Description Qty Price each numbers Number or NA Total price Formulas (add rows as needed) Food Item Description Qty Price each numbers Number or NA Total price Formulas Source Link or citation You are going on a dream vacation wi you are taking a math course, your fri how much it will cost each of you. Ple determine the total costs - remember money. Your expense list must includ an all-expenses paid trip) Link or citation Travel expenses, such as pl Lodging expenses. If you p camping gear. Food expenses while you a cost of living in your destin expect to budget to pay fo and groceries. Entertainment or activity e occur. Link or citation (add rows as needed) Entertainment and Misc. Item Numbers (add rows as needed) Qty Price each numbers Number or NA Total price Formulas Link or citation Budget Total: Formula are going on a dream vacation with five of your closest friends for a week. Since are taking a math course, your friends asked you to come up with a budget to see w much it will cost each of you. Please identify your location in the US and then ermine the total costs - remember to be thorough so the group does not run out of ney. Your expense list must include the following (this means that you cannot book 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. Principal rate # of Compoundings time Payment Loans Loan A number number number number formula Loan B number number number number formula Total Paid Interest Source formula formula Link or citation formula formula Link or citation Suppose you all decide you want to finance the trip wit good source). Make sure the interest rate and loan leng payment amount, the total amount you will pay over th Do not provide personal information on the internet. Yo websites without providing personal information. You must use Excel formulas including cell references t Discuss which loan would be a better option and why. ant to finance the trip with a loan. Find two different available offers (the internet is a nterest rate and loan length are both different in each option. Calculate the monthly mount you will pay over the life of the loan and the total interest you will pay. NOTE: mation on the internet. You can find loan rates on major bank and credit union ersonal information. including cell references to calculate the loan payment, total paid and interest paid. a better option and why. Data 74.6 67.9 73.5 72.7 72.2 67.5 71.8 69.1 70.3 67.2 72.4 72.3 70.6 67.3 69.4 64.3 67.0 68.4 72.7 71.2 66.3 65.5 66.4 65.7 73.0 64.1 65.3 67.3 76.8 68.6 71.7 69.3 69.7 68.1 61.7 72.2 67.3 66.4 61.1 70.6 69.1 63.9 69.9 71.0 Descriptive Statistics Mean Formula Median Formula Mode Formula Range Formula Minimum Formula Maximum Formula Standard Deviation Formula Your height Number z score for your height Formula Frequency Distribution Low High Title Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula Formula Formula words or formula (remember to create the Histogram, too). Chart Title 65.9 69.5 65.3 68.6 70.1 72.9 74.8 60.4 63.3 68.2 64.1 70.2 66.0 71.6 61.4 72.2 69.9 73.1 67.3 73.1 69.6 68.6 65.3 67.7 72.0 61.9 69.9 73.9 71.9 68.8 62.9 68.6 60.8 67.6 65.9 58.9 67.5 68.2 60.8 64.6 71.2 69.4 70.1 64.8 65.6 67.1 68.8 72.0 65.2 69.4 63.6 58.0 62.5 72.1 67.9 64.5 66.2 69.8 ribution Frequency Formula Formula Formula Formula Formula Formula Formula Formula Formula Formula e Histogram, too). 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) Question 1 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE U Points Possible Location identified 4 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 Question 1 total 60 Points Earned 0 Question 2 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE U Possible Points Calculations for both loans are correct 14 Explain in 25 to 100 words which loan is the best option and why. 21 Question 2 total 35 Points Earned 0 Question 3 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE U 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 on the worksheet. EXCEL FORMULAS MUST BE USED. Comments This part of the assignment is not graded, and you will not hand it track for your final Mission Trip project. Your final project includes a budget and financial plan for an overs instructions for that project so you can be prepared when the tim have thought about, and begun gathering research to answer the What skills you have or want to develop that would help make project would you like to do for that assignment?) What country would you like to visit for your trip? Why does th What expenses would you be likely to incur on the trip? This w budget for your trip. How does your idea for a mission trip fit into the Christian Wor yourself? on the worksheet. EXCEL FORMULAS MUST BE USED. Comments on the worksheet. EXCEL FORMULAS MUST BE USED. 1 To prepare for the final Mission Trip project: Comments p project: raded, and you will not hand it in at this time. It is here to help you stay on ject. and financial plan for an overseas mission trip. Please read over the can be prepared when the time comes. At this point in the semester you should hering research to answer the questions below: develop that would help make the world a better place? (In other words, what that assignment?) visit for your trip? Why does this country need the help you can give? ely to incur on the trip? This would be a good time to start making a basic n trip fit into the Christian Worldview and mandate to love your neighbor as