![]() We will divide the output into four major parts for our understanding. Let us now understand the meaning of each of the terms in the output. Select the Input Y Range as the number of masks sold and Input X Range as COVID cases. Go to the Data tab > Analysis group > Data analysis.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |