G
Guest
I am using Microsoft Access 2003,
Histogram is analytical tool in Excel. It makes a grapical interpretation of
arranged set of numbers (in descending/ascending order). If some numbers
appear more than once in the set it counts the frequency of their appearences
and makes an entry in the histogram table or graph. Histogram thus summarises
all instances (different values) and their frequency (how many numbers are
identical) in a set of data (set of numbers).
I would like to know how to summarize the consumption of 1,500,000 customers
when i individually set the intervals of their consumption, example: how many
customers consume between 100 and 150, 151 and 200, 201 and 250 products
(interval is 50 products in this example)...
Histogram is analytical tool in Excel. It makes a grapical interpretation of
arranged set of numbers (in descending/ascending order). If some numbers
appear more than once in the set it counts the frequency of their appearences
and makes an entry in the histogram table or graph. Histogram thus summarises
all instances (different values) and their frequency (how many numbers are
identical) in a set of data (set of numbers).
I would like to know how to summarize the consumption of 1,500,000 customers
when i individually set the intervals of their consumption, example: how many
customers consume between 100 and 150, 151 and 200, 201 and 250 products
(interval is 50 products in this example)...