FAQ about Excel

 NOTE:  Unless otherwise noted, the response to these questions uses Excel 97 or 2003 (both very similar).  If Excel 2007 is used, this is specifically noted.

How do I enter a formula?  (same process for Excel 2007 and earlier versions)

How do I use functions? (includes information for Excel 2007 and earlier versions)

What is the format for some of the functions that we use in class? (a reference sheet for functions)

Where do I find Data Analysis Tools? (includes information for Excel 2007 and earlier versions)

How do I use Data Analysis Tools? (General Overview) (applies to all versions of Excel)

How do I get summary (or descriptive) statistics? (applies to all versions of Excel)

How do I make a chart or graph? (Excel 2003 or earlier) (Run Charts Excel 2007) (X-Bar and R using Excel)

How do I use Excel 2007 to create a scatter diagram and obtain regression output?

What is meant by relative reference and absolute reference? (same process for Excel 2007 and earlier versions)

How do I copy formulas and/or numbers? (same process for Excel 2007 and earlier versions)

How do I get a printout?  (includes information for Excel 2007 and earlier versions)

How do I get Regression Output from Excel? (applies to all versions of Excel)

How do I calculate control limits?

Back to BUSA 3110 Home Page