Answer directly on the worksheet. This assignment uses a scoring guide. Review the scoring guide on the last tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion.

major_assignment_1.xlsx

Unformatted Attachment Preview

Budget Expenses

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

Points Possible

Location identified

Travel Expenses identified and calculated for

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

Question 1 total

Points Earned

Comments

2

14

14

14

14

2

60

0

Loans

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

Possible Points

Calculations for both loans are correct

Explain in 25 to 100 words which loan is the

best option and why.

Question 2 total

Points Earned

Comments

21

14

35

0

Stats

Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.

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

Comments

Location

Transportation

Item

Description

Qty

Price each

numbers Number or NA

Total price

Formulas

Source

Link or citation

(Add rows as needed)

Lodging

Item

Description

Qty

Price each

numbers Number or NA

Total price

Formulas

Link or citation

Total price

Formulas

Link or citation

(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

You are going on a drea

are taking a math cours

much it will cost each o

the total costs

expense list must inclu

paid trip)

Budget Total:

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

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 financ

offers (the internet is a good source

different in each option. Calculate the mo

over the life of the loan and the total inte

information on the internet. You can find

without providing personal information.

Loan payment formula:

PMT is the payment required to pay off

You must use Excel formulas including ce

paid and interest paid.

Discuss which loan would be a b

you all decide you want to finance the trip with a loan. Find two different available

e internet is a good source). Make sure the interest rate and loan length are both

in each option. Calculate the monthly payment amount, the total amount you will pay

life of the loan and the total interest you will pay. NOTE: Do not provide personal

ion on the internet. You can find loan rates on major bank and credit union websites

providing personal information.

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

the payment required to pay off a loan of $P at interest rate, r%, compounded n times

per year for t years.

t use Excel formulas including cell references to calculate the loan payment, total

interest paid.

s which loan would be a better option and why: (14 points!)

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

Descriptive Statistics

Mean

Median

Mode

Range

Minimum

Maximum

Standard Deviation

Your height

z score for your height

Frequency Distribut

Low

High

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

Formula/Number

(remember to create the Hist

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Number

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

Frequency Distribution

Bins

Cumulative Frequency

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

words or formula Formula

(remember to create the Histogram, too).

Frequency

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Formula

Using the data set of 102 random heights provided us

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

om heights provided use

eight (use the computed

Generated Data

66.3

69.1

62.4

72.8

69.1

69.2

70.1

68.2

65.7

66.5

65.1

61.8

74.7

63.4

63.6

68.6

67.4

71.2

69.3

67.8

63.0

73.1

77.6

66.9

70.0

71.7

73.3

66.8

65.1

67.2

70.3

69.8

73.2

72.4

71.3

69.9

71.1

68.0

67.1

62.1

70.9

70.0

66.9

57.0

64.9

65.0

67.8

71.9

63.3

70.9

64.4

68.7

70.0

65.3

58.7

64.6

76.2

66.6

72.9

66.1

63.6

68.4

63.6

71.5

66.9

63.3

66.3

70.3

70.4

71.6

68.9

64.5

65.5

65.2

75.8

65.7

68.4

68.1

70.1

61.5

69.8

64.2

66.9

72.1

75.7

69.2

68.8

66.6

71.7

69.4

71.7

65.1

62.4

67.8

64.5

70.2

69.4

66.4

68.2

68.4

66.1

73.5

…

Purchase answer to see full

attachment