#Data Analyst / ranking opinion

27 messages Β· Page 1 of 1 (latest)

timid canyon
#

Test analysis of opinions on e.g. training courses

I try to get the answers right but sometimes he doesn't even count to 3, he makes up values and I'm confused about the answers when I ask him to justify these choices ... do you think there is a way to prevent this? if so how? Thanks πŸ˜‰

timid canyon
#

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.

glacial trench
#

Interesting, do you have an example use case?

timid canyon
#

the example are in the prompt after INPUT DATA πŸ˜‰

edgy charm
#

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

timid canyon
#

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.

timid canyon
#

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

timid canyon
#

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.

timid canyon
#

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.

edgy charm
#

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.

timid canyon
timid canyon
# edgy charm

A lot of errors in your sample πŸ˜‰ 15 values in table for 11 values and training exellent 3 but only 2 ........

timid canyon
#

no way ... they say me 11 element but the table have 12

timid canyon
#

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 ^^

edgy charm
#

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.

still gorge
#

What's the prompt

timid canyon
# edgy charm And yes, there are a lot of jokes on how bad it is with math. πŸ˜‚

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

timid canyon
# still gorge What's the prompt

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#