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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |