The Unofficial ITDE Research & Evaluation I
Support Page
Using this Email address: webkeeper, please send
links, info, suggestions, ideas. They can then be  included in the Support Page. Thank You.
Email Support
Some Notes
Phone Support
Some Links
Email Support
Put "NOVA" for email subject
Send Assignments to Dr. Seraphine, use wordprocessor attachment.
Dr. Seraphine
seraphine@mail.utexas.edu
Dr. Miller
dplkedf@nervm.nerdc.ufl.edu
Classmate
rbuelow@blc.edu

Phone Support


Dr. Seraphine
(512) 471-4155  -5
Dr. Miller
(352) 392-0723 x 229 
Classmate
(507) 388-3453
anytime after 7:00 PM (Central)

Notes
Excel Installation and Activation
Using Common Statistics Functions in Excel
Using Common Statistics Functions in Quattro Pro

Directions to Make Data Analysis Functions Available in Excel's Tools Menu.


1. First, regarding "Analysis Tools" being installed and ready to run (on the menu) in Excel. You need to first check if on your Tools menu if there is a "Data Analysis" option at the bottom of your Tools menu. If there is, you are ready to use the statistics package that came with Excel. 
2. If you do not have this option in your tools menu, I need you to first go to the Tools/Add-ins option and see if there is an Analysis ToolPack option in this section. If there is, make sure that it is checked. When you check this item, "Data Analysis" should appear at the bottom of your Tools menu, as spoken of in #1 above.
3. If you do not have this option in the Tools/Add-ins section, then you need to proceed in this manner: 
a. exit Excel
b. using your explorer (or "My Computer"), go to the Msoffice directory
c. run the program "Setup"
d. Setup will check for pieces of the office package on your hard drive
e. You want to choose the add/remove option
f. Go the the Excel options and look for the Analysis ToolPak or Data Analysis Tools
g. Make sure that there is a checkmark in front of the first of these
h. Office Setup will prompt you to put in your installation CD, or disks and will install the proper files
i. Run Excel again, and go through the items at the top of this email to make it available on the menu
 

Summary of Statistics Functions, their Formulas, and Quattro Pro Procedures.
Task
Manual
Quattro Pro
Drawing Histograms (15-16) 

with observations <20 

 (Do a Frequency Distribution) 

Pick scale which spans entire range, x scale is simply count. 

 Make bar for each observation. 

Highlight data. Choose Graph, New, OK.
Drawing Histograms (15-16) 

 with observations >20 

 (Do a Frequency Distribution) 

Pick category sizes. Do frequency distribution. Make bar graph of distribution results.  Highlight data. Pick Analysis Expert Button, Histogram. Highlight bin data. Choose Graph, New, OK. 
Change Scale of graph to be different along one axis.  Pick better scale. Redo graph. Click on graph to get handles. Grab handle of graph and drag to new position. 
Finding the Median Highlight data. Pick Analysis Expert Button, Descriptive Statistics, -or- 

Finding the Mode Using one of each unique number in the observation list, make a frequency tally of each entry. The entry with the most tallies is the mode. If there is a tie, the mode is the mean of all of those that are tied.  Highlight data. Pick Analysis Expert Button, Descriptive Statistics, -or- 

Finding Quartiles Find Median. Using data remaining after removing median, find median of first half (1st Quartile) and median of second half (3rd Quartile) 

*Caution. This is a different quartile, which used percentiles. Ex. the 25th percentile means the number which has exactly 25% of the scores below it. This is not the same as the book definition of a quartile.

The 5 Number Summary Find low, 1st quartile, Median, 3rd quartile, and high. 

using quartile #'s 0-4 

 (see caution above) 

Finding the Variance of Data (46) Highlight data. Pick Analysis Expert Button, Descriptive Statistics, -or- 

Finding the Standard Deviation (47) Highlight data. Pick Analysis Expert Button, Descriptive Statistics, -or- 

Standardize Observations (64)
Unstandardize Observations (64)
Find the Correlation between two variables x and y (or two groups of data) (111)  Highlight data. Pick Analysis Expert Button, Correlation, -or- 


Summary of Statistics Functions, their Formulas, and Excel Procedures.

Task
Manual
Excel 5.0 (or higher)
Drawing Histograms 
with observations <20 

 (Do a Frequency Distribution) 

Pick scale which spans entire range, x scale is simply count. 

 Make bar for each observation. 

Highlight data. Pick graph wizard. Drag out graph size. Choose options. 
Drawing Histograms with observations >20 

 (Do a Frequency Distribution) 

Pick category sizes. Do frequency distribution. Make bar graph of distribution results.  Highlight data. Pick Options, Analysis Tools, Histogram. Highlight bin data. Pick graph wizard. 
Change Scale of graph to be different along one axis.  Pick better scale. Redo graph. Grab handle of graph and drag to new position. 
Finding the Median Highlight data. Choose Options, Analysis Tools, Descriptive Statistics, -or- 

Finding the Mode Using one of each unique number in the observation list, make a frequency tally of each entry. The entry with the most tallies is the mode. If there is a tie, the mode is the mean of all of those that are tied.  Highlight data. Choose Options, Analysis Tools, Descriptive Statistics, -or- 

Finding Quartiles Find Median. Using data remaining after removing median, find median of first half (1st Quartile) and median of second half (3rd Quartile)  *Caution. This is a different quartile, which used percentiles. Ex. the 25th percentile means the number which has exactly 25% of the scores below it. This is not the same as the book definition of a quartile.
The 5 Number Summary Find low, 1st quartile, Median, 3rd quartile, and high. 

using quartile #'s 0-4 

 (see caution above) 

Finding the Variance of Data  Highlight data. Choose Options, Analysis Tools, Descriptive Statistics. -or- 

Finding the Standard Deviation Highlight data. Choose Options, Analysis Tools, Descriptive Statistics, -or- 

Standardize Observations
Unstandardize Observations 
Find the Correlation between two variables x and y (or two groups of data)  Highlight 2 columns (or more) of data (one column for each variable). Choose Options, Analysis Tools, Correlation, or 


Links
Statistics
A Review of Data Analysis
Some Online Statistics books
Review, Practice Exercises, More Links
Business Statistics @ Clayton College & State University
Statistics Book by David Stockburger
Online Statistics Textbook @UCLA
Online Research Methods Textbook @ Cornell University
StatsSoft Electronic Textbook
R&E and Statistics Links
HyperStat Online
Statistics Glossary
Basic Statistics @Arizona State University
General
Marsha's R&E Links
Georgia Library Learning Online