Until now, Excel has been an office application with many users. Excel can help manage data and process it to produce the required information. But did you know that excel can also perform statistical data processing?
When choosing multiple linear regression analysis, we include at least two independent variables into the model. To obtain the best linear unbiased estimator, we must test the assumptions. One of the assumptions that need to be tested is the multicollinearity test.
Calculating the value of variance, standard error, and t-value is the last stage in simple linear regression analysis. The variance value can be calculated if the estimate of the variance of u has been calculated. The value of estimate of the variance of u cannot be calculated if it has not calculated the value of …
How to Find Variance, Standard Error, and T-Value in Simple Linear Regression Read More »
Analysis of Variance (ANOVA) is often used in experimental research with different treatments. In simple linear regression, there is also ANOVA. Some often refer to ANOVA as the F test. In simple linear regression analysis, the statistical software output will display an ANOVA table. In addition to understanding how to interpret the ANOVA table, you …
How to Calculate the Analysis of Variance (ANOVA) Table In Simple Linear Regression Read More »
In simple linear regression analysis, the calculation of the predicted Y value, residual value, and sum of squares need to be well understood by researchers. If previously you would usually look at the output of statistical software, on this occasion, I will give a tutorial on how to calculate it manually using Excel.
