Analyze Survey Data with an AI Chatbot
In ChatGPT or Claude, cut and paste the following prompt to disaggregate and analyze quantitative and qualitative survey data. To get started, replace the words in the brackets with the correct information for your context before copy/pasting.
NOTE: make sure to remove all personally identifiable information from the data you will be uploading into the chatbot.
Analyze Survey Data Prompt
You are an expert researcher and data analyst with knowledge of [TOPIC]. [DESCRIBE YOUR ROLE AND ORGANIZATION TYPE]. I have attached a dataset from a recent [TYPE] survey that includes both quantitative and qualitative responses. Your task is to analyze the data and identify key trends and related action steps. Please include the following in your analysis: 1. Quantitative data analysis: [DESIRED DESCRIPTIVE STATISTICS-MEAN, MEDIAN, ETC.] for each quantitative question and identify any significant correlations between different quantitative variables 2. Qualitative data analysis: perform sentiment analysis on open-ended questions and extract key words or phrases that appear frequently. Do not include common words like the, and, and for, but focus on concepts specific to [TOPIC OF SURVEY] 3. Cross-analysis: look for relationships between quantitative and qualitative data points 4. Identify outliers and explain them in the context of the other data 6. Provide key insights: identify 3-5 significant trends or insights from the data and suggest actionable recommendations for [ORGANIZATIONAL GOAL CONNECTED TO DATA].
Example Prompt
You are an expert organizational psychologist and data analyst specializing in change management and technology adoption. I am the assistant superintendent of a mid-sized school district just starting to implement generative AI. I have attached a dataset from a recent organizational survey that includes both quantitative and qualitative responses. Your task is to analyze the data and identify key trends and related action steps. Please include the following in your analysis: 1. Quantitative data analysis: calculate basic descriptive statistics (mean, median, mode, standard deviation) for each quantitative question and identify any significant correlations between different quantitative variables 2. Qualitative data analysis: perform sentiment analysis on open-ended questions and extract key words or phrases that appear frequently 3. Cross-analysis: look for relationships between quantitative and qualitative data points 4. Provide key insights: identify 3-5 significant trends or insights from the data and suggest actionable recommendations for developing comprehensive guidance on generative AI that address stakeholder needs and align to our mission of meeting the needs of all learners.
Additional Prompting Strategies
Revise the prompt to focus on either quantitative or qualitative results depending on the nature of your data
Suggest ways to improve the survey to elicit more accurate data
Identify key areas of interest in the dataset
Request a detailed explanation of correlational data
Ask for the key findings to be formatted as a chart
Prompt the chatbot to suggest any additional analyses or follow-up surveys that could provide deeper insights into the topic
Want to partner with AI for Education at your school or district? LEARN HOW
