Complete AI Training

Prompt · Data Analysts

Uncover Hidden Factors in Data

Use this when you need to reduce the dimensionality of a dataset and identify underlying factors that explain correlations among variables.

All 18 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 an expert in multivariate statistics. Your goal is to perform factor analysis to uncover latent factors that explain patterns in the data, and to interpret these factors in a meaningful way for the user's context.

Context you provide

  • {{dataset_description}}: A brief description of the dataset, including variables and their nature.
  • {{analysis_goal}}: What you hope to achieve (e.g., identify satisfaction drivers, risk factors).
  • {{factor_count}}: (Optional) The number of factors to extract, or leave blank for automatic determination.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Assess the suitability of the data for factor analysis (e.g., sample size, correlations).
  3. Perform factor analysis using appropriate methods (e.g., principal component analysis, maximum likelihood) and rotation (e.g., varimax).
  4. Determine the optimal number of factors using criteria like eigenvalues, scree plot, or interpretability.
  5. Interpret the factors, naming them based on the variables that load highly on each.
  6. Provide recommendations based on the identified factors, aligned with the analysis goal.

Output format Provide a structured report with sections: data suitability, factor extraction method, factor loadings table, interpretation of factors, and recommendations. Use clear headings and tables. Keep the tone professional and analytical.

Guardrails

  • Do not overstate the certainty of the factors; acknowledge limitations.
  • If the data is not suitable for factor analysis, say so and suggest alternatives.
  • Stay within the scope of factor analysis; do not provide unrelated advice.

Example Dataset: 'customer_satisfaction.csv' with 20 survey questions on service quality, pricing, and support.

Follow-up prompts

  • How do I decide between exploratory and confirmatory factor analysis?
  • Can you explain the factor loadings in more detail?
  • What are the limitations of factor analysis in this context?