The analysis toolpak for excel is an essential addition for users who are doing statistical analysis of any sort. It has lots of extra statistical functions and summaries that are not in the statistical group in the formulas tab.
But adding it into the Mac version of Excel is quite different than the PC version. It's done through the Tools menu on the Mac. Follow this video to see.
See lots more tutorials on the ‪@QVisible‬ channel.