Excel and Statistics, everybody should know. Contents

Excel and Statistics, everybody should know.    Contents and data

example data at google drive

PART 01 Data Collection and preparation. 6

Autofill and absolute references 7

Name a variable 13

Naming nominal variables 15

Data validation. 16

filter 20

Find and Replace 29

Text to a table 33

IF function. 39

Installation. 47

PART 02 Descriptive Statistics 50

Descriptive Statistics 51

Histogram.. 55

Rank and Percentile 61

Moving average 65

Exponential smoothing. 69

Sampling. 77

Random Number Generation. 86

PART 03 Inferential statistics 88

Independent t-test 89

Paired t-test 100

F-Test 102

ANOVA. 107

2-way ANOVA. 115

ANCOVA. 125

Correlation. 134

Regression. 137

Chi-square test 147

Chi-square Goodness of fit test 160

McNemar Test 162

Mantel-Haenszel test 164

  

170

Excel and Statistics, everybody should know.  : Contents

=================================================

• R statisics portal https://tinyurl.com/stat-portal

• R data visualization book 1  https://tinyurl.com/R-plot-I (chart)

• R data visualization book 2
  

https://tinyurl.com/R-plot-II-2  simple variables
https://tinyurl.com/R-plot-II-3-4   many variables / map
https://tinyurl.com/R-plot-II-5-6   time related / statistics related
https://tinyurl.com/R-plot-II-7-8   others / reactive chart 

• R data visualization book 3    https://tinyurl.com/R-data-Vis3 
  

• R data visualization book 4   R 데이터 시각화 4권
  

• Meata Analysis book 1  https://tinyurl.com/MetaA-portal
• Meata Analysis book 2  https://tinyurl.com/MetaA-portal(2)

 

• Preciction Model and Machine Learning   https://tinyurl.com/Machine-Learning-EZ
• Sample Size Calculations   https://tinyurl.com/MY-sample-size 
• Sample data  https://tinyurl.com/data4edu 

• easier R than SPSS with Rcmdr : Contents