#### In-Class Exercises

# In-Class Exercise #13: Clustering 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*…

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

# In-Class Exercise #12: Decision Trees 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*…

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

(Note: If you get errors when you double-click to open the csv file, you can ignore them (click yes or OK. The file is fine.)

# In-Class Exercise #11: Calculating and Interpreting Chi-Squared Statistics

Here is the exercise.

And here is the answer key.

# In-Class Exercise #10: Getting Familiar With R-RStudio

Here is the exercise.

And here are the supporting files. Remember, download them to your computer 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

# In-Class Exercise #9: Descriptive Statistics Review

Here is the exercise.

And here is the answer key.

# In-Class Exercise #8: Pivot Tables in Excel

Here is the exercise.

And here is the worksheet you’ll need for the exercise [Salesperson Cube.xlsx].

# In-Class Exercise #7: Creating Infographics with Piktochart

Here is the exercise.

And here are the files you’ll need (right-click on the files and select Save As… to save the file to your computer):

# In-Class Exercise #6: Putting Information into a Database (SQL In)

Here is the exercise.

And here is the answer key.

# In-Class Exercise #5: Getting Information Out of a Database (SQL Out)

Here is the exercise. And here is the movie rental schema you’ll need to do the exercise.

Here is the solution.

# In-Class Exercise #4: Pen and Paper Query Exercise

Here is the exercise.

And here is the answer key.