![]() ![]() If it is not enabled, add it to your Excel for performing regression analysis. Go to the Data tab and check for the Data Analysis ToolPak inside the ribbon at last. Now, before proceeding forward, verify that the Data Analysis ToolPak is enabled and available inside Data tab. Verify Data Analysis ToolPak is installed Hope you have understood the dependent and independent variable in regression analysis. Sell of umbrellas increase and decreases when rainfall is high or low. So, the umbrella is a dependent variable whose sell depends on the rainfall percentage of each month, which is an independent variable. This Excel worksheet will contain three columns: Months (Jan to Dec), Rainfall percentage, and sold umbrella quantity (total number of umbrellas sold in each month). Umbrellas are most sold in month July and less sold in January. Each month sell is different according to rainfall. This data is for the sell of umbrellas from January to December. Let's take a scenario to understand the variables of regression analysis -įor example, we have sells data of 12 months stored in an Excel worksheet. In contrast, independent variables are those factors that affect the dependent variable and helps to predict the value for dependent variables. The value of dependent varies according the independent variable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |