Question

Create a frequency table and a histogram for each of the data sets from Part 2. Below are two links explaining how to use Excel to create frequency tables and histrograms. Using Excel for Data and Tables Create a Histogram From a Frequency Table 1) Data Set 1: 23, 26, 50, 39, 55, 64, 50, 10, 42, 35, 51, 42, 43, 56, 64, 48, 48, 57, 27, 37 a. List the data values in order from lowest to highest. b. Find n, the number of data values. c. Find the width for a frequency distribution with 5 classes of equal width. d. Create a frequency distribution table. e. Add up the frequencies from part (d). Do they sum to the sample size? f. Create a histogram. 2) Data Set 2: 26, 31, 10, 37, 38, 35, 30, 24, 26, 27, 24, 32, 32, 19, 34, 33, 14, 32, 24, 39, 30 a. List the data values in order from lowest to highest. b. Find n, the number of data values. c. Find the width for a frequency distribution with 6 classes of equal width. d. Create a frequency distribution table. e. Add up the frequencies from part (d). Do they sum to the sample size? f. Create a histogram.

Answer 1

1.

a. From the above image, you can see that the data are arranged in lowest to highest.

b.The number of data values are=20

c.The width for the frequency distribution of 5 classes of equal width is 12.

d.From the above image, you can see the frequency distrbution table along with data, bins, frequency and interval.

e. After adding up the frequencies, you can get 20 i.e the sample size of the data.

f. The histogram is given below:

2.

a. From the above image, you can see that the data are arranged in lowest to highest.

b.The number of data values are=21

c.The width for the frequency distribution of 5 classes of equal width is 5.

d.From the above image, you can see the frequency distrbution table along with data, bins, frequency and interval.

e. After adding up the frequencies, you can get 21 i.e the sample size of the data.

f. The histogram is given below: