MAT144 Grand Canyon UniversityBudget Expenses Worksheet

User Generated

YTTnynkl

Other

MAT144

Grand Canyon University

Description

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.

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 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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Surname 1
Name:
Instructor:
Course:
Date:
Worksheet
The attached Excel worksheet addresses the question “Worksheet” as follows:
1. Budget expense
2. Loans
3. Stats


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

Transportation
Item
Description
Flight
Mini Van rent...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags