Excel, Python and R


PleaseĀ work thru at least the first 18/19 lessons of theĀ Excel 2013Ā /Ā Excel 2016 introductory tutorial (not specific to statistics). The rest of the tutorials are useful, but I would consider more advanced than what we need for the class. [For those who will be using mainly MS Office 2007 or 2010, there are similarĀ tutorials on the same site.] At the beginning ofĀ sessionĀ 2, you will have a quiz on this material. Here is a self-quiz to see if you are ready.

excelnotesĀ andĀ excel2010_statsĀ areĀ guides more specific to statistics.


Python is an object-oriented programming language that is becoming more common in data science. I suggest that you begin to look at theĀ code academy intro course during the first week.


You shouldĀ install RĀ and RstudioĀ on your machine. (Rstudio is a convenient user-friendly interface for using R.)

Some brief tutorials to get you going:Ā 1a, 1b. Here is a nice portal for you to access all kinds of R resources. ThisĀ is the somewhat comprehensive tutorial that I myself used.

This class is supported by DataCamp, an intuitive learning platform for data science. Learn R, Python and SQL the way you learn best through a combination of short expert videos and hands-on-the-keyboard exercises. You can select from over 100+ courses by expert instructors on topics such as importing data, data visualization or machine learning and learn faster through immediate and personalized feedback on every exercise. As part of the course, you have free access to all their courses until July 29. Here’s the link to our group.Ā  You will be receiving an invitation to join via email. Your first assignment will be the intro course on R. If you already know R and don’t need this course or the subsequently assigned intermediate courses, let me know and I can find alternative assignments for you.

Leave a Reply

Your email address will not be published. Required fields are marked *