Ping learn something new today!! 今天本來是不會很productive的, 因為有兩個seminar,又要去買bas pass (怪這個馬馬虎虎的我, 不小心弄不見了!!). But as Ping was looking at the tons of different measurements of BGE that she has, wishing that something that can gives a definite answer will jump up at her, Ping simply typed ANOVA into Excel help. Didn't expect anything to come up because the last time Ping checked, the most robust statistical test you can get from Excel is ttest. Not anymore!! Excel 2007 could really do ANOVA for you! High five to Microsoft!! Ping was starting to get disappointed with MS Office 2007, where they change all the file formats and the program looks more like a software for little kids to start learning how to type. It also became less intuitive to find stuff. Basically, Ping had to learn all the functions again! Some of the old VB codes Ping had won't work on it either!!
Now that Ping figure out about the Data Analysis ToolPak, Ping is glad to have Excel. No more waiting in line for computers in the library to use SAS for Ping's stats analysis!!
MS Excel Data Analysis ToolPak
1 comment:
I don't often work with excel files.But some days ago I used it.But then I opened it again and didn't see anything.A friend advised this tool-xls file recovery.It helped me very easy and for free.Besides it demonstrated how can be easily solved with Excel recovery software for recovery xls.
Post a Comment