IGI investment company is based in Amsterdam, the Netherland. It manages investment portfolio of its clients stemming from different races, occupations, and age groups. Recently, the company performed a research study regarding the size of online investment portfolios of its clients. The investment portfolio is consisting of stocks, bonds, mutual funds, and certificate of deposits. Through a research study, the company collected a sample of clients in the age group of 40 up to 50 years old. The value of all the investments is shown in thousands of dollars for the collected 70 participants in the study is given below:
669.9
295.7
43.4
35.7
23.9
82
107.5
185.4
526.3
301.9
7.5
437
212.3
154.9
352.8
227
82.9
63
136.4
235.4
77.2
87.8
243.3
174.3
156.7
321.1
403.4
380.7
616.9
716.4
7.5
302.1
315.4
100.6
276.3
23.5
228.6
3.3
440.6
145.3
125.7
268.1
5.9
236.7
171.9
39.5
308.7
363.2
408.2
26.6
516.9
899.5
1002.2
171.7
31.3
124.3
126.7
51.9
34.4
187.2
219.9
645.2
221.1
301.2
118.1
430.3
52.2
296.1
315.5
89.2
Q1) Using the data set, create a frequency distribution.
Q2) How many classes would you suggest?
Q3) What value would you suggest for a class interval?
Q4) Draw a histogram of the data.
Q5) The IGI company's financial experts suggest that this age group of people have at least five times their salary saved. If an investment portfolio of 500,000 is assumed as a benchmark that would support retirement in 10-15 years. Summarize your results in writing.