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

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
Interest Paid
Source
formula
formula
Link or citation
formula
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
66.3
69.1
62.4
72.8
69.1
69.2
70.1
68.2
65.7
66.5
65.1
61.8
74.7
63.4
63.6
68.6
67.4
71.2
69.3
67.8
63.0
73.1
77.6
66.9
70.0
71.7
73.3
66.8
65.1
67.2
70.3
69.8
73.2
72.4
71.3
69.9
71.1
68.0
67.1
62.1
70.9
70.0
66.9
57.0
64.9
65.0
67.8
71.9
63.3
70.9
64.4
68.7
70.0
65.3
58.7
64.6
76.2
66.6
72.9
66.1
63.6
68.4
63.6
71.5
66.9
63.3
66.3
70.3
70.4
71.6
68.9
64.5
65.5
65.2
75.8
65.7
68.4
68.1
70.1
61.5
69.8
64.2
66.9
72.1
75.7
69.2
68.8
66.6
71.7
69.4
71.7
65.1
62.4
67.8
64.5
70.2
69.4
66.4
68.2
68.4
66.1
73.5

Purchase answer to see full
attachment