Forum Discussion
Analysis Toolpak add-in
- Thanks Smitty!
MarlonD Are you looking at the Data tab after you activate the Analysis Toolpak? Here's what it looks like in my Excel for O365.
Analysis Toolpak on the Data tab
Smitty Smiththanks for the quick response. I am seeing that but i am expecting to see the Analysis option under the Add-in tab, which I am not seeing. Actually, I am trying to conduct a test of multicollinearity on some data. The Add-in tab keeps appearing and disappearing. When it appears though, only the "Tanagra" add-in (a data mining software I sometimes use) is there, nothing else.
MarlonD That's because the Analysis Toolpak is only loaded on the Data tab. The add-ins tab appearing/disappearing sounds like something dynamically loading/unloading your Tanagra add-in. That's not the Analysis Toolpak doing anything.
Smitty SmithThanks much. I see your point! I was still expecting to see Multicollinearity test as an option but I'll try to figure it out. Will let you know if I am successful.