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

by Kamaluddin Abdulkarim

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

What you will learn...
Understanding functions using formula bar
3.1 Functions overview
3.1.1 Typing function
3.2 SUM function
3.3 MIN function
3.4 MINA function
3.5 COUNT function
3.6 COUNTBLANK function
3.7 Exercises
Analyzing Data with Function using formula bar
4.1 AVEDEV function
4.2 AVERAGE function
4.3 AVERAGEA function
4.4 AVERAGEIF function
4.5 BINOM.DIST function
4.6 CHISQ.TEST function
4.7 CORREL function
4.8 GEOMEAN function
4.9 HARMEAN function
4.10 STANDARDIZE function
4.11 Exercises
Visualize Data with Charts
5.1 Column charts
5.1.1 Clustered Column Chart
5.1.2 3-D clustered column chart
5.1.3 Stacked Column Chart
5.1.4 3-D stacked column chart
5.1.5 100% Stacked Column Chart
5.1.6 3-D 100% stacked column chart
5.2 Line charts
5.2.1 Line chart
5.2.2 Stacked line chart
5.3 Line with Markers
5.3.1 Line chart with Markers
5.3.2 Stacked Line Chart with Markers
5.4 Bar Charts
5.4.1 Clustered bar chart
5.4.2 3-D Clustered Bar Chart
5.4.3 Stacked Bar Chart
5.4.4 3-D Stacked Bar Chart
5.4.5 100% Stacked Bar Chart
5.4.6 3-D 100% Stacked Bar Chart
5.5 Pie Chart
5.5.1 Pie of pie chart
5.5.2 Bar of pie chart
5.6 Scatter plot
5.6.1 Scatter charts with smooth lines and markers
5.6.2 Scatter charts with straight lines and markers
5.7 Combo Charts
5.7.1 Clustered Column – Line
5.7.2 Clustered Column – Line on Secondary Axis
5.8 Exercises
Cleaning Data in Excel
6.1 Remove non-printable characters and extra spaces
6.2 Parse data
6.2.1 Parse data with Convert Text to Columns Wizard
6.3 Change text to desired case
6.4 Exercises
Sort and Filter Data
7.1 Sorting
7.2 Filtering
7.3 Exercises
Measures of Central Tendency
8.1 Mode
8.1.1 Single Mode
8.1.2 Multiple Mode
8.2 Median
8.3 Mean
8.4 Exercises
Measures of Dispersion
9.1 Range
9.2 Variance
9.2.1 Population Variance
9.2.3 Sample Variance
9.3 Standard Deviation
9.3.1 Population Standard Deviation
9.3.2 Sample Standard Deviation
9.4 Average Absolute Deviation
9.5 Inter-quartile range
9.5.1 Quartile Exclusive
9.5.2 Quartile Inclusive
9.6 Exercises
and many more...

Perform analytical analysis on any kind of Windows, Mac, or iPad
Good luck!

113 pages, Paperback

Published August 1, 2022