Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    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.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rory,

    That's what I was afraid of - thanks!

    Larry

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Rory - I was afraid of that!

    Larry

  5. #5
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •