Please answer directly on the worksheet. also please review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion. Please review scoring chart on first slide of excel. I live in McDowell County, WV and will be traveling to Miami Florida with 6 friends (that should answer the questions needed for assignment). Thank you tremendously!

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

9

the entire group with an Excel formula

Lodging Expenses identified and calculated for

the entire group with an Excel formula

Food Expenses identified and calculated for the

entire group with an Excel formula

Entertainment Expenses identified and

calculated for the entire group with an Excel

formula

Total Budget

Budget Expenses total

9

9

9

7

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

8

best option and why.

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

Location

Transportation

Item

Description

Qty

Price each

numbers Number or NA

Total price

Formulas

Source

Link or citation

Total price

Formulas

Link or citation

Total price

Formulas

Link or citation

(Add rows as needed)

Lodging

Item

Description

Qty

Price each

numbers Number or NA

(add rows as needed)

Food

Item

Description

Qty

Price each

numbers Number or NA

(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

Input Name Here

Formula Required

Number/Text

Budget Total:

Each cell is color coded as indicated to the left. The ce

will change to grey after it has been completed.

formula

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

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

d as indicated to the left. The cell

y after it has been completed.

Formula Required

Number/Text

Loans

Loan A

Principal (P) (same for both loans)

number

rate ( r)

number

# of Compoundings per year (n)

number

time in years (t)

number

Payment (PMT)

formula

Loan B

number

number

number

number

formula

Total Paid

Interest Paid

Source

formula

formula

Link or citation

formula

formula

Link or citation

Suppose you all decide you want to finance

a good source). Make sure the interest rate

monthly payment amount, the total amoun

pay. NOTE: You can find loan rates on maj

information, feel free to use one of the lin

Loan payment formula: PMT = P*(r/n)/(1 –

PMT is the payment required to pay off a lo

You must use Excel formulas including cell

paid.

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

ou all decide you want to finance the trip with a loan. Find two different available offers (the internet is

rce). Make sure the interest rate and loan length are both different in each option. Calculate the

ayment amount, the total amount you will pay over the life of the loan and the total interest you will

E: You can find loan rates on major bank and credit union websites without providing personal

n, feel free to use one of the links here.

ent formula: PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t))

payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.

use Excel formulas including cell references to calculate the loan payment, total paid and interest

er option and why: (8 points!)

Link to Credit Card Inter

NerdWalle

Credit Karm

Top10Personal

Link to Credit Card Interest Rate Source

NerdWallet

Credit Karma

Top10PersonalLoans

Height

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Input name below to

generate the data

Full Name

Formula Required

Number/Text

Descriptive Statistics

Mean

Median

Mode

Range

Minimum

Maximum

Standard Deviation

Your height (in inches)

z score for your height

Bin Width

formula

formula

formula

formula

formula

formula

formula

number

formula

Histogram – Bin width

formula

The Height Data is named height,

use this name in your formu

Low

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

High

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

(remem

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

ght Data is named height, you may

e this name in your formulas.

Frequency Distribution

Bins

Cumulative Frequency

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

auto

formula

(remember to create the Histogram, too).

Histogram Here

Frequency

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

formula

Using the randomizing data set of 102 heig

Excel formulas with cell references find the

Statistics:

• Mean

• Median

• Mode

• Range

• Minimum

• Maximum

• Standard deviation

• The z score for your height (use the com

standard deviation)

Also, using Excel formulas with cell referen

following:

• Frequency distribution

• Histogram – Create a Graphical Represe

andomizing data set of 102 heights provided and using

ulas with cell references find the following Descriptive

n

um

um

rd deviation

core for your height (use the computed mean and

eviation)

Excel formulas with cell references complete the

ncy distribution

am – Create a Graphical Representation of the Data