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

I suggest you reread my first email where I wrote that we possibly should change the preselected items so 
that one can get a histogram faster. 


Bob <bob statland org> wrote:

I think you make my point very well!-)  So apparently you have to dig
even deeper into the menu system than I realized to actually get a
histogram.  The reason I did not look for a tab to select "Histogram"
is that I had already selected "Histogram" at an earlier stage.  

Instead of finding fault with my description of the problem I suggest
you look at some of the other software I mentioned and count how many
clicks and dialog boxes you have to wade through to get a histogram.    
It is MUCH easier -- even in software like R that is supposed to be
very unfriendly.

Forwarded message:
From gnumeric-list-bounces gnome org Tue Apr 14 12:15:23 2015
X-Original-To: bob statland org
X-Csoft-Rule: spam<=5.0
X-Spam-Checker-Version: SpamAssassin 3.3.2-csoft39 (2011-06-06) on
X-Spam-Status: No, score=-6.9 required=6.0 tests=BAYES_00,RCVD_IN_DNSWL_HI
     autolearn=ham version=3.3.2-csoft39
X-Original-To: gnumeric-list gnome org
Delivered-To: gnumeric-list gnome org
X-Virus-Scanned: by amavisd-new at
X-ASG-Debug-ID: 1429028087-0538de0f6f5cbcf0001-FiEwLn
X-Barracuda-Envelope-From: aguelzow pyrshep ca
Message-ID: <552D3D46 8020600 pyrshep ca>
Date: Tue, 14 Apr 2015 10:16:06 -0600
From: Andreas J Guelzow <aguelzow pyrshep ca>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
     rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: gnumeric-list gnome org
Subject: Re: How to save advanced-filter settings (fwd)
References: <20150414143801 78D72E18EC9F lilly csoft net>
X-ASG-Orig-Subj: Re: How to save advanced-filter settings (fwd)
In-Reply-To: <20150414143801 78D72E18EC9F lilly csoft net>
X-Barracuda-Start-Time: 1429028087
X-Virus-Scanned: by bsmtpd at
X-Barracuda-BRTS-Status: 1
X-Barracuda-Spam-Score: 0.12
X-Barracuda-Spam-Status: No, SCORE=0.12 using global scores of TAG_LEVEL=1000.0
     QUARANTINE_LEVEL=1000.0 KILL_LEVEL=3.5 tests=CN_BODY_332
X-Barracuda-Spam-Report: Code version 3.2, rules version
     Rule breakdown below
     pts rule name              description
     ---- ----------------------
     0.12 CN_BODY_332            BODY: CN_BODY_332
X-BeenThere: gnumeric-list gnome org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: GNOME spreadsheet <>
List-Unsubscribe: <>,
     <mailto:gnumeric-list-request gnome org?subject=unsubscribe>
List-Archive: <>
List-Post: <mailto:gnumeric-list gnome org>
List-Help: <mailto:gnumeric-list-request gnome org?subject=help>
List-Subscribe: <>,
     <mailto:gnumeric-list-request gnome org?subject=subscribe>
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"; Format="flowed"
Errors-To: gnumeric-list-bounces gnome org
Sender: "gnumeric-list" <gnumeric-list-bounces gnome org>

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

gnumeric-list mailing list
gnumeric-list gnome org

------->  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]