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...
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.