gcu MATh144 worksheet 1

Question # 00561241 Posted By: neil2103 Updated on: 07/14/2017 01:22 PM Due on: 07/14/2017
Subject Mathematics Topic Algebra Tutorials:
Question
Dot Image

Question 1

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

Points Possible

Points Earned

Comments

Location identified

4

Travel Expenses identified and calculated for the entire group with an Excel formula

14

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

Question 1 total

60

0

Question 2

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

14

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

21

Question 2 total

35

0

Question 3

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

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.

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.

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

Dot Image
Tutorials for this Question
  1. Tutorial # 00558776 Posted By: neil2103 Posted on: 07/14/2017 01:23 PM
    Puchased By: 4
    Tutorial Preview
    The solution of gcu MATh144 worksheet 1...
    Attachments
    xlsx.xlsx (32.19 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    jeni...rson Rating Happy with tutors efficiency 05/22/2018
    RV...ino1 Rating Instant response from the tutors 08/14/2017

Great! We have found the solution of this question!

Whatsapp Lisa