Forum Discussion
Managing Blank Cells in multiple linear regression analysis.
Hello,
I am performing a multiple linear regression analysis using the Analysis Toolpak in Excel 365. I have complete y-data, but the x variables are missing some data points throughout a large data set. I know I can fill in the data with the mean or potentially use a regression analysis to predict data to fill in the blanks; however, I would prefer to ignore the blank data if possible. Is there a way to do this inside the data toolpak?
1 Reply
One thing you could do is create a separate area with the FILTER function which filters away the rows with blank x values and use that as the input of the linear regression.
