TidyData
TidyData
  • Видео 70
  • Просмотров 75 983
t-test in Excel
In this tutorial, I explain what t-test is and how to do t-test in Excel. In particular, I explains the concepts and examples for t-test: Paired Two Sample for Means and t-test: Two-sample Assuming Equal Variances.
Tutorial Content:
0:00 - The purpose of conducting a t-test
1:03 - First data example for t-test: Paired Two Sample for Means
2:32 - First data example for t-test: Two-sample Assuming Equal Variances
4:29 - Second data example for t-test: Paired Two Sample for Means
5:35 - Second data example for t-test: Two-sample Assuming Equal Variances
7:12 - Excel step-by-step for t-test: Paired Two Sample for Means (First Data Example)
9:15 - Excel step-by-step for t-test: Two-sample Assuming Equ...
Просмотров: 262

Видео

ANOVA in Excel
Просмотров 2408 месяцев назад
This tutorial covers the concepts of single-factor ANOVA, two-factor ANOVA with replication, and two-factor ANOVA without replication. Additionally, it includes examples for single-factor ANOVA, two-factor ANOVA with replication, and two-factor ANOVA without replication. Finally, it provides a step-by-step guide on how to perform single-factor ANOVA, two-factor ANOVA with replication, and two-f...
Long Data vs. Wide Data
Просмотров 1988 месяцев назад
This tutorial first explains what long data and wide data are. Further, it provides two perspectives to explain the differences between long data and wide data. Finally, I show how wide versus long data impact the t-test in Excel and R software. Tutorial Content 0:00 - Data examples for long and wide data 1:05 - Difference between long and wide data (Perspective 1 - Repeated values or not) 2:01...
AB test: How Data Type Impacts Analysis Choice
Просмотров 868 месяцев назад
This tutorial explains how to choose the data analysis technique (e.g., ANOVA, t-test, linear regression, logistic regression) based on data type (i.e., numerical data vs. categorical data). Content of the tutorial: 0:00 - Example of AB test 0:31 - Definitions of data type: numerical data vs. categorical data 1:15 - Overview of how data type impacts analysis choice 1:47 - Linear regression for ...
How Effect Size, Sample Size, Power Interact with Each Other
Просмотров 1289 месяцев назад
This tutorial explains how effect size, sample size, and power interact with each other. In particular, I explain three remarks as follows. Remark 1: For a given effect size, as sample size increases, the power also increases. Remark 2: For a given power, as effect size increases, the needed sample size decreases. Remark 3: For a given sample size, as effect size increases, the power also incre...
How Sample Size Impacts Statistical Power
Просмотров 469 месяцев назад
This tutorial explains how sample sizes impact statistical power using data examples in R. In particular, the tutorial uses R code exampels to illustrate that (1) as sample size increases, the power also increases; (2) as sample size increases, the observed p-value will decrease, meaning that we are more likely to reject null hypothesis. Tutorial Content 0:00 - Definitions of Statistical Power ...
How Effect Size Impacts Sample Size
Просмотров 869 месяцев назад
In this tutorial, we delve into the crucial relationship between effect size and sample size in research studies. We will illustrate how varying effect sizes influence the required sample size using R programming examples. The fundamental insight is that as the effect size grows, the necessity for a larger sample size diminishes. Content of this tutorial: 0:00 - Explain the concepts and definit...
Meaning of Cohen's d
Просмотров 649 месяцев назад
This tutorial explains the definition of effect size measure Cohen's d. Further, it provides examples in R to explain the meaning of Cohen's d. Video Content 0:00 - Definition of Cohen's d 1:10 - Different effect sizes of effect size - Cohen's d 2:14 - Examples to demonstrate the meaning of Cohen's d and the difference Cohen's d and mean Related Tutorials: Effect Size: Cohen d vs. Pearson r ruc...
Effect Size: Cohen d vs. Pearson r
Просмотров 3619 месяцев назад
This tutorial explains the basic idea of Cohen's d and Pearson correlation coefficient r for effect sizes. It explains the formulas and use data to explain the difference and connection betweeen Cohen's d and Pearson correlation coefficient r. Content of this tutorial: 0:00 - Explain the concepts of Cohen's d and Pearson correlation coefficient r (effect size) 0:50 - Definitions of small, mediu...
Alpha and Beta in Hypothesis Testing
Просмотров 9810 месяцев назад
This tutorial delves into the fundamental concepts of alpha (Type I error) and beta (Type II error) in hypothesis testing. It provides a clear understanding of null and alternative hypotheses, elucidating their connection to alpha and beta. Additionally, the tutorial explores terms such as false positive, false negative, true positive, and true negative in hypothesis testing. The discussion ext...
Total Effect, Indirect Effect, and Direct Effect in Mediation
Просмотров 2 тыс.10 месяцев назад
This tutorial explains what total effect, Indirect effect, and direct effect are in mediation analysis. Further, I explains these 3 concepts using a data example. Finally, I demonstrate the calculations in SPSS. Content of this tutorial: 0:00 - Concepts of indirect effect, direct effect, and total effect in mediation analysis 1:45 - Data Example to explain indirect effect, direct effect, and to...
Meaning of Correlation Coefficient
Просмотров 178Год назад
This tutorial explains the meaning of correlation coefficient. Further, it compares the meanings of correlation coefficient and regression coefficient. ▬ Chapters ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00 - Comparing correlation coefficient with regression coefficient. 0:37 - Conceptual meaning of correlation coefficient 0:54 - Quantitative meaning of correlation coefficient 1:29 - Conceptual meaning of regression...
Visualize Google Trends
Просмотров 138Год назад
This tutorial shows how to plot Google Trends data visually. In particular, it uses the Google Trends data on the interest in Tesla cars in the US across 50 states plus DC. It uses R scatter plot to plot Google Trends data using R packages of ggplot and ggrepel to plot the basic figure and add state labels. ▬ Chapters ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00 - Explain Google Trends data 1:17 - Overview R code to ...
Google Trends for Business Analysis
Просмотров 110Год назад
This tutorual shows how you can use Google Trends data for data analysis and marketing / business research. It includes how to downlowd data from Google Trends. Further, it includes how to combine Google Trends data with other data. Finally, it shows how to do analysis with the data. The data example is Tesla car interests in the United States and link it with population density data. Such data...
Meaning of Slope in Linear Regression
Просмотров 343Год назад
This tutorial explain the meaning of slope in linear regression. It includes the situation when X (independent variable) is numerical and when X is categorical. ▬ Chapters ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 0:00 - Introduction 0:43 - Meaning of slope when X is numerical (continuous) 2:11 - Meaning of slope when X is categorical (dummy coding) 4:22 - Meaning of slope when X is categorical (1 & 2 coding) 5:53 - Me...
Naive Bayes for Sentiment Analysis
Просмотров 472Год назад
Naive Bayes for Sentiment Analysis
Logistic Regression in Google Sheets
Просмотров 1,9 тыс.Год назад
Logistic Regression in Google Sheets
Logistic Regression in Excel
Просмотров 7 тыс.Год назад
Logistic Regression in Excel
Read SPSS Data in R
Просмотров 721Год назад
Read SPSS Data in R
Moderated Mediation in R
Просмотров 2,1 тыс.Год назад
Moderated Mediation in R
Moderated Mediation in SPSS
Просмотров 108Год назад
Moderated Mediation in SPSS
McMemar's Test in SPSS
Просмотров 334Год назад
McMemar's Test in SPSS
Creating Contingency Table in Excel
Просмотров 5 тыс.Год назад
Creating Contingency Table in Excel
Mediation for Binary Outcome (logistic regression) in R - Method # 2
Просмотров 457Год назад
Mediation for Binary Outcome (logistic regression) in R - Method # 2
Mediation for Binary Outcome (logistic regression) in R - Method #1
Просмотров 982Год назад
Mediation for Binary Outcome (logistic regression) in R - Method #1
Setup Mediation PROCESS Macro in R
Просмотров 304Год назад
Setup Mediation PROCESS Macro in R
Mediation Analysis for Binary Outcome (logistic regression) in SPSS
Просмотров 2,5 тыс.Год назад
Mediation Analysis for Binary Outcome (logistic regression) in SPSS
Meaning of Intercept in Linear Regression
Просмотров 4,7 тыс.Год назад
Meaning of Intercept in Linear Regression
Centering in Linear Regression
Просмотров 822Год назад
Centering in Linear Regression
Serial Mediation in R (full R code from scratch) - Part 2
Просмотров 197Год назад
Serial Mediation in R (full R code from scratch) - Part 2