Thread: curves
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default curves

PAL -

If you want to disregard the product name, you could first develop a
frequency distribution using several COUNTIF worksheet functions, or an
array-entered FREQUENCY function, or a pivot table. Then you could plot the
frequency results as a histogram using a Column chart type.

Or, you could use the Histogram tool of Excel's Analysis ToolPak; see
Excel's Help. Or, you could use my free Better Histogram add-in, available
from the Histogram page at www.treeplan.com.

If you want a separate distribution for each product, then you could sort
first, or you could use a pivot table.

It may turn out that the histgram (chart of the frequency distribution) has
a bell-curve shape. Or not.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"PAL" wrote in message
...
I have about 100 rows of data, 2 columns. Column A has names of products,
Column B has the number of days it took to sell them. I would like to
look
at the distribution:

Y axis, frequency of days
X axis, the number of days

I guess that is a bell curve. Ideas?

Thanks.