Unit 4 / 11

Survey Design and Quantitative Data Analysis

Gains:

  • Ability to detect leading, double and ambiguous traps in survey questions and connect each question to a concept
  • Ability to perform real statistical calculations in a program and use artificial intelligence only for method selection and interpretation
  • Ability to distinguish statistical significance from practical significance and check test assumptions

Quantitative research is an approach that measures social phenomena with numbers and analyzes them with statistics: it seeks answers to questions such as how many people, at what rate, what difference is there between which groups. The most common tool for this approach is the survey—a method of collecting comparable data from a large number of people using standard questions. Setting up a good survey and analyzing incoming data correctly requires skill; A bad question spoils the result from the very beginning. In this unit, you will learn how to use AI to design survey questions, construct scales (response options that rate an attitude, e.g. "strongly agree … strongly disagree"), and analyze incoming data; but you will learn why you should retain statistical judgment.

Where AI is most valuable in quantitative analysis is not in the calculation itself, but in explaining how to do the calculation and what the result means. The AI ​​can outline analysis code for you (e.g. commands to run in R or Python), explain in plain language when to use a statistical test, and help you interpret the output. But never trust the numbers the AI ​​generates “off the top of your head” in text: a language model is not a calculator and may produce the wrong mean, percentage or p-value. The actual calculation is done in a real statistics program.

Step by step: from survey to review

1. Link each question to a concept. Every question you put in the survey should measure a concept in your research question. Don't add questions just because "it would be interesting." AI helps you check the concept-question mapping in a table.

2. Weed out bad questions. Leading ("Are you satisfied with this great service?"), double-question ("Was the service fast and cheap?"), vague ("Did you like it often?") questions distort the data. AI is good at flagging these pitfalls in your draft survey.

3. Establish the scale consistently. If you are using a Likert scale (a 5- or 7-point agreement scale), keep the direction and ratings consistent throughout the survey. AI catches inconsistencies.

4. Clear data. Incoming data may contain missing answers, inconsistencies, or two records of the same person. AI can list cleanup steps and draft code; You decide.

5. Choose the correct test and INTERPRET it. Are you comparing two groups, looking for a relationship? AI explains which test is appropriate; It is your job to run the test in the program and read and make sense of the output.

Attention: Do not tell the AI ​​"calculate the average of this data" and write the resulting number directly into the report. The language model makes errors in arithmetic. Have the calculation done in a spreadsheet or statistics program; Use AI only for its method and interpretation.

three mini cases

Case 1 — Leading question corrected. A survey draft asked "How satisfied are you with the transportation service of our successful municipality?" He had a question. AI marked that the adjective "successful" pushed the answer to the positive. The question is "How do you evaluate the municipality's transportation service?" was neutralized and the results were more balanced.

Case 2 — AI miscalculation caught. A researcher pasted 300 lines of data as text into the AI ​​and said "find the average age"; YZ said 34.2. When the same data was put into a table, the actual average was 31.7. The AI ​​had miscalculated within the text; It was fixed when the account was moved to the program.

Case 3 — Test selection clarified. A team wanted to compare the average score of two groups but did not know which test to use. YZ explained that the t-test (a test that tests whether the difference between the means of two groups is random) was appropriate for "two independent groups, a continuous variable", listed his assumptions, and provided a draft of the code. The team ran the test in the program and interpreted the result.

Four copyable templates

1) Survey question audit:

Review the survey questions below. Check for each question: is it leading, is it a double question (two things in one question), is it ambiguous, are the answer options overlapping/missing? Give the problem and a better version side by side. Check if the scale direction is consistent.Questions: [here]

2) Concept-question mapping table:

My research question: [question]. My key concepts: [list]. Arrange the following survey questions in a table: what concept does each question measure? Mark questions that do not connect to any concept ("extra") and concepts that have no questions ("idle"). Poll: [here]

3) Data cleaning plan (code draft):

I have a survey dataset with the following variables: [variables]. Give me a data cleansing checklist and code draft WITH COMMENT LINES for [R/Python]: missing data, outliers, duplicate records, inconsistent coding. I will run the code and verify the output; Don't do the math.

4) Statistical comment (I did the calculation):

I ran a [test name] and got the following output: [output]. Interpret this result in plain language: what it means in practice, distinguish between statistical significance and practical significance, and remind you which assumptions need to be checked. Do not exaggerate the result; Tell me your limits too.

Weak prompt / Strong prompt

Weak prompt:

Calculate the means of the groups in this data and tell which one is higher. [500 lines of data]

AI tries to calculate within the text and may produce wrong numbers. Moreover, it is unreliable to answer the question "Is there a significant difference" without statistical testing.

Powerful prompt:

I want to compare the scores of two groups: a continuous variable, two independent groups. (1) Which statistical test is appropriate and why? (2) What are its assumptions? (3) Comment code draft for [R/Python]. I will do the calculation in the program; You just give the method and code, don't generate numbers.

The difference: AI is no longer used as an unreliable calculator, but as a reliable method advisor.

Division of labor in quantitative tasks

Quest

Is AI safe?

How to use

Question design audit

Yes

Marking traps

Scale consistency

Yes

checklist

Data clearing code

Yes (draft)

You run the code

In-text account

no

Never trust

Test selection

Yes

Explain the method

Concluding comment

Yes (support)

It's up to you to judge

Common mistakes

  • Directly using the number generated by the AI. The language model is wrong in arithmetic; Make the calculation into the program.
  • Putting a leading question. Adjectives and assumptions distort the answer.
  • Confusing statistical significance with practical significance. "Significant" can even be a small difference; Look at the size.
  • Skipping the assumptions. Every test has prerequisites; Do not comment without checking.
  • Asking extra questions. Each survey question should be linked to a concept; the rest inflates the data.

In summary

AI in quantitative research; He is a strong consultant in catching the pitfalls of survey questions, concept-question mapping, drafting data cleaning and analysis code, and interpreting the result in plain language. But never let the AI ​​do the actual calculation; The language model is not a calculator. You choose the test, but you run it in the program, read the output, and distinguish between statistical significance and practical significance. AI speeds up the method; The responsibility for the issue and comment is yours.

Application task

Write a draft survey with 10 questions. Have the AI ​​flag and correct leading, duplicate, and ambiguous questions with the “Poll question audit” template. Then create a small sample data set (20-30 rows) and calculate the actual mean and percentages in a spreadsheet program; Give the same data to AI as text, compare it with the resulting numbers and report the difference. Finally, have a test output interpreted with the "statistics interpretation" template.

checklist

  • [ ] I linked each survey question to a concept.
  • [ ] I eliminated leading, double and ambiguous questions.
  • [ ] I did the actual calculation in the statistics program, not the AI.
  • [ ] I checked the test assumptions.
  • [ ] I distinguished statistical significance from practical significance.