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

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final 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...

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors