MAT144 Grand Canyon UniversityBudget Expenses Worksheet 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. 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

formula

formula

Interest Paid

Source

formula

Link or citation

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

69.0

73.4

57.7

67.5

63.2

69.7

70.6

66.1

64.0

75.6

62.6

72.8

69.0

73.6

66.3

63.0

59.8

64.3

67.5

73.7

69.5

69.2

69.1

65.7

70.2

71.1

67.3

68.3

68.1

70.2

65.1

62.0

74.2

66.4

71.0

74.8

68.8

74.2

63.5

69.5

68.6

63.0

67.7

62.2

64.1

61.4

67.0

67.6

68.3

64.9

68.8

67.9

64.2

71.7

68.4

66.3

72.8

69.8

67.1

62.8

66.3

67.8

69.3

66.4

69.1

66.1

69.2

73.0

70.8

63.4

69.4

69.5

67.3

70.4

70.5

68.1

61.7

72.7

64.9

72.7

68.9

70.8

61.8

72.8

75.0

65.2

70.7

65.9

74.2

67.8

65.3

69.8

64.0

64.7

73.0

62.3

68.8

74.3

61.6

66.0

68.4

64.4

Purchase answer to see full

attachment

Don't use plagiarized sources. Get Your Custom Essay on

MAT144 Grand Canyon UniversityBudget Expenses Worksheet Answer directly on the worksheet. This assignment uses a scoring guide. Review the scoring guide on

Just from $13/Page

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

Try it now!

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.

Essays

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.