For Mathwiz

I need help with Math144

2

>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 1

4 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 6 0

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 2

5

to 100 words which loan is the best option and why.

14
Question 2 total 3

5

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

s

or NA

Lodging
Item Qty Price each Total price

Description numbers Number or NA Formulas Link or citation

Food

Item Qty Price each Total price
Description numbers Number or NA Formulas Link or citation

(add rows as needed)

Item Qty Price each Total price

numbers Number or NA Formulas Link or citation

(add rows as needed)

Budget Total:

Formula

Transportation

Item

Qty

Price each

Total price

Source

Description

number

Number

Formulas

Link or citation

(Add rows as needed)

(add rows as needed)

Entertainment and Misc.

Numbers

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.

Loans

Loans

number number

number number

number number

number number

formula formula

formula formula

formula formula

Source Link or citation Link or citation

Loan A	Loan B
Principal (P) (same for both loans)
rate ( r)
# of Compoundings per year (n)
time in years (t)
Payment (PMT)
Total Paid
Interest Paid

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!)

Stats

Data

Copy from Data ← 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
Copy from Data ←

Low High Bins Cumulative Frequency

Frequency
Copy from Data ←

Formula/Number

Formula/Number

words or formula

Formula Formula

Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula
Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula
Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula
Copy from Data ← Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data Formula/Number Formula/Number words or formula Formula Formula
Copy from Data Formula/Number Formula/Number words or formula Formula Formula
Copy from Data Formula/Number Formula/Number words or formula Formula Formula
Copy from Data Formula/Number Formula/Number words or formula Formula Formula
Copy from Data Formula/Number Formula/Number words or formula Formula Formula

Copy from Data

Descriptive Statistics (remember to create the Histogram, too). Copy from Data Mean Formula
Copy from Data Median Formula
Copy from Data Mode Formula
Copy from Data Range Formula
Copy from Data Minimum Formula
Copy from Data Maximum Formula
Copy from Data Standard Deviation Formula
Copy from Data

Your height

Number
Copy from Data

z score for your height

Formula
Copy from Data

Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data
Copy from Data

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)

Data

72.7

70.6

70.6

69.2

64.6

64.6

69.1
72.9
70.6

71.5
69.2

71.0
67.4

69.4

70.4

74.7

65.5

68.7
75.6
64.0
64.7

65.1

64.9

70.3
75.3
65.5
71.0

66.5
70.9

Generated Data
68.9
72.6
	69.4
		69.2
63.3
	65.1
64.5
	72.7
75.8
70.2
61.9
	64.9
		64.6
74.1
	70.4
68.3
68.2
			70.6
	69.1
69.8
66.0
68.1
	70.9
69.3
	67.4
72.4
72.1
	75.3
	71.5
63.6
65.9
70.8
67.1
	64.7
		71.0
75.0
65.4
66.6
62.8
67.7
	72.9
68.0
71.3
66.3
	75.6
61.7
		65.5
65.8
66.2
63.9
	70.3
72.8
66.4
	66.5
	74.7
63.7
69.9
69.6
73.4
69.0
68.8
	68.7
70.0
68.4
	64.0
70.1
66.9
67.2
68.6
61.6
67.0
67.6
62.6