Forum Discussion

Samuel2's avatar
Samuel2
Copper Contributor
Apr 18, 2026

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