YASAIw Suggestion: Add Option for Relative Frequency in Histogram Chart

21 views
Skip to first unread message

minttr...@gmail.com

unread,
Oct 4, 2015, 4:21:59 PM10/4/15
to yasai-simulation
Currently when I create a histogram, the chart uses frequency data. What I would like is to graph the relative frequency data (in percent) instead of the frequency data to see the probability distribution of simulated outcomes.

I've been converting the frequency data into relative frequency data each and many times to generate new probability distribution histogram charts. So, my suggestion is to add two options in the "YASAI Charts" options for: (1) Histogram - Relative Frequency and (2) Histogram - Percent Frequency

(1) Histogram - Relative Frequency uses decimal as relative frequency unit in the Y-axis.
(2) Histogram - Percent Frequency uses percentage as relative frequency unit in the Y-axis (see attached example).


MC Simulation--Portfolio Returns.xlsx

Jonathan Eckstein

unread,
Oct 4, 2015, 9:44:06 PM10/4/15
to yasai-si...@googlegroups.com
I agree that percent or relative frequency would be a preferable Y-axis
scale than sample counts. I will put this on the to-do list, perhaps
not as an option but as the default. I don't know if two different
options are needed for percent or relative, though -- once a graph with
percent or relative frequency has been produced, it would be easy to
switch to the other by doing a format operation on the vertical axis scale.

-- Prof. Eckstein
> --
> You received this message because you are subscribed to the Google
> Groups "yasai-simulation" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to yasai-simulati...@googlegroups.com
> <mailto:yasai-simulati...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages