Question: Use the Histogram tool to develop a frequency distribution and histogram for the number of months as a customer of the bank in the data
Use the Histogram tool to develop a frequency distribution and histogram for the number of months as a customer of the bank in the data below. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive.
| Loan Purpose | Months Customer |
| Small Appliance | 12 |
| Furniture | 27 |
| New Car | 21 |
| Furniture | 12 |
| Education | 44 |
| Furniture | 11 |
| New Car | 13 |
| Business | 13 |
| Small Appliance | 38 |
| Small Appliance | 28 |
| Business | 51 |
| New Car | 10 |
| Business | 9 |
| New Car | 26 |
| New Car | 12 |
| Used Car | 30 |
| Furniture | 52 |
| New Car | 14 |
| Repairs | 31 |
| Education | 8 |
| Furniture | 34 |
| Furniture | 13 |
| Furniture | 24 |
| Furniture | 41 |
| New Car | 11 |
| Business | 23 |
| Used Car | 19 |
| Used Car | 51 |
| Small Appliance | 34 |
| Small Appliance | 20 |
Complete the frequency distribution for the months as a customer, and compute the relative and cumulative relative frequencies.
(Type integers or decimals rounded to three decimal places as needed.) Please show work- please use excel
| Bins | Frequency | Relative Frequency | Cumulative Relative Frequency |
|---|---|---|---|
| 10 |
|
|
|
| 20 |
|
|
|
| 30 |
|
|
|
| 40 |
|
|
|
| 50 |
|
|
|
| 60 |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
