Excel and Statistics(18), Paired t-test

Excel and Statistics, everybody should know.  : Contents

Paired t-test

With ‘example1. xlsx’, select ‘t-Test: Paired Two Sample for Means’

 

Enter two ranges in the same way.

 

It shows the result of a paired t- test, and since they are paired, the numbers in both groups must be the same.

If the data is measured twice in one person under different conditions, the two data are mutually dependent, so a paired t-test is performed. This is a case of applying different treatments to both parts of the body, or different treatments at intervals of time.

 

 

 

 

 

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