>Grading Sheet
identified
2 Expenses identified and calculated for the entire group with an Excel formula
9 Expenses identified and calculated for the entire group with an Excel formula
9 9 5
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED. Points Earned Comments 2
4 0 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED. , , 9 , , 9 4 4 ( and )
8 Columns
8 8 0 0 Budget Expenses formula s
Formulas Description numbers Number or NA Formulas Link or citation Description numbers Number or NA Formulas Link or citation Item Qty Price each Total price numbers Number or NA Formulas Link or citation (add rows as needed) Loans number number number number number number number number formula formula formula formula https://www.ncua.gov/analysis/Pages/industry/credit-union-bank-rates.aspx https://www.top10personalloans.com/ https://www.creditkarma.com/shop/personal-loans https://www.nerdwallet.com/ Stats Height : (use the computed mean and standard deviation) Formula Required 1 Frequency formula formula number formula formula auto formula formula formula formula auto formula formula formula formula formula auto formula formula Histogram Here Data 70.3 67.4 70.5 65.2 71.4 68.8 68.4 66.8 64.6 67.5 70.5 69.8 69.7 72.8 71.1 65.1 71.1 68.3
Budget Expenses
Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED.
Points Possible
Points Earned
Comments
Location
Travel Expenses identified and calculated for the entire group with an Excel
formula
9
Lodging
Food
Entertainment Expenses identified and calculated for the entire group with an Excel formula
Total Budget
7
Budget Expenses total
4
0
Loans
Possible Points
PMT Calculation
1
Total cost of Loan
6
Total
Interest Paid
Explain in 25 to 100 words which loan is the best option and why.
8
Question 2 total
30
Stats
Points Possible Points Earned Comments
Mean
Median
Mode
Range
Minimum
Maximum
Standard Deviation
z-Score
Set up of
Bins
Low
High
Formulas
Frequency
Histogram
Stats total
50
Major Assignment 1
Total for Major Assignment 1
125
Location
Input Name Here
Formula Required
Each cell is color coded as indicated to the left. The cell will change to grey after it has been completed.
Number/Text
Transportation
Item
Qty
Price each
Total price
Source
Budget Total:
Description
number
Number or NA
Link or citation
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 (input in Cell D2) and then determine the total costs (for everyone going) – 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):
(Add rows as needed)
Lodging
Item Qty Price each Total price
•Travel expenses, such as plane or bus fare, local travel within the area.
(add rows as needed)
•Lodging expenses. If you plan to camp, you will include expenses for your camping gear.
Food
Item Qty Price each Total price
•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.
(add rows as needed)
Entertainment and Misc.
Numbers
Formula Required
Loans Number/Text
Loan A
Loan B
Principal (P) (same for both loans)
Suppose you all decide you want to finance the trip with a loan. Find two different available offers (the internet is a good source). Make sure the interest rate and loan length are both different in each option. Calculate the monthly payment amount, the total amount you will pay over the life of the loan and the total interest you will pay. NOTE: You can find loan rates on major bank and credit union websites without providing personal information, feel free to use one of the links here.
Loan payment formula: PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t))
PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.
You must use Excel formulas including cell references to calculate the loan payment, total paid and interest paid.
rate ( r)
# of Compoundings per year (n)
time in years (t)
Link to Credit Card Interest Rate Source
Payment (PMT)
NerdWallet
Credit Karma
Total Paid
Top10PersonalLoans
Interest Paid formula formula
Source Link or citation Link or citation
Discuss which loan would be a better option and why: (8 points!)
Data
Input name below to
generate the dataThe Height Data is named height, you may use this name in your formulas.
Using the randomizing data set of 102 heights provided and using Excel formulas with cell references find the following
Descriptive Statistics
• Mean
• Median
• Mode
• Range
• Minimum
• Maximum
• Standard deviation
• The z score for your height
Also, using Excel formulas with cell references complete the following:
• Frequency distribution
• Histogram – Create a Graphical Representation of the Data
Data
Full Name
Data Number/Text
7582
Data Descriptive Statistics
Frequency Distribution
271
Data Mean formula Low High Bins
Cumulative Frequency
5652
Data Median formula formula formula
auto
2517
Data Mode formula formula formula auto formula formula
2506
Data Range formula formula formula auto formula formula
9039
Data Minimum formula formula formula auto formula formula
3784
Data Maximum formula formula formula auto formula formula
2961
Data Standard Deviation formula formula formula auto formula formula
6466
Data
Your height (in inches)
5191
Data z score for your height formula formula formula auto formula formula
6152
Data formula formula auto formula formula
5737
Data
Histogram – Bin width
1230
Data
Bin Width
5591
Data
(remember to create the Histogram, too).
8728
Data
8385
Data
306
Data
4043
Data
7564
Data
3457
Data
1222
Data
7007
Data
5740
Data
5285
Data
7858
Data
6451
Data
3260
Data
3989
Data
7950
Data
8511
Data
5520
Data
7537
Data
3650
Data
8335
Data
9156
Data
6005
Data
8826
Data
211
Data
7100
Data
3037
Data
2186
Data
1475
Data
3500
Data
7369
Data
5870
Data
619
Data
8260
Data
8673
Data
4362
Data
1547
Data
9100
Data
6745
Data
6254
Data
6027
Data
4932
Data
1549
Data
8746
Data
5199
Data
4736
Data
8725
Data
4330
Data
7211
Data
6320
Data
3517
Data
8946
Data
6487
Data
6060
Data
3677
Data
8142
Data
2043
Data
3856
Data
8561
Data
5842
Data
5575
Data
2388
Data
2409
Data
3278
Data
803
Data
3208
Data
4021
Data
2286
Data
2119
Data
8748
Data
4845
Data
3190
Data
7207
Data
7028
Data
6609
Data
2810
Data
1091
Data
7264
Data
1525
Data
3822
Data
5407
Data
4608
Data
3865
Data
2382
Data
3471
Data
7916
Data
5357
Data
4286
Generated Data
67.5
63.3
74.8
72.4
68.1
70.3
65.2
65.8
70.1
70.0
69.3
65.1
71.4
69.2
69.3
67.4
70.7
74.6
70.5
69.0
64.6
68.4
68.8
72.0
66.9
64.3
72.8
75.6
63.7
64.2
67.1
76.1
72.5
68.1
69.6
73.0
67.9
68.3
66.2
66.8
71.6
64.8
69.7
71.2
73.2
67.8
72.5
66.6
68.5
65.5
75.9
57.8
68.1
63.7
66.7
68.9
60.8
74.9
70.0
66.3
62.7
64.4
74.9
67.9
69.8
68.2
61.4
63.0
66.8
71.1
65.0
72.1
70.8
77.5
65.4
61.5
70.9
67.6
73.7
67.7
61.3
70.2
69.9
67.4
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.