Assignment Directions
In this assignment, you will use several functions in Excel to handle text processing problems from basic ones to more complicated tasks. You will need to perform tasks such as text cleaning, text extraction, and solving real world questions by flexibly applying formulas introduced in this week as well as a few functions learned from previous weeks. By completing the processing work, you will present your results and customize the visualization in Excel.
Please follow the instructions provided
Purpose
Text analysis has become increasingly popular among researchers. Various visualizations are frequently seen in our daily life, e.g., word cloud. Contrary to conventional wisdoms, Excel can handle quite a few different text handling tasks and provide a spreadsheet environment for non-coding users with a familiar workplace to hand text data.
Requirements:
For the assignment, students are required to:
Complete a number of data tasks in the attached document.
Transcribe your answer (or the image of your chart) to the Answer tab.