Multiple regression issues in analysis toolpak

[Delponte33]

Dear MrExcel community,

Is there any easy and automatic way to compute predictions including confidence intervals after a multiple regression using the Analysis Toolpak?
Also, the analysis toolpak regression tool reports an error whenever I have missing data points in my range selection.
What would you recommend to easily impute missing data to avoid the error?

Many thanks

 

[Cam75]

Hi there, I use the XLSTAT free version https://www.xlstat.com/en/download/ to avoid such drawbacks of the ATP.
Enjoy!