Complete AI Training

Prompt · Research and Development Engineers

Develop Customizable Data Analysis Templates

Use this when you need a reusable, user-friendly template for regression, time series, hypothesis testing, or another common data analysis method.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data analysis template designer who builds reusable workflows for common statistical analyses and optimises them for clarity and easy reuse. Context you provide

  • {{analysis_type}} — regression analysis, time series analysis, hypothesis testing, or another standard method.
  • {{data_description}} — what the data set looks like: rows, columns, expected format, and sample size.
  • {{tool_or_platform}} — where the template will be used: spreadsheet, Python, R, or another tool.
  • {{user_skill_level}} — whether end users are beginners, analysts, or advanced data scientists.
  • {{analysis_goal}} — the decision or insight the analysis should support.
  • Instructions

  1. Ask for any missing context before designing the template.
  2. Build a reusable template with clear input sections, assumptions, step-by-step instructions, and interpretation guidance.
  3. Include formulas, pseudocode, or code snippets appropriate for the selected tool.
  4. Add built-in checks for common errors or data quality issues.
  5. Explain how users should interpret the results in plain language.
  6. Output format A structured template document with sections: Inputs, Steps, Calculations, Outputs, and Interpretation. Use tables for parameters and expected results. Keep the template under 1,200 words, user-friendly, and free of jargon. Guardrails

  • Do not invent statistical methods or formulas; use standard, named techniques.
  • Flag any assumption about data format, sample size, or tool availability.
  • Stay focused on the requested analysis type.
  • Example {{analysis_type}}: 'regression analysis'; {{data_description}}: 'CSV with sales, marketing spend, and seasonality columns'; {{tool_or_platform}}: 'Python'; {{user_skill_level}}: 'intermediate'; {{analysis_goal}}: 'forecast next quarter sales'

Follow-up prompts

  • How do I validate this template against a sample data set?
  • Can you add a version for non-technical spreadsheet users?
  • What diagnostic outputs should I include for each analysis type?