microsoft excel data analysis toolpak mac

You could easily have a solution for the 2013 academic year, possibly for the fall 2012 terms. Of course this doesn't help you in the short term, but it doesn't appear that there are any short term solutions anyway. You (and others at the university) get the regression analysis that you want, the students gain valuable real-world experience with software development and mathematics, the university gains prestige as a contributor to Open Office, and OOo gains a valuable extension. I think it would be a win-win-win-win situation for everyone.

Why not collaborate with the Computer Science department and the Statistics department and find a student (or students) with the right skills to develop an extension for Calc to provide the functionality that you need? Or perhaps develop this as a one-time seminar? I guarantee that the student(s) who write this will learn a great deal about programming and about statistics, possibly about physics, in this endeavor. Just some food for thought.ĭoctorJah wrote:I am not a software developer, so I can't contribute to this effort other than by making the suggestion.While you may not be a software developer, there are no doubt students at University of North Florida who are. I am not a software developer, so I can't contribute to this effort other than by making the suggestion. Many Mac users might well migrate to OpenOffice over the MS versions if that happened. So with the apparent limitations of the MS Office programs for Mac compared to those for Windows, like the one I've pointed out, I think it would really be to OpenOffice's advantage to push to make things like the functionality of the Analysis Toolpak available. So I downloaded OpenOffice last night to check it out, and discovered that while an equivalent functionality to the Analysis Toolpak of Excel is on the to do list for OpenOffice (. When one of these students came to see me the other day for help with this and we discovered this problem with StatPlus, I suggested that he might try using OpenOffice. But the point is that it is not straightforward. For example, it might be that only the digits displayed in the spreadsheet cells are used instead of including the ones that might be hidden due to rounding to fit into the cell. This might have to do with the way the information is input.

This does produce an output similar to the regression tool from the Analysis Toolpak, but the results are not the same. Instead, they have to download some external add-in, such as one that I believe is called StatPlus. Some of the students have Macs, and MS Excel for Macs apparently does not contain the Analysis Toolpak. In our lab courses, we use Microsoft Excel and the Regression tool in its Data Analysis Toolpak quite a bit. I teach physics at the University of North Florida.

Microsoft excel data analysis toolpak mac