How To Do Regression Analysis In Google Sheets. You can access these other options from the chart editor. Suppose we have the demand data show in the table below.
Starting the xlminer analysis toolpak is easy. In the regression dialog box, configure the following settings: The most common type of regression analysis is simple linear regression, which is used when a predictor variable and a response variable have a linear relationship.
