Problem Set 1: Introduction to R and Tableau

Part 1: R

  1. Create a variable called myage and assign it the value of your age.

  2. Create a vector called grades containing the following values: 88, 92, 75, 99, and 80.

  3. Using indexing, print the third element of the grades vector to the console.

  4. Create a data frame called student_info containing the following columns: Name, Age, Major, Absent. The data should be as follows:

Name Age Major Absent
John 20 AgBiz TRUE
Emily 22 ENRE TRUE
Michael 19 ENRE FALSE
Jessica 21 AgBiz FALSE

  1. Download the Supermarket Sales data in csv format to a known location on your machine. The dataset should be called supermarket_sales.csv. Using the setwd() function, set your working directory to the location where you have a file called supermarket_sales.csv

  2. Using the read.csv() function, read in the file supermarket_sales.csv and assign it to an object called mydata.

  3. Install and load the package readr.

  4. Write a brief explanation of what you did in steps 1-7 and how it relates to the tutorial we did in class.

Part 2: Getting Started with Tableau

We will be using two Tableau products in this course (although there are many more - see handout): Tableau Desktop and Tableau Public. Tableau desktop typically requires a paid subscription, but as students (and teachers) we get it for free. Your assignment for this week is to be fully prepared to use these two Tableau products on your personal computer.

  1. Visit Tableau Desktop and download Tableau Desktop using the 14-day free trial. You can enter your product license key once you receive an email with your academic license. Take a screenshot of Tableau Desktop open on your computer.

  2. Visit Tableau Public and create an account. You will use this account to host your data visualizations, which you can then embed on your google site. You will be required to use this to upload homework assignments.

How to Submit

You should create a new webpage on your google site titled Problem Set 1. This webpage should include your responses to both Parts 1 and Parts 2 of the problem set. Part 1 should display the contents of your log file generated when you source your R script and your answer to question 8 in paragraph form. Review the instructions in the lab to see how to generate the log file. Part 2 should contain your evidence of completing steps 1 & 2 and a link to your Tableau Public site. Submit the link to your google site webpage in Canvas.