Can You Budget A Family Vacation

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

AttachmentsMajor 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