Re: How to save advanced-filter settings (fwd)

On 15-04-14 08:38 AM, Bob wrote:
OK, I see part of the problem is over the meaning of "histogram".
Everywhere except in spreadseets it means a graphical display. So I
started by clicking on the graphical display icon.  If I go your route
I do not get a graphical display, I get a frequency table (with really
weird bin boundaries).
One of the things I suggested is that in the dialog on the "Graphs & Options" tab you ask for the kind of chart you want. Apparently you asked for "No chart" so you got no chart.


  Here is a nice implementation of histograms in
the free Stats Homework software:

If it seems like the dialog box is missing it is because at the first
step you get a draft histogram automatically and the dialog consists
of buttons to edit the default. So it takes one menu choice (which is
not at the end of a long trail) to get A histogram.  And to edit the
draft you can start by just asking for more or fewer bins.  You do not
need to compute the max. or min. of your data nor compute the bins

The reason I fuss about this is that one should never do statistical
analysis on any data without first making an appropriate display so
you can see any problems that might exist.  Excel makes it really hard
to do that.  gnumeric makes it a little easier, and it makes boxplots,
but it could be a LOT easier for beginners.

Forwarded message:
 From aguelzow pyrshep ca Mon Apr 13 09:52:59 2015
To: gnumeric-list gnome org, bob statland org

Le dimanche 12 avril 2015 =C3=A0 19:30 -0400, Bob a =C3=A9crit :
In gnumeric it should be easier;-) (I actually can't figure out how to
do it in gnumeric but I think you have to chose a lot of things
Minitab and R will chose automatically [while still allowing you to
override anything] What I would like is to highlight the (unbinned)
data and select "histogram" from the graph menu and immediately see a
We are not that far away from this:

1) highlight the unbinned data
2) select Statistics->DescriptiveStatistics->FrequencyTables->Histogram
3) On the 'cut-off' tab select "calculated cutoffs" and enter the number=20
of bins desired.
4) On the "Graphs and Options" tabs select the type of graph
5) Click on okay.

I guess we could change some of the preselected items so that (3) and=20
(4) are not necessary.


------->  First-time AP Stats. teacher?  Help is on the way! See
      | |          Robert W. Hayden
      | |          614 Nashua Street #119
     /  |          Milford, New Hampshire 03055  USA
    |   |
    |   |          email: bob@ the site below
   /  x |          website:
  |     /

gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]