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 rating: 100% (QA)

1 I have attached a snap of excel in which you can find your answers of 1 st question bn2... View the full answer