Question: Please follow the instructions below to complete the tasks. Open the dataset review_helpfulness_practice.xlsx file. Run a correlation matrix that includes the following variables: review helpfulness

Please follow the instructions below to complete the tasks.

  • Open the dataset review_helpfulness_practice.xlsx file.
  • Run a correlation matrix that includes the following variables: review helpfulness (votes), rating, review length (i.e., number of words in the review text), and photo (i.e., a binary variable indicating whether the review contains a photo or not).
  • Run a simple regression analysis and answer the questions below:

1) How does the length of product review (i.e., number of words) affect the customers' perception of review helpfulness (i.e., voting review as helpful)?

2) Would posting photo affect the customers' decision to vote a review as helpful?

3) What is the relationship between rating and review helpfulness?

  • Write down a few sentences to explain 1) whether there is a significant relationship between the two variables and 2) conditioned on the significant relationship, how does one-unit increase of X affect the change of value of Y.

Please submit a .xlsx file on Canvas. In the Excel file, you need to have the original datasheets from the file review_helpfulness_practice.xlsx with the new variables created (e.g., review length, a binary variable of photo), a correlation matrix, three simple regression outputs. Please write down the findings (i.e., the last point) right below the regression output in each data sheet.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!