Question

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 all observations (1.5,2.2,...) and one with the lower limits. Delete the lowest number in the lower limit column. This is your bin column

.Exercise 5f: In the Excel Data Toolpak, choose histogram. Enter the numbers and the bins. Show the chart in your homework

Exercise 5g: Compare with the manual chart

Answer 1

What is the recommend number of classes for 1.5, 2.2, 3.4,3.4,3.4 ,4.5, 5.1?

Class Intercal

1.5～2.2

2.2～2.9

2.9～3.7

3.7～4.4

4.4～5.1

What is a good class width?

Maximum value of the data minus minumum value of the data , divided by interval count

Maximum value is 5.1

Minumum value id 1.5

CLass interval is 5

so (5.1-1.5)/5 = 0.72

Give the frequency distribution

Make a list of the lower limits of all classes

1.5

2.2

2.9

3.7

4.4

ake two columns in Excel, one with all observations (1.5,2.2,...) and one with the lower limits. Delete the lowest number in the lower limit column. This is your bin column

1.5 is the lowest vale of bin. so that has been deleted

In the Excel Data Toolpak, choose histogram. Enter the numbers and the bins. Show the chart in your homework

Compare with the manual chart

select class and bin and create a stacked 2D column chart and again select bin values separately and choose the line chart to compare the chart results.