To Present on Friday, 10/1/99

All are Excel solutions to class homework problems.

4.37a   (do this two ways:
          1.  Using formula (n choose x) p^x ...
          2.  Excel menu Binomial,
               a.  comes from    insert  --->   function 
                      or from push button
               b.  it appears in several places on "paste
                      function" menu, e.g. all & statistical)

4.40 d   (just use Binom menu)

2.21   (1.   Read in Data:
            a.  Could type in (NOT recommended, e.g. list of 1000)
            b.  Can use disk with text (this require ASCII read in)
            c.  Go to Class Web Site: demo Netscape
        2.   Frequency histo's for each:
            a.  Use default    Tools    --->   Data Analysis
                                        --->   Histogram
                (leave bin range empty)

            b.  Can fill "Input Range" by:
                  i:  typing in references
                  ii:  using colored box
                      (note:  NOT column 1, which is just labels)

            c.  For output:
                  i: Output is generally a table of freq's
                        (stress THIS, not plot)

                        (default is on a new sheet)
                        ("Output range" is  upper left corner
                              of resulting table, on this sheet)
                  ii:  Can also add graphic, by checking "Chart Output"
                  iii:  Alternate construction of graphic is similar
                         to bar chart, using Chart Wizard.
             d.  Go through adjustments to plot
                  i.  Show moving plot around, and changing aspect
                          ratio.
                  ii.  Change title location, text, font,...
                  iii.  Remark same for axes.
                  iv.  Look at "format axis" menu, good trick is
                  v.  Work with "Plot Area" (double click or right button click)
                  vi.  change bars  (double click or...)  Options   --->
                             Gap Width,   set to 0
                  vii.  delete legend
             e.  Problem is Excel's bin choice is bad, too small, and
                     not "even values".  Approach is put range of bins in.
                  i.  Put range of bins into spreadsheet.  5,10,...,45.
                          (how to find these?  want to include all data,
                              useful to use Excel function min, and max,
                              can get these from menu, or by typing )
                          (chose something that brackets the values)
                  ii.  Look at answer (point out COULD fiddle bars as above)
                  
              f.  Want to compare populations
                  i.  Use Excel's default, point out x grid does not 
                          allow easy comparison.
                  ii.  Use the same grid as above, still not good choice
                  iii.  Use new binning grid, that is good for all 3 data
                           sets.  Easy choice comes from max and min functions
              g.  Put all three on same plot, using chart wizard.

2.23   (show how to take logs, and show different binwidths)


B7c   Binomial(30, .95)
          a.  Put n in a box
          b.  Put p in a box
          c.  Create column of x:   0,1,...,30
                 i.  do 0, 1
                 ii.  drag downwards
          d.  Create column of f(x)
                 i.  do first one from binomial menu
                 ii.  Get entries from table
                 iii.  Change references for n and p to absolute
                              (with dollar signs)
                 iv.  drag downwards.
          e.  Plot with chart wizard (NOT with histogram tool).
          f.  twiddle plot features as needed.