Fall 2017: Marketing Analytics (tentative and incomplete)

• Course Info

  • Course Syllabus (tentative)
  • Schedule (tentative), iCal format (downloads to your phone calendar)

• Optional references

  • Econometrics Reference Textbook: Mostly Harmless Econometrics
  • Excel References: John Walkenbach’s Excel Bible
  • Python References (there are tons of references online)
    • Automate the boring stuff
    • Quant-Econ
    • Wes Mckinney’s Python for Data Analysis

Lecture Notes + Homeworks (Tentative)

• Big Data/Digital Marketing – The future is here

  • Please get a head start by reviewing the material in this section before the start of the semester!
  • Lecture handout
    • Data:
      • Example 1
      • Example 2
      • Example 3
      • Example 4
      • Factor Variables
  • Excel Examples
  • Additional detailed notes from Dr. Borle at Rice
  • Basic Excel Cheatsheet
  • Assignment 1 (Due Thursday 9/14)
    • Submit here
    • Resubmit here (Only if you have submitted the original assignment)
    • Helpful Excel tutorials
      • Pivot tables
      • Enabling the data analysis toolpak (for regression)
      • Regression
      • Conditional formatting

• Introduction to Programming with Python

  • Download Anaconda
    • Download Anaconda with Python version 2.X (newest version of python 2)
    • Follow their installation instructions.
      • Install for all users
      • Check the box to add anaconda to path
    • If you haven’t done the above correctly, you need to add the directory where anaconda’s bin folder is saved (e.g. ‘/usr/anaconda/bin’) to the path environment variable.
      • Mac OS X: http://www.architectryan.com/2012/10/02/add-to-the-path-on-mac-os-x-mountain-lion/#.WcF879N97MV
      • Windows: https://medium.com/@GalarnykMichael/install-python-on-windows-anaconda-c63c7c3d1444
  • Lecture 2 handout, PDF format
    • In class problem set
      • Hints
        • ABC’s
        • Primes
      • Submit here
  • Lecture 3 handout, PDF Format
    • Zillow Data
      • file 1
      • file 2
  • Assignment 2
    • Submit here
    • Resubmit here (Only if you have submitted the original assignment)

• Getting the data

  • Get your API key for Yelp
  • Lecture 4 Handout, PDF Format
  • Lecture 5 Handout, PDF Format
  • Assignment 3
    • Mixed Beverage Data 
    • IMDB example, PDF Format
    • Submit here
    • Resubmit here

• Demand Models

  • Lecture 1 (linear demand) PDF Format
  • Lecture 2 (constant elasticity demand) PDF Format
    • Solutions to problems at the end PDF Format 
  • Cobb-Douglas & Games! supplement PDF Format
  • Assignment 4 PDF Format
    • Data for assignment
    • Submit here
    • Resubmit here

• Endogeneity

  • Endogeneity 1 PDF Format
  • Logit PDF Format
  • Assignment 5
    • Submit here
    • Resubmit here (by Thursday 10/19 6pm)

• More Discrete Outcomes

  • Windows Users: To install HDBSCAN, you need a C++ compiler, get it here:
    • https://www.microsoft.com/en-us/download/details.aspx?id=44266
  •  Classification/Clustering
    • Part 1 (PDF Format)
    • Part 2 (PDF Format)

• Natural Language Processing (NLP)

  • NLP intro
    • Movies data
    • Inauguration Addresses, Inauguration Dates, Voting Record
    • MGM Grand Reviews
  • Assignment 6 (Bonus)
    • MGM Grand Reviews
    • Download notes again after lecture, gets you started
    • Language Detection alternative: langdetect
      • https://pypi.python.org/pypi/langdetect?
    • Submit here (by Sunday 10/22 at 11:59pm)

Participation Surveys

1. Survey 1
2. Survey 2
3. Survey 3
4. Survey 4
5. Survey 5
6. Survey 6
7. Survey 7
8. Survey 8
9. Survey 9
10. Survey 10
11. Survey 11
12. Survey 12