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