Frequency Distribution:

Here is a hypothetical list of the number of caramel popcorn

cans sold in 70 scout troops in Maryland.Use Excel's

capability (=FREQUENCY()) to create a frequency distribution Number of Caramel popcorn cans sold in each troop

170 105 103 105 148 158 121 130 118 157

159 147 132 100 115 192 158 196 149 140

176 199 174 107 179 183 129 194 119 150

198 171 120 151 163 108 184 134 186 175

180 114 107 107 165 137 184 200 189 103

190 175 156 143 142 117 182 126 142 160

183 119 165 134 145 145 184 196 180 113

MIN Use the =MIN() function to find the lowest number of popcorn cans sold.

MAX Use the =MAX() function to find the highest number of popcorn cans sold.

Subtract the lowest number of cans sold from the highest number of cans sold: The range of number of cans sold is:

Decide how many bins to use. Study the data and pick a number between 5 and 10

Now divide the range of the cans sold by the number of bins to find the size that each bin should be

Size of each bin is

Create your bins:

Start with the minimum number of cans sold and add the size of the bins.

Therefore,______ plus _____ is the highest number that the first bin should be ____.

The =FREQUENCY() function uses the highest number of each bin when calculating the number in each bin.

The next bin highest number starts with the first bin's highest number and adds the size of the bins.

Therefore, the second bin begins with___ and adds the bin size____ to get_____

Continue adding to get the Bins array for the =FREQUENCY() function.

Follow the instructions in the youtube videos to use the =FREQUENCY() array function. You know that you have correctly used the =FREQUENCY() function if Excel automatically puts {} around the function.

Min Bins: Frequency:

Max

Some versions of Excel treat the last bin a bit differently, so the FREQUENCY function may show the last bin as one higher than it should be.