Statistical Analysis in Excel: Step-by-Step Guide with Examples for Intermediates

by Kamaluddin Abdulkarim

STATISTICAL ANALYSIS IN EXCEL FOR INTERMEDIATES HAS NEVER BEEN THIS SIMPLE!

What you will learn...
Definition of Microsoft Excel
What can you do with Excel?
Cell
Cell reference
Active cell
Workbook
Worksheet
Worksheet Tab
Understanding functions using insert function
LARGE function
SMALL function
MAX function
MAXA function
GAUSS function
Exercises
Analyzing Data with Function using insert function
KURT function
SKEW function
FORECAST function
RSQ function
EXPON.DIST function
GAMMA.DIST function
NORM.DIST function
POISSON.DIST function
WEIBULL.DIST function
F.DIST function
Exercises
Data Analysis ToolPak
Independent 2-sample t-test
T-test for equal and unequal variance
Paired t-test
Exercises
Analysis of Variance
One way ANOVA test
Two way ANOVA test
Two-factor ANOVA with replication
Two-factor ANOVA without replication
Exercises
Regression Analysis
Simple Linear Regression
Linear Regression assumptions
Multiple Linear Regression
Exercises
Random Number Generation
Uniform Distribution
Normal Distribution
Bernoulli Distribution
Binomial Distribution
Poisson Distribution
Patterned Distribution
Discrete Distribution
Exercises
and many more...
Perform analytical analysis on any kind of Windows, Mac, or iPad

Who Is This Book For?
Users of Excel who are used to formulae and function yet wish to raise their level of expertise in Statistical Analysis using Data Analysis Toolpak.

87 pages, Paperback

Published August 1, 2022