Average Customer Spending

[Paul Speirs]

I have a column which contains dollar values from say $1.00 to $30.00. I
need a chart to plot in one dollar increments the percentage for each
dollar. For example, if I have 20 values, and there are 5 values which are
between $1.00 and $1.99 then the chart would show 25% for this range.

the column would look like:

$1.20
$5.33
$2.30
$1.90
$2.30

etc


regards,

Paul

 

[Debra Dalgleish]

On the worksheet, e.g. in cells E2:E31, list the numbers 1-30
In cell F1, enter a heading, e.g. Freq
Select the cells to the right of this list, e.g. cell F2:F31
Enter an array formula to calculate the frequency of each number:
=FREQUENCY(INT(A1:A500),E2:E31)
Press Ctrl+Shift+Enter, to array-enter the formula

Create a chart from the frequency headings and data (E1:F31)