Budget expense/Loan/stats ***MUST BE PROFECENT IN EXCEL***

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
	Miami Beach						Budget Total:		$8,094.24
	Transportation
	Item	Qty	Price each	Total price	Source
	Description	numbers	Number or NA	Formulas	Link or citation
	Plane Tickect roundtrip (Non stop Oneworld Airline)	6	$301	$1,806	Fright to Miami
	Uber Taxi (Airport to Resort Beach)	2	$38.64	$77.28	Uber taxi fair
	Daily town service (7 days)	14	$23.88	$334.32	Uber taxi town service
	Uber Taxi (Resort Beach to Airport)	2	$38.64	$77.28	Uber taxi fair
	(Add rows as needed)
	Lodging
	Item	Qty	Price each	Total price
	Description	numbers	Number or NA	Formulas	Link or citation
	Hotel logde ( 3 rooms: 2 adulst/room, $441/night for 7 days) Free breakfast	1	$3,087.00	$3,087.00	Autograph Collection Hotel
	(add rows as needed)
	Food
	Item	Qty	Price each	Total price
	Description	numbers	Number or NA	Formulas	Link or citation
	Groceries ($11.57/day per person) for 7 days	6	$80.99	$485.94	Grocery
	Fruits: Oranges ($1.62/day per person) for 7 days	6	$11.34	$68.04	Grocery
	(add rows as needed)
	Entertainment and Misc.
	Item	Qty	Price each	Total price
	Numbers	numbers	Number or NA	Formulas	Link or citation
	North Bay Village (Uber taxi) 2nd day	3	$29.52	$88.56	Uber taxi to North Bay Village
	Marlins Tickets - 3rd day	6	$31.76	$190.56	Marlins Tickets
	Miami Dolphins Tickets - 4th day	6	$86.36	$518.16	Miami Dolphins Tickets
	Miami's famous Art Basel (Combined) - 5th day	6	$75.00	$450.00	Miami Art Basel
	Miami's cultural spot (Calle Ocho) - 6th day	6	$1.85	$11.10	Calle Ocho
	Miscelleneous Expenses	6	$150.00	$900.00
	(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.google.com/travel/explore?tfs=CBsQAxooagwIAxIIL20vMGN5OHYSCjIwMjAtMDItMTdyDAgEEggvbS8wMnhyeRooagwIBBIIL20vMDJ4cnkSCjIwMjAtMDItMjFyDAgDEggvbS8wY3k4dnABQAFIAQ&curr=USD&gl=us&hl=en&authuser=0&origin=https%3A%2F%2Fwww.google.com&dest_mid=%2Fm%2F0f2v0&mvb=ChIJ0t51IVKjRUARIKpiwisrT8ASEgksDGetFLgmQBGIqphYzA1gwA https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Airport+Metrobus+Station%2C+3900+NW+25th+St%2C+Miami%2C+Florida+33142%2C+United+States&to=Miami+Beach+Resort+%26+Spa%2C+4833+Collins+Ave%2C+Miami+Beach%2C+Florida+33140%2C+United+States&fromCoord=25.797876,-80.25897&toCoord=25.824,-80.121844 https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Beach%2C+Florida%2C+United+States&to=Miami%2C+Florida%2C+United+States&fromCoord=25.7881,-80.1273&toCoord=25.7743,-80.1937 https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Airport+Metrobus+Station%2C+3900+NW+25th+St%2C+Miami%2C+Florida+33142%2C+United+States&to=Miami+Beach+Resort+%26+Spa%2C+4833+Collins+Ave%2C+Miami+Beach%2C+Florida+33140%2C+United+States&fromCoord=25.797876,-80.25897&toCoord=25.824,-80.121844 https://www.marriott.com/search/findHotels.mi https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Beach%2C+Florida%2C+United+States&to=North+Bay+Village%2C+Florida%2C+United+States&fromCoord=25.7881,-80.1273&toCoord=25.8462,-80.1539 https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami

Loans

	Loans
		Loan A	Loan B
	Principal (P) (same for both loans)	$8,094.24	$8,094.24
	rate ( r)	12%	8.99%
	# of Compoundings per year (n)	12	12
	time in years (t)	1	1
	Payment (PMT)	$719.16	$707.82
	Total Paid	$8,629.96	$8,493.79
	Interest Paid	$535.72	$399.55
	Source	First Eagle	Freedomcu.org

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!) The personal loan from Freedom bank (loan B) is the best option for us. The loan has a lower annual interest rate (APR) of at minimum 8.99% and a maximum of 17.99% with good credit ratings. Since the APR is lowere, th PMT is affordable ($707.82) per month and compared to First Eagle bank. Finally, the total intest paid for the loan is cheaper than loan A by more that $135. Hence, loan B is better for our vacation finance

https://www.firsteaglefcu.com/vacation-loans/ https://www.freedomcu.org/rates/rates.html

Stats

Data						Interval	1.5
67.5	←	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.4	←				Low	High	Bins	Cumulative Frequency	Frequency
71.3	←				60.8	62.3	60 .8 - 62.2	3.0	3
70.8	←				62.3	63.9	62.3 - 63.8	9.0	6
70.1	←				63.9	65.4	63.9 - 65.3	17.0	8
66	←				65.4	66.9	65.4 - 66.8	32.0	15
69	←				66.9	68.4	66.9 - 68.3	47.0	15
72.1					68.4	70.0	68.4 - 69.9	64.0	17
66.4					70.0	71.5	70.0 - 71.4	80.0	16
65.5					71.5	73.0	71.5 - 72.9	90.0	10
70.6					73.0	74.5	73.0 - 74.4	94.0	4
73.2					74.5	76.1	74.5 - 76.0	100.0	6
63.8					76.1	77.6	76.1 - 77.6	102.0	2
70.2		Descriptive Statistics			(remember to create the Histogram, too).
70.2		Mean	68.8480392157
75.3		Median	69.05
64.6		Mode	68.1
68.1		Range	16.8
64.2		Minimum	60.8
66.6		Maximum	77.6
64.2		Standard Deviation	3.5741849557
60.8		Your height	70
71		z score for your height	0.9324836323
64.6
66.7
68.5
71.7
71.3
67.7
71.7
68
69.4
66.6
70.6
67.6
70.8
64
64.1
69.3
68.1
66.7
71
67
72.1
66
68.4
67.5
72
67.8
70.2
77.6
68.1
76
61.9
63.9
65.7
63.9
77.3
73.3
61.9
66.9
74.2
71.7
68.1
62.6
69.6
69.8
74.4
70.7
69.8
68.3
72.9
68.9
69.7
66.7
71.7
74.8
69.1
63.2
69.1
70.5
69.1
75
69.3
69.7
68.3
63.8
66.7
69.6
68.1
69.8
70.1
63.4
75.4
65.8
66.8
75.5
70.4
68.6
66.2
63.3
72

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)

Distribution of the Heights of Students in Math 144

Frequency 60 .8 - 62.2 62.3 - 63.8 63.9 - 65.3 65.4 - 66.8 66.9 - 68.3 68.4 - 69.9 70.0 - 71.4 71.5 - 72.9 73.0 - 74.4 74.5 - 76.0 76.1 - 77.6 3 6 8 15 15 17 16 10 4 6 2

Height of the Students

Number of Students (Frequency)

Data

Generated Data
70.9
65.8
73.0
70.2
66.3
65.4
69.2
69.7
69.8
69.7
68.3
73.2
67.3
67.9
70.1
70.1
68.3
69.6
74.9
69.2
61.8
66.6
59.4
61.9
73.9
69.1
73.6
68.1
67.5
63.9
71.0
68.4
75.5
67.6
65.0
73.8
66.4
68.2
66.0
70.8
69.1
67.6
57.9
70.1
69.0
63.2
68.7
64.9
67.6
71.1
65.7
62.5
68.3
66.8
65.1
71.8
66.9
64.4
68.0
62.5
72.3
75.6
69.7
57.5
74.4
63.7
66.6
65.8
68.4
65.5
68.8
66.0
68.2
66.2
66.7
63.1
66.9
65.4
66.2
69.3
66.0
67.5
64.7
66.1
66.8
63.4
65.3
62.7
71.2
61.2
64.5
63.5
66.9
74.7
72.4
68.2
66.9
71.2
68.8
74.9
65.9
73.4