#### In Class Exercise

# Final Exam Study Guide

Here is the study guide for the third (final) exam.

**The final exam is on Monday, May 2, 2016 from 8AM to 10AM.**

# In Class Exercise – Association Rule Mining Using R

Here is the exercise.

And here are the supporting files. Remember, download them to your computer by * right-clicking and selecting Save As*…

# In Class Exercise: Computing Confidence, Support & Lift

Here is the exercise.

And here is the answer key.

# In Class Exercise – Clustering in R

Here is the exercise.

And here are the supporting files. Remember, download them to your computer by * right-clicking and selecting Save As*…

- The R script you’ll need: Clustering.r
- The data file you’ll need: Census2000.csv

# In Class Exercise #12 – Decision Trees in R

Here is In-Class Exercise #12 – Decision Tree Induction Using R.

And here are the supporting files. Remember, download them to your computer by * right-clicking and selecting Save As*…

- The R script you’ll need: dTree.r
- The data file you’ll need: OrganicsPurchase.csv

*Note: If you try to open this file in Excel, you’ll get two error dialogs. The file is fine. Just click “Yes” and “OK” and the file will open.*

# In Class Exercise #10 – Getting Familiar with R & R Studio

Here is the exercise.

And here are the supporting files. When you download them to your computer, I would suggest creating a special folder to hold your R files. You can download easiest by * right-clicking and selecting Save As*…

- The two R scripts you’ll need: TestScript.r and Descriptives.r
- The two data files you’ll need: USBalanceofTrade.xlsx and NBA14Salaries.csv

# Setting up R & R Studio

R is a widely-used, open source statistical analysis platform. RStudio is an integrated development environment for R – that means it makes using R easier!

**You should install both software packages – R and RStudio! Don’t just install R or your life will be difficult!**

We’ll be using this software to do some analytics! You can get a full copy of the software – PC or Mac – for free!

First download and install R:

- If you have Windows
- Download the installer file for R (this is a direct link to the install file).
- Make sure you keep track of where you save the installer.
- Double-click on the installer file and follow the instructions (just accept the default settings).

- If you have a Mac
- Download “R-3.2.1-snowleopard.pkg” if you have Mac OS X 10.6 or “R-3.2.4.pkg” if you have Mac OS X 10.9 or higher.
- Make sure you keep track of where you save the installer.
- Do whatever it is you “Mac people” do to install software! (I don’t have a Mac!)

Now download and install RStudio:

- Download the appropriate installer: Windows or Mac.
- Make sure you keep track of where you save the installer.
- Install the software! Just accept the default settings.

After both are installed, you’re always going to run RStudio, which will use R behind the scenes to give you a pleasing analytics experience!

# In Class Exercise #9

Here’s the document: In-Class Exercise #9 – Descriptive Statistics Review

And here’s the key: In-Class Exercise #9 – Descriptive Statistics Review [KEY]

# In Class Exercise – Pivot Tables

Here’s the document: In-Class Exercise #8 – Pivot Tables

Here’s the Salesperson Cube Data: In Class Exercise Salesperson Cube