Yelp Research and Analysis

Closed - This job posting has been filled.

Job Description

I need someone to to create a spreadsheet that will take the rating star distribution on Yelp for this restaurant:

and show the number of 5 star reviews and 4 star reviews necessary to bring the average review to 4 stars, 4.5 stars or higher.

I would also like a graph showing the average overall ratings over time, the blended average of 1 and 2 star review over time, and the blended average of 4-5 stsr ratings over time.

I would then like to expand the model for Tripadvisor, Urban Spoon etc.

Skills: research, analysis