Select the Input Y Range as the number of masks sold and Input X Range as COVID cases. The Independent Variable is the factor that might influence the dependent variable.Ĭonsider the following data where we have a number of COVID cases and masks sold in a particular month. The Dependent Variable is the factor you are trying to predict.
There are two basic terms that you need to be familiar with:
In Excel, we use regression analysis to estimate the relationships between two or more variables.
