skip to Main Content

1. Please download and open the file Feedback on Shoes.xlsx2. Some feedback data

1. Please download and open the file Feedback on Shoes.xlsx2. Some feedback data has aleady loaded into the spreadsheet “Shoes” for you.3. Please follow the procedures from the video clip to perform your sentimentanalysis.4. Please eye ball the review column and create a few theme categories as you seefit.5. Complete the numbering in Column A and complete the codes based on thethemes.6. Complete coding in Column D for every review feedback.7. Use the formula CountIf() to calculate frequency for each feedback theme inFrequency column and calculate the percentage over the total number of reviewsfor each in % column.8. Please also create a chart based on the result.9. If you can perform such text mining over EBay data set on the next spreadsheet(in the same workbook), you can win 10 bonus points on this assignment.10.Hint: when some feedback contain several themes, you may have to copy andpaste to split these theme based reviews into several new rows before coding.Nowadays, there are many Excel add-in tools to help ease the work on textmining. However, text mining using simply an Excel worksheet helps you to seethe work logic of how text mining is handled.

GET HELP WITH THIS PAPER TODAY

Do you need help working on this assignment? We will write a custom essay on this or any other topic specifically for you.

Back To Top