Microsoft Excel 2010 (PC) Series Statistical Analysis Training
Microsoft Excel 2010 (PC) "Series" Statistical Analysis Training
Excel 2010 - Statistical Analysis Training
A. Describing Data
What you'll learn in this training
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 quartile of a data set
Ranking values
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 F.TEST function
Finding the critical value of the F-Test
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
Carlos Albizu University
Microsoft Excel Training Series
Carlos Albizu University
Academic Programs
Doctoral Program
Education Program
Psychology Master Program
Psychology Undergraduate Program
Academic Services
Admissions
Goodman Center - Clinic
Library
Student Services
New Student Orientation
New Student Orientation Resources
Student Support Services
Business Offices
Administration
Finance
Financial Aid
Registrar
Information Technology Services
Blackboard
Blackboard Student Information
Blackboard Student: Discussion Board
Blackboard Student: Online Quizzes
Blackboard Student: Social Media
Blackboard Technical Support
Classroom Technology
Computer Lab
Scoring Tools
MS Word
MS PowerPoint
Discounted Software
Google Apps
Institutional Application
SunMail
Microsoft Access Training Series
Microsoft Excel Training Series
Microsoft PowerPoint Training Series
Microsoft Word Training Series
Title V-Undergraduate
Windows Training Series
Related Topics
Microsoft Excel 2000 (PC) "Series" Intermediate Training
Microsoft Excel 2000 (PC) "Series" Quick Start Training
Microsoft Excel 2000 (PC) "Series" Intro Training
Topic Information
Topic #: 16092-90
Date Created: 06/20/2012
Last Modified Since: 04/24/2013
Viewed: 291
Print Topic
Email this topic
Home
Online Support
Request Support
Sign in
Exit
Submit Feedback
Contact Us
Live Chat
Advanced Search
Help Desk and Customer Support Software by Parature