Exercise 5a: What is the recommend number of classes for 1.5,2.2, 3.4,3.4,3.4 ,4.5, 5.1?
Exercise 5b: What is a good class width?
Exercise 5c: Give the frequency distribution.
Exercise 5d. Make a list of the lower limits of all classes
Exercise 5e: Make two columns in Excel, one with allobservations (1.5,2.2,...) and one with the lower limits. Deletethe lowest number in the lower limit column. This is your bincolumn
.Exercise 5f: In the Excel Data Toolpak, choose histogram. Enterthe numbers and the bins. Show the chart in your homework
Exercise 5g: Compare with the manual chart