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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!