Histogram

[rajeevbhatt17]

How can one create a Histogram, given the data in an array, and other
parameters (Binsize, Max and Min), without using the frequency funtion
of Excel?

Any help would be appreciated.

Regards,
Rajeev

 

[avi]

hello,

You could use the analysis tool pack add-in provided with Excel, but
it is not very powerful

You should maybe look for an external statistical add-in. There are a
lot of them, even free

Good luck!
Avi

 

[Mike Middleton]

Rajeev -

Try my free Better Histogram add-in, available from www.treeplan.com.

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