MATH 144 GCU Budget Expenses For a Family Vacation

User Generated

Puevfglenira

Business Finance

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.

Attachments Major Assignment 1.xlsx
Major Assignment 1.xlsx

Attempt Start Date: 18-Mar-2019 at 12:00:00 AM

Due Date:

24-Mar-2019 at 11:59:59 PM

Here are some video tutorials to help with major assignment 1.

Explanation of the assignment

Calculating monthly payments of a loan

Descriptive Statistics http://mediaplayer.pearsoncmg.com/assets/gtq1e_1_4...

Frequency table and histogram

z-score https://mediaplayer.pearsoncmg.com/assets/gtq1e_3_...

More help with using the countif formula to find the frequency of a region

I also attached the worksheet with a few hints and a PowerPoint explanation. You are welcome to use the attached Excel document for your assignment.


Attached FilesMajor Assignment 1 Explanation.pptx


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

Here you go. In case of any further inputs, please let me know.All the best!I appreciate working with you!

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


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags