Month: January 2023
How to Generate a Random Sample using Excel
The sampling technique of simple random sampling is a sampling method that provides equal opportunities for each member of the population to be selected as a sample. This sampling technique randomly selects the sample from the existing population. To be able to use the simple random sampling technique, researchers need to ensure that there are at least two assumptions that must be met.
Formula to Calculate Analysis of Variance (ANOVA) in Regression Analysis
In regression analysis, both simple linear regression and multiple linear regression, it is necessary to conduct an analysis of variance calculation to find the statistical F value. The table for the analysis of variance in the regression analysis is called the ANOVA table.
Paired Sample T-test: Definition, Analysis Stage, and Interpreting the Results
Researchers often use the t-test to analyze differences in two sample groups. The t-test that researchers often use consists of the paired sample t-test and the independent sample t-test.
How to Find Residual Value in Multiple Linear Regression using Excel
Residual values in linear regression analysis can be used to test for normality. In addition, the heteroscedasticity test also requires the variance value of the residual. Therefore, the residual value is important in the linear regression assumption test with the Ordinary Least Square (OLS) method.