R Square | Significance F and P-Values | Coefficients | Residuals This example teaches you how to perform a regression analysis in Excel and how to interpret the Summary Output. Below you can find our data. The big question is: is there a relation between Quantity Sold (Output) and Price and Advertising (Input). In other […]
The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel to find the correlation coefficient between two variables. – A correlation coefficient of +1 indicates a perfect positive correlation. As variable X […]
This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1. First, let’s take a look at our time series. 2. On the Data tab, in the Analysis group, click Data Analysis. Note: can’t find […]
This example teaches you how to calculate the moving average of a time series in Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1. First, let’s take a look at our time series. 2. On the Data tab, in the Analysis group, click Data Analysis. Note: […]
This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the study hours of 6 female students and 5 male students. To perform a t-Test, execute the following steps. 1. First, perform an […]
This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that the variances of two populations are equal. Below you can find the study hours of 6 female students and 5 male students. To perform an F-Test, execute the following steps. 1. On the Data […]
This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal. Below you can find the salaries of people who have a degree in economics, medicine or history. […]
You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test. To generate descriptive statistics for these scores, execute the following steps. 1. On the Data tab, in the Analysis group, click Data Analysis. Note: can’t find the Data Analysis button? Click […]
This example teaches you how to create a histogram in Excel. 1. First, enter the bin numbers (upper levels) in the range C3:C7. 2. On the Data tab, in the Analysis group, click Data Analysis. Note: can’t find the Data Analysis button? Click here to load the Analysis ToolPak add-in. 3. Select Histogram and click […]
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1. On the File tab, click Options. 2. Under Add-ins, select Analysis ToolPak and click on the Go button. 3. Check Analysis ToolPak and click […]
