What companies use R for data analysis? Check the list compiled by listendata.com. Here are some examples:
- Facebook – For behavior analysis related to status updates and profile pictures.
- Google – For advertising effectiveness and economic forecasting.
- Twitter – For data visualization and semantic clustering
- Microsoft – Acquired Revolution R company and use it for a variety of purposes.
- Uber – For statistical analysis
- Airbnb – Scale data science.
- IBM – Joined R Consortium Group
- ANZ – For credit risk modeling
- New York Times – For data visualization
I got quite some questions related to Q4 and Q5 of Assignment #5, both of which ask you to create a pivot table first, and then use the excel AVERAGE function in a separate cell outside the pivot table.
Here is an example of what I mean by “use the Excel AVERAGE function to average those values … in a separate cell outside the Pivot Table.”
Let me know if you have any questions.
If you plan to use your own laptop for in-class activities, please set up R and RStudio on your computer before Thursday’s class. The instructions are available here: Setting up R and RStudio
Here are the instructions: Assignment #5 – Pivot Tables
You will need this VandelaySales2013.xlsx file to complete the assignment.
It is due 3/23/2017, 11:59 pm.
Please submit a word or pdf file on Blackboard. Your submission should include (1) the answer to each question and (2) the Pivot Table or Pivot Chart created to answer the question (unless otherwise specified).
See instructions here: Assignment #3: SQL Part 2
For this assignment, you will need to use MySQL Workbench to finish building the contact management database for MarketCo that you started during ICA #6. Therefore, you must complete the in-class activity before you do this assignment.
It’s due on Thursday, 3/2/2017, 11:59 pm. Please submit your assignment on Blackboard.
Some students mentioned that they would like to practice on ERD/schema/SQL questions.
Here is an additional ERD and Schema exercise for practice: Additional ERD and Schema Exercise
Here are some additional practice questions on advanced SQL queries (Joining tables, LIMIT, and subselects): Additional Pen-and-Paper SQL Query Exercise (NOTE that Advanced SQL queries — Joining tables, LIMIT, and subselects — will not be covered in Exam 1)
Both exercises will not be collected. Solutions are already included.
Here is the Exam 1 Study Guide.
Remember, there will be an in-class review session on February 16. The exam is February 21 during class time.
I just found an interesting research paper analyzing the effect of Super Bowl ads on movie box office sales: Super returns to Super Bowl ads? (by ).
One of the authors of the paper is my PhD advisor Michael D. Smith, and another author is Hal Varian, the chief Economist of Google and the author of a few Econ textbooks. They find that the movies that had Super Bowl ads got an additional $8.4 million sales in the opening weekend compared to movies without Super Bowl ads, whereas the cost of a Super Bowl ad is $3 million.
The study is interesting in that it mimics a random experiment — firms have to decide whether to purchase Super Bowl ads long before they know which teams will be playing. Thus, the winners of the NFC and AFC Championship games are random to the audience in the home cities of the winning teams. Therefore, the authors compare the increased sales of the advertised movie in the home cities of the winning teams, to the increased sales of the advertised movie in home cities of “near-qualifying” teams. The relative difference in the increased sales can be attributed to Super Bowl ads.