MATH

MATH-MODULE-2MajorAssignment1.xlsx

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	9
Lodging Expenses identified and calculated for the entire group with an Excel formula	9
Food Expenses identified and calculated for the entire group with an Excel formula	9
Entertainment Expenses identified and calculated for the entire group with an Excel formula	9
Total Budget	7
Budget Expenses total	45	0
Loans
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
	Possible Points	Points Earned	Comments
PMT Calculation	12
Total cost of Loan	6
Total Interest Paid	4
Explain in 25 to 100 words which loan is the best option and why.	8
Question 2 total	30	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	9
Range, Minimum, Maximum	9
Standard Deviation	4
z-Score	4
Set up of Bins (Low and High Formulas)	8
Frequency Columns	8
Histogram	8
Stats total	50	0
Major Assignment 1
Total for Major Assignment 1	125	0

Budget Expenses

Location

Input Name Here

Formula Required

Each cell is color coded as indicated to the left. The cell will change to grey after it has been completed.

Number/Text

Transportation

Item

Qty

Price each

Total price

Source

Budget Total:

formula

Description

numbers

Number or NA

Formulas

Link or citation

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 (input in Cell D2) and then determine the total costs (for everyone going) - 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):

(Add rows as needed)

Lodging

Item

Qty

Price each

Total price

Description

numbers

Number or NA

Formulas

Link or citation

•Travel expenses, such as plane or bus fare, local travel within the area.

(add rows as needed)

•Lodging expenses. If you plan to camp, you will include expenses for your camping gear.

Food

Item

Qty

Price each

Total price

•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.

Description

numbers

Number or NA

Formulas

Link or citation

•Entertainment or activity expenses and/or miscellaneous expenses that may occur.

(add rows as needed)

Entertainment and Misc.

Item

Qty

Price each

Total price

Numbers

numbers

Number or NA

Formulas

Link or citation

(add rows as needed)

Loans

Formula Required

Loans

Number/Text

Loan A

Loan B

Principal (P) (same for both loans)

number

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: You can find loan rates on major bank and credit union websites without providing personal information, feel free to use one of the links here. 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.

rate ( r)

number

# of Compoundings per year (n)

number

time in years (t)

number

Link to Credit Card Interest Rate Source

Payment (PMT)

formula

NerdWallet

Credit Karma

Total Paid

formula

Top10PersonalLoans

Interest Paid

formula

Source

Link or citation

Discuss which loan would be a better option and why: (8 points!)

https://www.ncua.gov/analysis/Pages/industry/credit-union-bank-rates.aspx https://www.top10personalloans.com/ https://www.creditkarma.com/shop/personal-loans https://www.nerdwallet.com/

Stats

Height Data

Input name below to generate the data

The Height Data is named height, you may use this name in your formulas.

Using the randomizing data set of 102 heights provided and using Excel formulas with cell references find the following Descriptive Statistics: • Mean • Median • Mode • Range • Minimum • Maximum • Standard deviation • The z score for your height (use the computed mean and standard deviation) Also, using Excel formulas with cell references complete the following: • Frequency distribution • Histogram – Create a Graphical Representation of the Data

Data

Full Name

Formula Required

Data

Number/Text

7582

Data

Descriptive Statistics

Frequency Distribution

271

Data

Mean

formula

Low

High

Bins

Cumulative Frequency

Frequency

5652

Data

Median

formula

auto

formula

2517

Data

Mode

formula

auto

formula

2506

Data

Range

formula

auto

formula

9039

Data

Minimum

formula

auto

formula

3784

Data

Maximum

formula

auto

formula

2961

Data

Standard Deviation

formula

auto

formula

6466

Data

Your height (in inches)

number

formula

auto

formula

5191

Data

z score for your height

formula

auto

formula

6152

Data

formula

auto

formula

5737

Data

Histogram - Bin width

formula

auto

formula

1230

Data

Bin Width

formula

auto

formula

5591

Data

(remember to create the Histogram, too).

8728

Data

8385

Data

306

Data

4043

Data

7564

Data

3457

Data

1222

Data

7007

Data

5740

Data

5285

Data

7858

Data

6451

Data

3260

Data

3989

Data

7950

Data

8511

Data

5520

Data

7537

Data

3650

Data

8335

Data

9156

Data

6005

Data

8826

Data

211

Data

7100

Data

3037

Data

2186

Data

1475

Data

3500

Data

7369

Data

5870

Data

619

Data

8260

Data

8673

Data

4362

Data

1547

Data

9100

Data

6745

Data

6254

Data

6027

Data

4932

Data

1549

Data

8746

Data

5199

Data

4736

Data

8725

Data

4330

Data

7211

Data

6320

Data

3517

Data

8946

Data

6487

Data

6060

Data

3677

Data

8142

Data

2043

Data

3856

Data

8561

Data

5842

Data

5575

Data

2388

Data

2409

Data

3278

Data

803

Data

3208

Data

4021

Data

2286

Data

2119

Data

8748

Data

4845

Data

3190

Data

7207

Data

7028

Data

6609

Data

2810

Data

1091

Data

7264

Data

1525

Data

3822

Data

5407

Data

4608

Data

3865

Data

2382

Data

3471

Data

7916

Data

5357

Data

4286

Histogram Here

Data

Generated Data
68.7
66.3
65.8
74.1
65.6
65.6
66.7
70.4
62.5
66.5
73.5
68.7
67.7
70.5
67.1
67.2
68.9
66.1
76.7
75.5
66.2
68.9
59.3
69.4
68.7
73.7
70.7
67.4
69.3
66.9
69.3
68.7
70.4
67.2
71.4
69.8
62.5
72.9
62.5
66.3
59.2
67.6
65.6
66.0
65.3
71.8
69.0
66.1
68.0
66.1
73.4
69.8
68.1
68.8
67.9
68.6
66.5
67.0
70.7
70.3
57.7
65.5
69.2
70.9
71.1
81.4
70.0
63.2
70.6
73.3
63.2
62.1
60.3
67.5
67.6
66.0
63.8
71.5
60.2
69.1
74.3
65.3
71.7
71.6
73.0
71.6
69.0
67.1
61.9
64.5
67.0
73.1
66.6
68.7
60.5
64.0
69.9
62.7
65.2
62.2
68.9
65.4