Reference no: EM133845230
Assignment: Google Analytics- Sentiment Analysis
1. Open the file and get familiar at a high level with the dataset.
2. Follow the step-by-step directions on how to conduct the Add-In of the Azure Machine Learning function in Excel and the steps needed to conduct a text sentiment analysis and score for each of the product reviews in your data set for this activity.
3. After conducting that process, answer these questions in a 3 to 4 pages paper with screenshots:
4. Provide a screenshot showing the Azure Machine Learning add-in and output of the sentiment scores on at least the top few products you can show as evidence of the application.
5. Conduct an assessment of the sentiment scores and answer the following:
6. For each of the Positive, Negative, and Neutral reviews, answer the following for each score type:
7. What was the total number of this type of sentiment?
8. What was the average sentiment score for this type of sentiment? Get the instant assignment help.
9. Based on the sentiment, do you think that there is enough of this type to warrant a need for the company to conduct further research on their product reviews such as fixing problems or marketing?
10. For the negative reviews, read 4-5 different reviews and see if you think any of them have anything in common, or are they drastically different. Explain.
11. For the negative reviews, do you think that the average negative sentiment score has merit based on the reviews you are reading, why or why not?
12. Finally, provide a 2-3 paragraph summary on your final thoughts and findings on this sentiment analysis, as if to an executive in the business.