(image from: homepages.spa.umn.edu)
The following post was originated from my email to two students under my supervision. They’re both working on data analysis. Instead on pushing them to learn new software, R for instance, I spread some seeds for them to learn deeper into software that they’ve already known. Some students, or it’s my students, have known spreadsheet for years, but they’ve not maximised its potentials.
- http://annkemery.com/excel/: a website owned by Ann K Emery, a data consultant. If you have trouble opening it, you can directly go to her Youtube channel (just search her nama on Youtube). Based on her post, you can learn that becoming a commercial consultant, she can be so generous in sharing her knowledge to public.
- http://www.youtube.com/watch?v=5MFjwM6K5Sg: a descriptive statistical analysis using “data analysis toolpak” add-on in Excel. You have to install the add-on first from MSOffice installer.
- http://www.youtube.com/watch?v=zEXK6M93lb8: correlation analysis using “data analysis toolpak”.