For helping me , I do not have much practice with excel yet, I'm looking to make a histogram with the following information: input data (column sum), and bin (column with range value)
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
SUM | BIN |
272 | 100-109 |
172 | 110-119 |
218 | 120-129 |
210 | 130-139 |
0 | 140-149 |
189 | 150-159 |
115 | 160-169 |
171 | 170-179 |
235 | 180-189 |
0 | 190-199 |
195 | 200-209 |
293 | 210-219 |
177 | 220-229 |
279 | 230-239 |
0 | 240-249 |
95 | 250-259 |
194 | 260-269 |
101 | 270-279 |
166 | 280-289 |
0 | |
164 | |
158 | |
224 | |
151 | |
0 | |
148 | |
207 | |
268 | |
229 | |
0 | |
130 | |
155 | |
103 | |
119 | |
0 | |
107 | |
133 | |
191 | |
225 | |
0 | |
188 | |
133 | |
187 | |
190 | |
0 | |
239 | |
145 | |
190 | |
175 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>