Alphabetized List of Subtopics from Screencasts
Below is an alphabetized list with links to the most important subtopics included in the Screencast guides to using MS Excel to analyze data with graphs and statistics. Note: some subtopics are linked more than once under different terms below to help users quickly find a topic of interest. For a list of complete Screencasts from this series, go here.
As you may know, you can quickly search for a term or topic on this page (or on most webpages or within most documents) by typing ctrl F and then doing a search.
Adjusting scale of axes on graphs
Analysis ToolPak: Installing
ANOVA: doing the test
ANOVA: formatting table of output
ANOVA: interpreting output
ANOVA: scatterplot with three (or more) groups
Date codes in Excel: avoiding formatting problems
Dummy variables
Error bars
Excel Basics: cell format
Excel Basics: formulas
Excel Basics: functions
Excel Basics: paste as values
Excel Basics: spreadsheet format
Formulas: basics
Formulas: calculating averages
Formulas: paste as values
Formulas: using the dollar sign
Formulas: view all in a spreadsheet
Frequency distribution (= histogram)
Functions: "static" vs. "dynamic"
Functions: basics
Hidden Data on Scatterplots: how to display with jitter
Hidden Data on Scatterplots: how to display with text boxes
Hidden Data on Scatterplots: how to find
Histograms (= graphs of frequency distributions)
Install Analysis ToolPak
Paste as values
Paste Transpose
p-value: cutoff for statistical significance
p-value: p is the probability…
p-values: one-tailed vs. two-tailed (for t-Test)
Reducing number of digits
Regression Analysis: doing the test
Regression Analysis: formatting the output
Regression Analysis: interpreting output
Regression Analysis: r-squared
Regression Analysis: scatterplot
Reporting digits
Scatterplot: adding a text box for x-axis categories
Scatterplot: adding a trendline
Scatterplot: adding error bars
Scatterplot: adding legend
Scatterplot: adding mean values
Scatterplot: comparing three groups
Scatterplot: comparing two groups
Scatterplot: continuous independent variable (for regression analysis)
Scatterplots: adjusting axis scale
Scatterplots: formatting
Scatterplots: using dummy variables for categories on x-axis
Scientific notation (Excel version)
Significant digits
t-Test: doing the test—getting started
t-Test: doing the test—completing the test
t-Test: equal vs. unequal variances
t-Test: formatting table of output
t-Test: interpreting output 1
t-Test: interpreting output 2
t-Test: one-tailed vs. two-tailed p-values
t-Test: scatterplot with two groups
