Forum Discussion
Samuel2
Apr 18, 2026Copper Contributor
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?
No RepliesBe the first to reply