|
[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
|
6:30-7:15 pm
|
General
Questions and Problems from the Audience
Puzzler: Assume you have a workbook where each sheet
contains the budget for a department. There are many
sheets. You want to create a "Summary Sheet" that
lists each department and their budget totals. How do
you summarize from many sheets onto one? |
| 7:15-8:00 pm |
Linear Regression,
Multiple Linear Regression, Non-linear regression. (Rasey)
Performing Regression with:
Chart Trendlnes and Error Bars.
Regression in the Analysis ToolPak, and the
LINEST, TREND, LOGEST, GROWTH functions. |
|
8:00-8:10 pm
|
(Break) |
| 8:10-9:00 pm |
Star Office:
An overview of a FREE alternative to Microsoft Office.
(Cherry)
StarOffice from Sun Microsystems is a suite of programs containing
Word Process, Spreadsheets, Presentation. Plus support for
Web Page Creation, 3D Graphic and more.
See more at: http://www.sun.com/products/staroffice/
(Alternative Topic)
Where are the best
places to go find Excel and Office help on the Web? A tour of
some very useful web resources and on-line communities.
|
Download files for this
meeting: (ZIP 59KB)
Contains Notes1.doc and LinReg3.xls
Related Links:
Linear Regression:
 |
Linear
Regression Using MS Excel
http://www.civil.uwaterloo.ca/lfu/courses/cive342/cive342_econ/regression/sld001.htm
[A good primer on the procedure for setting up a regression of a non-linear
formula by transforming into a linear formula through the use of logs. -
Rasey]
|
| Essential
Regression and Experimental Design, Free Software for Excel that performs
Multiple Linear Regression
Essential Regression and Experimental Design in MS Excel - free, user-friendly
software package for doing multiple linear regression, step-wise regression,
polynomial regression, model adequacy checking and experimental design in MS
Excel
http://geocities.com/SiliconValley/Network/1032/CGPage1.html
|
| Excel Instructions main menu: KSU.EDU. http://www.ksu.edu/stats/tch/malone/computers/excel/
[Covers: Regression, Smoothing, Corelation, Hypothesis Testing, and
more. - Rasey]
Excel
Instructions - Simple Linear Regression
...Multiple Linear Regression [A tutorial of the Tools > Data
Analysis > Regression Dialog box - Rasey]
|
|
Linear
Regression and Graphing
Trendlines and Graphing By Joseph F. Lomax, with the assistance of ENS Lora
Anderson, revised from the tutorial by Wayne Pearson and John Schultz: all of
the Chemistry Department, USNA. Part III: An Exercise in Trendlines and
Graphing
http://chem.mathsci.usna.edu/plebechem/excel_tutor/xlstut3.htm
|
|
|
|
