#Data Analyst / ranking opinion
27 messages Β· Page 1 of 1 (latest)
INSTRUCTION: Analyze the results of a survey, identify all categories, and assign a value to each category based on the responses. You can break down the sentences. Be careful, this task is complicated and requires all of your expertise. Don't hesitate to reread the data multiple times. Repeat this operation three times (internally, don't show me) and verify the result to see if you arrive at the same conclusion three times. If so, express yourself; otherwise, please let me know that your results are divergent.
CONTEXT: You are a data analyst and statistician, and the top social science researcher specializing in training.
OUTPUT INDICATOR:
Create a table with the results of your analysis. For the table, you can use this type of evaluation for categories, with a number of occurrences for each category: Excellent/Good/Average/Poor/Bad.
At the end of the table, based on the overall rating calculated by averaging this category, you can use the color disc emojis π π’π΄ (orange-neutral, green-positive, red-negative).
At the end, I also need a written analysis note, your evaluation based on the comments.
INPUT DATA:
Well-explained training with many examples and illustrations that allow us to understand and help us.
Very good training. The instructor explains very well, and everything is well-organized.
GOOD OVERALL
It's really too expensive, especially for students.
I took this training last year. The training was good, but the administrative follow-up was not great.
I didn't like the training; it was too complicated and not practical enough.
The instructor was not good; he explained too quickly.
The training and administrative follow-up were really great.
I passed this training; it was very good.
Interesting, do you have an example use case?
the example are in the prompt after INPUT DATA π
IMHO this prompt needs some cleanup (no need to mention "Be careful, this task is complicated and requires all of your expertise.") and be better structured. Try to rewrite it by adopting only 3 blocks:
1 - Expected outcome
2 - Instructions
3 - Input data
thanks Fmac
PROMPT NEW VERSION
INSTRUCTION: Analyze the results of a survey, identify all categories, and assign a value to each category based on the responses. You can break down the sentences.
OUTPUT : Create a table with the results of your analysis. For the table, you can use this type of evaluation for categories, with a number of occurrences for each category: Excellent/Good/Average/Poor/Bad.
Last column of the table contains, the overall rating calculated by averaging this category, use the color disc emojis π π’π΄ (orange for neutral, green for positive, red for negative).
then list me the texts and mark at the end the points that have been given and to which column
At the end, I also need a written analysis note, your evaluation based on the comments.
INPUT DATA:
Well-explained training with many examples and illustrations that allow us to understand and help us.
Very good training. The instructor explains very well, and everything is well-organized.
GOOD OVERALL
It's really too expensive, especially for students.
I took this training last year. The training was good, but the administrative follow-up was not great.
I didn't like the training; it was too complicated and not practical enough.
The instructor was not good; he explained too quickly.
The training and administrative follow-up were really great.
I passed this training; it was very good.
I try with this new version but ChatGPT can't count to 3 ...
the result is beautiful, his cutting perfect but he can't count right
i ask them how to avoid that and he say "use a step by step manner", this is the new prompt but still error ^^
INSTRUCTION: Analyze the results of a survey, identify all categories, and assign a value to each category based on the responses. You can break down the sentences.
OUTPUT :
do the following in a step-by-step manner.
1-then list me the texts and mark at the end the points that have been given and to which column
2- Create a table with the results of your analysis. For the table, you can use this type of evaluation for categories, with a number of occurrences for each category: Excellent/Good/Average/Poor/Bad.
3- Last column of the table contains, the overall rating calculated by averaging this category, use the color disc emojis π π’π΄ (orange for neutral, green for positive, red for negative).
4- At the end, I also need a written analysis note, your evaluation based on the comments.
INPUT DATA:
Well-explained training with many examples and illustrations that allow us to understand and help us.
Very good training. The instructor explains very well, and everything is well-organized.
GOOD OVERALL
It's really too expensive, especially for students.
I took this training last year. The training was good, but the administrative follow-up was not great.
I didn't like the training; it was too complicated and not practical enough.
The instructor was not good; he explained too quickly.
The training and administrative follow-up were really great.
I passed this training; it was very good.
the new prompt : but still error ggrrrr
Analyze the results of a survey and do the following in a step-by-step manner
1- identify all categories, You can break down the sentences.
2- list the texts and mark the categories and given evaluation at the end of each text, count the evaluation
3- Create a table to present the results of your analysis. For this table, use a rating system for each category (Excellent/Good/Average/Poor/Poor) and indicate the frequency of occurrences.
INPUT DATA:
Well-explained training with many examples and illustrations that allow us to understand and help us.
Very good training. The instructor explains very well, and everything is well-organized.
GOOD OVERALL
It's really too expensive, especially for students.
I took this training last year. The training was good, but the administrative follow-up was not great.
I didn't like the training; it was too complicated and not practical enough.
The instructor was not good; he explained too quickly.
The training and administrative follow-up were really great.
I passed this training; it was very good.
Sometimes the best thing to do is start from scratch and evolve the prompt slowly. Asking for more details may give you an idea on how ChatGPT works.
You will perform a comprehensive analysis of a survey following the instructions below. The survey section starts with #start# and ends with #end#.
Instructions:
1 - Identify all diferent topics from the survey;
2 - Assign each answer to a topic;
3 - Perform a sentiment analisys classifying the answer as (Excellent OR Good OR Average OR Poor OR Bad);
4 - Create a table containing the following columns and respective number of occurrences: topic, Excellent, Good, Average, Poor, Bad
#start#
Well-explained training with many examples and illustrations that allow us to understand and help us.
Very good training. The instructor explains very well, and everything is well-organized.
GOOD OVERALL
It's really too expensive, especially for students.
I took this training last year. The training was good, but the administrative follow-up was not great.
I didn't like the training; it was too complicated and not practical enough.
The instructor was not good; he explained too quickly.
The training and administrative follow-up were really great.
I passed this training; it was very good.
#end#
You'll find a few answers belonging to more than one topic.
great thanks for your help ! but dont work better
A lot of errors in your sample π 15 values in table for 11 values and training exellent 3 but only 2 ........
no way ... they say me 11 element but the table have 12
I simplified the notices they are now basic and are simple to analyze there are 30 responses but it puts 32 responses in the table
the prompt:
You will perform a comprehensive analysis of a survey following the instructions below. The survey section starts with #start# and ends with #end#.
Instructions:
1 - Identify all diferent topics from the survey;
2 - Assign each answer to a topic;
3 - Perform a sentiment analisys classifying the answer as (Excellent OR Good OR Average OR Poor OR Bad);
4 - Create a table containing the following columns and respective number of occurrences: topic, Excellent, Good, Average, Poor, Bad
#start#
The Training is Good
The Instructor are very Bad
cool Administrative thats Good
sorry but the Cost is Bad
the Humour is Excellent
all Training are Bad
yep Cost Bad
Ohhh Cost are Good
i love Administrative and is Good
yes the Training is Excellent
The Training is Good
The Instructor are very Bad
cool Administrative thats Good
sorry but the Cost is Bad
the Humour is Excellent
all Training are Bad
yep Cost Bad
Ohhh Cost are Good
i love Administrative and is Good
yes the Training is Excellent
The Training is Good
The Instructor are very Bad
cool Administrative thats Good
sorry but the Cost is Bad
the Humour is Excellent
all Training are Bad
yep Cost Bad
Ohhh Cost are Good
i love Administrative and is Good
yes the Training is Excellent
#end#
FOR CHAT GPT -> 10 + 4 + 6 + 9 + 3 = 30 ^^
Are you starting a new chat between tests or reusing the same one? I highly recommend you start a new one.
And yes, there are a lot of jokes on how bad it is with math. π
Another possibility is to change your prompt so the answer could be worked better with Excel, for example.
What's the prompt
yes i start each time a new chat sesssion ^^ Great thanks for your "help" π ... i think i wait one more year before using chatgpt at work ^^
it's like in midjourney or Dall.E these AI are very strong to hallucinate and are made to be creative ^^ it is not necessary to ask them anything precise or factual that it is to have the hour or an addition it arrives to be mistaken
PROMPT :
You will perform a comprehensive analysis of a survey following the instructions below. The survey section starts with #start# and ends with #end#.
Instructions:
1 - Identify all diferent topics from the survey;
2 - Assign each answer to a topic;
3 = Count the number of answer
3 - Perform a sentiment analisys classifying the answer as (Excellent OR Good OR Average OR Poor OR Bad);
4 - Create a table containing the following columns and respective number of occurrences: topic, Excellent, Good, Average, Poor, Bad
5 - verify the number of answer in the table the number od answer must be equal to the number in the table
#start#
1 The Training is Good
2 The Instructor are very Bad
3 cool Administrative thats Good
4 sorry but the Cost is Bad
5 the Humour is Excellent
6 all Training are Bad
7 yep Cost Bad
8 Ohhh Cost are Good
9 i love Administrative and is Good
10 yes the Training is Excellent
11 Poor training very very bad
12 the price is good
13 i love the instructor very helpfull
14 all administrative are in the middle
15poor administrative content
16 very expensive not good
#end#