You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Site Actions
This page location is:
Home
Tech Tools @ Mason
Statistical Analysis
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Statistical Analysis
team site for students, parents, and staff
Top Link Bar
Tech Tools @ Mason
Currently selected
PC Maintenance & Security
Digital Citizenship
Digital Citizenship links
Access
Intro
Intermediate
Advanced
Outlook
Office 2010
Sound Recording
Audacity PC
Audacity Mac
What does sound look like?
Video tools
Premier Pro CS4
Windows Movie Maker
Recently Modified
Home
Premier Pro CS4
Movie Maker
Audacity Project
Audacity PC
Quick Launch
Team Discussion
Word
Getting Started
Intro
Intermediate
Advanced
Newsletter Workshop
Mail Merge Workshop
WordTips
PowerPoint
Getting Started
Intro
Intermediate
Advanced
Excel
Intro
Intermediate
Advanced
Charting Workshop
Pivot Tables
Statistical Analysis
Currently selected
All Site Content
Statistical Analysis with Excel
A. Describing Data
Finding the arithmetic mean
Using the AVERAGEA function
Using the AVERAGEIF function
Using the AVERAGEIFS function
Finding the geometric mean
Finding the median
Finding the mode
Finding the standard deviation
Using the STDEVA functions
Finding the variance
Using the VARA functions
Finding the kurtosis of a distribution
Finding the skewness of a distribution
Finding the confidence interval
Using the FREQUENCY function
Finding the five number summary
Ranking values without ties
Ranking values with ties present
Finding a value’s standard score
B. Comparing Variables
Finding the bivariate correlation coefficient
Finding the values associated with a linear regression
Finding linear slope
Finding the y-intercept of a linear regression
Predicting a future value using an existing value
Using the TREND function
Finding the values associated with an exponential regression
Predicting values along an exponential curve using existing values
C. Tests of Significance
Finding the probability of a one-tailed z-test
Finding the probability associated with a Student's t-test for paired samples
Finding the critical value of the Student's t-test for paired samples
Examining data for homogeneity of variance using the FTEST function
Finding the critical value of the FTEST
Finding the probability associated with a Student's t-test for independent samples
Finding the critical value of the Student's t-test for independent samples
Finding the probability associated with a chi-squared test for independence
Finding the critical value of the chi-squared test for independence
D. Data Analysis ToolPak
Activating the Data Analysis ToolPak
Finding descriptive statistics
Creating a histogram
Performing a t-test for paired, or related samples
Examining data for homogeneity of variance
Performing a t-test for independent, or unrelated, samples
Performing a one-way analysis of variance (ANOVA)
Performing a factorial analysis of variance (ANOVA)
Performing a repeated measures analysis of variance (ANOVA)
Finding the correlation coefficient of two or more variables
Performing a linear regression
false,false,1
