Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Mathematics With Early Integers

Authors: Charles P McKeague

1st Edition

1936368978, 9781936368976

More Books

Students also viewed these Mathematics questions

Question

What type of office space and equipment are provided?

Answered: 1 week ago