Data Analysis Add-in for Mac Excel

Topic

New Reply

I teach an Excel class and several students have Macs. They need to use the Histogram and Regression tools, but can’t find/turn on the Data Analysis tools – where are they/ They are using the 2003 and 2008 versions of Mac Excel.

Thanks!

Larry

Reply | Quote

Replies

2008 doesn’t have it as far as I know (no VBA support); 2003 is a Windows version so I assume you mean 2004, in which case it should be available as an add-in (the Analysis Toolpak), I believe.

Reply | Quote

Rory,

That’s what I was afraid of – thanks!

Larry

Reply | Quote

Thanks Rory – I was afraid of that!

Larry

Reply | Quote

It’s not very hard to have them create their own Frequency tables and histograms. You can use the array function Frequency to create a Frequency Table.

Step one. Create what Excel calls bins. If you’ve got just a few different discrete values, those would be the bins. If you’ve got continuous data, you can take the max and the min and decide how many bins you want.
Step two. Select the area where you want the frequencies calculated. Type in =Frequency(data,bins). Use shift+Ctrl enter to enter the array formula. You should see the frequency table.
Step three. Make a column chart of the frequencies. You have to change a few settings. Under format series change the gap width to zero.

Attached are two examples of histograms from the same dataset.

Reply | Quote