Phoenix - Your AI AssistantQualitative analysis - Classifying tesxt and scoring sentiment
- Posted:
- Proposals: 16
- Remote
- #3966145
- Expired
Bahawalpur 
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I am hoping you might be able to help me with a project where I need a very quick turnaround!
I need to create a table of major themes and sentiment from the text feedback within an Engagement survey.
I am attaching the following files:
1) Example file "NM Comments Extract and Analysis"
The Excel file has two worksheets;
Analysis - This shows how we classified the text in a previous survey (columns B and C), giving each statement a series of classifications (Column D) and a Sentiment (Column D) that was Negative,Neutral or Positive.
Summary Parsed - Shows how we grouped the classification into themes
You are more than welcome to use the Classifications in the Example File as a starting point for your analysis in the Working file. (e.g. Communication, Pay, Management, Training, Stress, etc)
2) Working file (SG Comments Extract)
This has just one worksheet: Raw Data
You will see there are more columns of text because each year had slightly different questions.
I need to have the Working File analysed in the same way as the Example File, with the exception that I want to extend the Sentiment to 5 scale items (Very Positive, Positive, Neutral, Negative, Very Negative)
There are over three hundred responses (rows) over three years (2019 to 2022) in the full Working File. I am only providing a few here to be sure that you are happy with the project. To prove that you understand the project could you please complete rows 3, 8 and 12 from the Working File.
If you believe that you can produce a better form of analysis then I am more than happy to discuss, however I must have the classification and sentiment as an absolute minimum.
I need this completed really urgently, by Monday 5th June at the latest
As you can see from the files you will need an exceptionally high standard of English to complete this.
Can you let me know if you are comfortable with the project requirement and delivery schedule and how much you would charge for this?
Many thanks
Chris
I need to create a table of major themes and sentiment from the text feedback within an Engagement survey.
I am attaching the following files:
1) Example file "NM Comments Extract and Analysis"
The Excel file has two worksheets;
Analysis - This shows how we classified the text in a previous survey (columns B and C), giving each statement a series of classifications (Column D) and a Sentiment (Column D) that was Negative,Neutral or Positive.
Summary Parsed - Shows how we grouped the classification into themes
You are more than welcome to use the Classifications in the Example File as a starting point for your analysis in the Working file. (e.g. Communication, Pay, Management, Training, Stress, etc)
2) Working file (SG Comments Extract)
This has just one worksheet: Raw Data
You will see there are more columns of text because each year had slightly different questions.
I need to have the Working File analysed in the same way as the Example File, with the exception that I want to extend the Sentiment to 5 scale items (Very Positive, Positive, Neutral, Negative, Very Negative)
There are over three hundred responses (rows) over three years (2019 to 2022) in the full Working File. I am only providing a few here to be sure that you are happy with the project. To prove that you understand the project could you please complete rows 3, 8 and 12 from the Working File.
If you believe that you can produce a better form of analysis then I am more than happy to discuss, however I must have the classification and sentiment as an absolute minimum.
I need this completed really urgently, by Monday 5th June at the latest
As you can see from the files you will need an exceptionally high standard of English to complete this.
Can you let me know if you are comfortable with the project requirement and delivery schedule and how much you would charge for this?
Many thanks
Chris
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
1) Can you provide further details on the desired format and structure of the final table summarizing major themes and sentiment scores?
2) Do you have any specific guidelines or criteria for assigning sentiment scores on the five-point scale (Very Positive, Positive, Neutral, Negative, Very Negative)?
3) Could you clarify the level of detail you expect for the analysis? Are you looking for an overall summary or a more granular breakdown of themes and sentiments?
4) Is there a baseline performance for grading the accuracy of the sentimental system? -
Are you have any sensitivity to using ChatGpt at Excel to help me during these operations