Excel

How to Find Residuals Using the Data Analysis ToolPak in Excel

Residuals are the differences between the observed values of the dependent variable and the predicted values from the dependent variable. Residuals are an important measure in inferential analysis, particularly in regression analysis. Given the importance of residuals, we will discuss how to find residual values using Excel.

How to Determine the T-table (T critical value) in Excel for Linear Regression Analysis

In linear regression analysis, to determine the significance of the regression coefficients, researchers need to find the critical values from the t-student distribution (T-table). Typically, researchers often use these tables to evaluate the results of regression analysis. However, with technological advancements, determining the T-table value can easily be obtained using a spreadsheet, such as Excel.