Budget expense/Loan/stats ***MUST BE PROFECENT IN EXCEL***
See attachment for more details….
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):
•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.
>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 63.7 67.0 70.5 67.0 66.1 67.8 70.2 66.8 69.0 62.7 70.1 72.8 68.8 73.1 70.7 66.7 66.8 69.8 >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 >Grading Sheet
identified
2 Expenses identified and calculated for the entire group with an Excel formula
Expenses identified and calculated for the entire group with an Excel formula
14 14 2 0 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED. Points Earned Comments to 0 words which loan is the best option and why.
14 5
0 Requirements: Answer each question fully. Answers must be recorded on the worksheet. EXCEL FORMULAS MUST BE USED. , , 6 , , 3 4 Distribution
6 6 5 0 5
0 Budget Expenses ,094.24
6 2 14 2 $38.64 $77.28 Uber taxi fair Description numbers Number or NA Formulas Link or citation 1 $3,087.00 Item Qty Price each Total price 7/day per person) for 7 days
6 6 .04
Grocery (add rows as needed) Item Qty Price each Total price numbers Number or NA Formulas Link or citation 3 – 3rd day
6 Marlins Tickets – 4th day
6 Miami Dolphins Tickets 6 .00
) – 6th day
6 Calle Ocho 6 0.00
(add rows as needed) 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) https://www.google.com/travel/explore?tfs=CBsQAxooagwIAxIIL20vMGN5OHYSCjIwMjAtMDItMTdyDAgEEggvbS8wMnhyeRooagwIBBIIL20vMDJ4cnkSCjIwMjAtMDItMjFyDAgDEggvbS8wY3k4dnABQAFIAQ&curr=USD&gl=us&hl=en&authuser=0&origin=https%3A%2F%2Fwww.google.com&dest_mid=%2Fm%2F0f2v0&mvb=ChIJ0t51IVKjRUARIKpiwisrT8ASEgksDGetFLgmQBGIqphYzA1gwA https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Airport+Metrobus+Station%2C+3900+NW+25th+St%2C+Miami%2C+Florida+33142%2C+United+States&to=Miami+Beach+Resort+%26+Spa%2C+4833+Collins+Ave%2C+Miami+Beach%2C+Florida+33140%2C+United+States&fromCoord=25.797876,-80.25897&toCoord=25.824,-80.121844 https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Beach%2C+Florida%2C+United+States&to=Miami%2C+Florida%2C+United+States&fromCoord=25.7881,-80.1273&toCoord=25.7743,-80.1937 https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Airport+Metrobus+Station%2C+3900+NW+25th+St%2C+Miami%2C+Florida+33142%2C+United+States&to=Miami+Beach+Resort+%26+Spa%2C+4833+Collins+Ave%2C+Miami+Beach%2C+Florida+33140%2C+United+States&fromCoord=25.797876,-80.25897&toCoord=25.824,-80.121844 https://www.marriott.com/search/findHotels.mi https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami https://www.taxifarefinder.com/main.php?city=SD&from=Miami+Beach%2C+Florida%2C+United+States&to=North+Bay+Village%2C+Florida%2C+United+States&fromCoord=25.7881,-80.1273&toCoord=25.8462,-80.1539 https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami Loans $8,094.24 $8,094.24 12 12 1 1 9.16
7.82
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: Do not provide personal information on the internet. You can find loan rates on major bank and credit union websites without providing personal information. .99% with good credit ratings. Since the APR is lowere, th PMT is affordable ($707.82) per month and compared to First Eagle bank. Finally, the total intest paid for the loan is cheaper than loan A by more that $135. Hence, loan B is better for our vacation finance https://www.firsteaglefcu.com/vacation-loans/ https://www.freedomcu.org/rates/rates.html Stats 1.5 .5
Frequency Distribution ← Frequency ← 3 ← 62.3 6 ← 63.9 8 ← 65.4 15 ← 66.9 15 68.4 17 70.0 16 71.5 10 73.0 4 74.5 6 2 480392157
Median 5
Mode Minimum 60.8 Maximum 70 71.7 68.1 77.6 63.9 61.9 71.7 69.8 66.7 69.1 69.1 69.3 66.7 72 Using the data set of 102 random heights provided use Excel formulas to find the following: Distribution of the Heights of Students in Math 144
Frequency 60 .8 – 62.2 62.3 – 63.8 63.9 – 65.3 65.4 – 66.8 66.9 – 68.3 68.4 – 69.9 70.0 – 71.4 71.5 – 72.9 73.0 – 74.4 74.5 – 76.0 76.1 – 77.6 3 6 8 15 15 17 16 10 4 6 2 Height of the Students Number of Students (Frequency) Data 65.8 70.2 69.7 70.1 69.2 66.6 61.9 69.1 68.1 68.4 70.8 70.1 63.2 67.6 65.7 68.3 66.9 62.5 69.7 74.4 66.6 66.0 66.9 66.8 66.9 68.2
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.
Bali
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
70.9
70.7
72.8
61.3
63.7
73.7
70.5
64.8
71.0
70.8
68.1
66.3
61.4
70.1
69.0
68.6
65.7
61.9
66.6
67.3
63.2
73.1
67.0
66.7
62.9
67.2
59.6
71.1
68.1
68.8
65.3
70.2
66.1
67.9
73.6
71.3
69.1
68.3
71.4
67.8
61.2
69.7
71.7
61.8
73.5
65.1
66.8
72.7
76.4
69.2
68.4
69.6
68.9
66.2
68.2
70.0
69.8
62.7
69.3
60.6
71.9
68.4
75.8
70.7
65.4
72.3
70.8
66.6
70.9
67.7
74.8
63.0
72.9
70.5
68.0
72.4
71.7
75.5
67.5
68.5
64.9
73.3
71.6
67.2
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
2
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
1
4
Lodging
14
Food
Entertainment Expenses identified and calculated for the entire group with an Excel formula
Total Budget
Question 1 total
6
0
Loans
Possible Points
Calculations for both loans are correct
21
Explain in 2
5
10
Question 2 total
3
Stats
Points Possible Points Earned Comments
Mean
Median
Mode
Range
Minimum
Maximum
Standard Deviation
Frequency
Histogram
z-Score
Question 3 total
30
Worksheet 1
Total for Worksheet 1
12
Location
Miami Beach
Budget Total:
$
8
Transportation
Item
Qty
Price each
Total price
Source
Description
numbers
Number or NA
Formulas
Link or citation
Plane Tickect roundtrip (Non stop Oneworld Airline)
$301
$1,806
Fright to Miami
Uber Taxi (Airport to Resort Beach)
$38.
64
$77.28
Uber taxi fair
Daily town service (7 days)
$23.88
$334.32
Uber taxi town service
Uber Taxi (Resort Beach to Airport)
(Add rows as needed)
Lodging
Item Qty Price each Total price
Hotel logde ( 3 rooms: 2 adulst/room, $441/night for 7 days) Free breakfast
$3,087.00
Autograph Collection Hotel
(add rows as needed)
Food
Description numbers Number or NA Formulas Link or citation
Groceries ($1
1.5
$80.99
$485.94
Grocery
Fruits: Oranges ($1.62/day per person) for 7 days
$11.34
$
68
Entertainment and Misc.
Numbers
North Bay Village (Uber taxi) 2nd day
$29.52
$88.56
Uber taxi to North Bay Village
Marlins Tickets
$31.
76
$190.56
Miami Dolphins Tickets
$86.36
$518.
16
Miami’s famous Art Basel (Combined) – 5th day
$
75
$450.00
Miami Art Basel
Miami’s cultural spot (
Calle Ocho
$1.85
$11.10
Miscelleneous Expenses
$
15
$900.00
• 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.
https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami
https://smartasset.com/mortgage/whats-the-cost-of-living-in-miami
Loans
Loan A
Loan B
Principal (P) (same for both loans)
rate ( r)
12%
8.99%
# of Compoundings per year (n)
time in years (t)
Payment (PMT)
$
71
$
70
Total Paid
$8,629.96
$8,493.79
Interest Paid
$535.
72
$399.55
Source
First Eagle
Freedomcu.org
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.
Discuss which loan would be a better option and why: (14 points!)
The personal loan from Freedom bank (loan B) is the best option for us. The loan has a lower annual interest rate (APR) of at minimum 8.99% and a maximum of 17
Data
Interval
67
←
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.
72.4
Low
High
Bins
Cumulative Frequency
71.3
60.8
62.3
60 .8 – 62.2
3.0
70.8
63.9
62.3 –
63.8
9.0
70.1
65.4
63.9 –
65.3
17.0
66
66.9
65.4 –
66.8
32.0
69
68.4
66.9 –
68.3
47.0
72.1
70.0
68.4 – 69.9
64.0
66.4
71.5
70.0 – 71.4
80.0
65.5
73.0
71.5 –
72.9
90.0
70.6
74.5
73.0 –
74.4
94.0
73.2
76.1
74.5 – 76.0
100.0
63.8 76.1
77.6
76.1 – 77.6
102.0
70.2
Descriptive Statistics
(remember to create the Histogram, too).
70.2 Mean
68.8
75.3
69.0
64.6
68.1
68.1 Range
16.8
64.2
66.6
77.6
64.2 Standard Deviation
3.5741849557
60.8
Your height
71
z score for your height
0.9324836323
64.6
66.7
68.5
71.7
71.3
67.7
68
69.4
66.6
70.6
67.6
70.8
64
64.1
69.3
66.7 71
67
72.1
66
68.4
67.5
72
67.8
70.2
68.1 76
61.9
63.9
65.7
77.3
73.3
66.9
74.2
68.1
62.6
69.6
69.8
74.4
70.7
68.3
72.9
68.9
69.7
71.7
74.8
69.1
63.2
70.5
75
69.7
68.3 63.8
69.6
68.1
69.8
70.1
63.4
75.4
65.8
66.8
75.5
70.4
68.6
66.2
63.3
Mean
Median
Mode
Range
Minimum
Maximum
Standard deviation
Frequency distribution
Histogram
The z score for your height (use the computed mean and standard deviation)
Generated Data
70.9
73.0
66.3
65.4
69.2
69.8
69.7
68.3 73.2
67.3
67.9
70.1
68.3
69.6
74.9
61.8
59.4
73.9
73.6
67.5
63.9
71.0
75.5
67.6
65.0
73.8
66.4
68.2
66.0
69.1
67.6
57.9
69.0
68.7
64.9
71.1
62.5
66.8
65.1
71.8
64.4
68.0
72.3
75.6
57.5
63.7
65.8
68.4 65.5
68.8
68.2
66.2
66.7
63.1
65.4
66.2
69.3
66.0
67.5
64.7
66.1
63.4 65.3
62.7
71.2
61.2
64.5
63.5
74.7
72.4
66.9
71.2
68.8
74.9
65.9
73.4