Instructor: Jing Gong

Jing Gong

Jing Gong joins the Fox School on a tenure-track appointment from Carnegie Mellon University, where she studied for a PhD in Information Systems and Management. She is interested in using empirical models to analyze firm and consumer behavior in online markets, with primary focuses in electronic commerce, digital marketing, two-sided online markets, online labor markets, and business analytics. Her research uses interdisciplinary approaches such as econometrics, Bayesian statistics, economic structural modeling, field experiment, and text analytics. Jing’s work has appeared in several major conferences and workshops including International Conference on Information Systems (ICIS), Workshop on Information Systems Economics (WISE), Conference on Information Systems and Technology (CIST), Marketing Science Conference, and China Summer Workshop on Information Management (CSWIM). She was the 2014 recipient of the Best Student Paper Award at the Conference of Information Systems and Technology and the 2014 Best Paper Award runner-up, at the China Summer Workshop on Information Management. Jing holds a Bachelor's Degree in Information Management and Information Systems from Tsinghua University in Beijing, China.
1 2 3 5

Additional Topics: Accessing MySQL from R & Linear Regression

Here are some materials for two additional topics. These are optional and will not be covered in the third exam.

1. Accessing MySQL from R. The MySQL-Example.r script demonstrates how to query the moviedb schema on our class server using R. It will work with your MySQL account. With this nice tool you can extract data directly from a database by using SQL-statements, so that data can be analyzed in R.

2. Linear Regression is a statistical method to analyze the relationship between an continuous outcome variable and one or more predictor variables.

( Association Rules) Fix for Issue Related to Installing the Packages

If you get errors installing packages when running the aRules.r script, try the following:

1. Change lines 29~33 into the following. The original script uses CMU site ( as the repository to download the packages. But the CMU site seems to be broken today. The new lines use default R package repository, which seems to work today.

if (!require(“arules”)) { install.packages(“arules”)
require(“arules”) };

if (!require(“arulesViz”)) { install.packages(“arulesViz”)
require(“arulesViz”) };

2. If step 1 does not work, try to set the repository to a different one by following the instructions below:

1) In RStudio, go to Tools/Global Options…

2) Click on Packages (on the left).

3) Click on Change… under CRAN Mirror.

4) Choose one of the USA sites at the end (e.g., try the one in Dallas, TX).

5) Rerun the script. It should work. If not, try a different USA site.

If it doesn’t, let me know!


Last Weekly Question (Due Friday, December 4)

Leave your response to the question below as a comment on this post by the beginning of class on December 4, 2015. It only needs to be three or four sentences.

Answer one, two or three of the questions below. (Note: If you’d like to present in class. You need to pick Question 1.)

  1. Name and describe a business question that you could answer using association rules. What data would you collect to perform the analysis? Don’t use an example we’ve covered in class.
  2. What was the most important takeaway (from your perspective) from this course? If you had to explain to a future MIS2502 scholar what this course was about, what would you say?
  3. Our review for the final exam is during class on December 4. What question about the material we’ve covered so far would you like to discuss during the review?
    (NOTE: Focus on your understanding of the material, not “will x be on the exam?”!)


Weekly Question #9 (Due Friday, November 20)

Leave your response as a comment on this post by the beginning of class on November 20, 2015. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class! If you sign in using your AccessNet ID and password you won’t have to fill in the name, email and captcha fields when you leave your comment.

Answer one of the two questions below (not both):

  1. Name and describe a business question that you could answer using clustering. What data would you collect to perform the analysis? Don’t use an example we’ve covered in class.
  2. Let’s say you performed a cluster analysis and came up with a series of market segments, describing the demographics of three different sets of customers for your business (big spenders, average spenders, small spenders). Your manager is reluctant to trust your analysis because she has a lot of experience and this contradicts what she believes is true about her customers. How would you convince her that your analysis is correct?

(Assignment 8) Error Installing the caret Package and Deadline Postponed

If you had problems downloading the “caret” package when running the script dTree.r, try a different computer.

Unfortunately, the computers in the Tech Center do not have R/RStudio installed. However the computer labs at Fox do have R/RStudio and seem to have no issue with the caret package (Thanks to Ashton Andrews for pointing this out). Here is the list of computer labs and hours within Fox:

Since the problem is a computer related issue and I am not sure if the labs are open on Sunday, I am going to move the deadline for the Decision Tree assignment to Wednesday, November 18 at 11:59 pm. It was originally due on Monday, November 16. If you have already submitted the assignment, there is no need to resubmit it.

1 2 3 5