
links, info, suggestions, ideas. They can then be included in the Support Page. Thank You. 


Email Support 

Some Notes 

Phone Support 

Some Links 











anytime after 7:00 PM (Central) 
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/Addins 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/Addins section, then you
need to proceed in this manner:




Drawing Histograms (1516)
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 (1516)
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 04 (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.



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 04 (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 