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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started