Prompt lesson · 22 prompts
Data Analysis and Interpretation prompts for Laboratory Managers
22 ready-to-use prompts from our AI for Laboratory Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Cleaning and Quality Assurance
Use this when you need to clean and prepare a dataset for analysis by removing duplicates, fixing formatting, handling missing values, and addressing outliers.
Role You are a meticulous data analyst specializing in data cleaning and quality assurance. Your goal is to ensure the dataset is accurate, consistent, and ready for reliable analysis.
Context you provide
- {{dataset_description}}: A brief description of the dataset, including its source and structure.
- {{specific_fields}}: The fields or variables that need attention (e.g., 'customer_id', 'date', 'age').
- {{cleaning_goals}}: The specific issues to address (e.g., duplicates, formatting, missing values, outliers).
Instructions
- If any of the required context is missing, ask for it before proceeding.
- Analyze the dataset to identify issues in the specified fields, such as duplicates, inconsistent formatting, missing values, or outliers.
- For each issue found, provide a clear explanation and a suggested correction method (e.g., remove, impute, standardize).
- Prioritize corrections based on their potential impact on the analysis.
- Summarize the cleaning steps taken and the resulting improvements in data quality.
Output format Provide a structured report with sections for each issue type, including examples of problematic entries and the recommended fixes. Use bullet points for clarity, and include a final summary of the data quality improvements.
Guardrails
- Do not invent data or make assumptions about the dataset; base all findings on the provided information.
- Flag any ambiguous cases and suggest further investigation.
- Stay within the scope of data cleaning; do not perform full statistical analysis unless asked.
Example Dataset: 'sales_data.csv' with fields 'date', 'product', 'revenue'; cleaning goals: remove duplicates, standardize date format, and impute missing revenue values.
Open this prompt Analysis · Intermediate
Descriptive Statistics Summary
Use this when you need to calculate and interpret key summary statistics for a dataset to understand its central tendency and variability.
Role You are a statistical analyst who calculates and explains descriptive statistics to help users understand the key characteristics of their data.
Context you provide
- {{dataset_description}}: A description of the dataset, including its source and structure.
- {{variables}}: The specific variables or metrics for which you need descriptive statistics.
- {{criteria}}: Any filtering criteria, such as a time period or demographic group.
Instructions
- If any context is missing, ask for it before proceeding.
- For each specified variable, calculate the mean, median, and standard deviation, and include other relevant metrics like range, quartiles, and count.
- Interpret the results in plain language, explaining what the statistics indicate about the data's distribution and variability.
- Highlight any notable patterns or anomalies in the statistics.
- Provide a summary that is easy to understand for a non-technical audience.
Output format Present the statistics in a table format with columns for each metric and rows for each variable. Follow with a brief interpretation section that explains the significance of the numbers.
Guardrails
- Do not fabricate statistics; base all calculations on the provided data.
- If the data is not provided, ask for it or clearly state that you cannot calculate without the data.
- Keep the interpretation focused on the descriptive statistics, not on inferential analysis.
Example Dataset: 'customer_survey.csv' with variables 'age', 'satisfaction_score', and 'purchase_amount'; criteria: customers from the last quarter.
Open this prompt Analysis · Beginner
Inferential Statistics Analysis
Use this when you need to perform hypothesis tests, estimate population parameters, or assess relationships in your data.
Open this prompt Analysis · Intermediate
Data Visualization for Insights
Use this when you need to create charts and graphs to explore and communicate patterns in your data.
Open this prompt Creating · Beginner
Temporal Trend Analysis
Use this when you need to identify patterns and shifts in data over time to uncover emerging trends.
Open this prompt Analysis · Intermediate
Correlation Analysis Between Two Variables
Use this when you want to examine the relationship between two metrics in a dataset.
Open this prompt Analysis · Intermediate
Regression Analysis for Relationships
Use this when you need to model the relationship between a dependent variable and one or more independent variables to identify key drivers.
Open this prompt Analysis · Intermediate
Time Series Analysis for Trends
Use this when you need to analyze time-series data to identify seasonal patterns, anomalies, and future trends for planning and risk mitigation.
Open this prompt Analysis · Intermediate
Cluster Analysis for Data Segmentation
Use this when you need to identify natural groupings in your data to uncover patterns or segment your audience.
Open this prompt Analysis · Intermediate
Factor Analysis for Dimension Reduction
Use this when you need to uncover underlying latent factors in survey or behavioral data to simplify analysis and guide strategy.
Open this prompt Analysis · Advanced
Quality Control Data Analysis
Use this when you need to analyze quality control test results to identify anomalies, trends, and areas for improvement.
Open this prompt Analysis · Intermediate
Trend Analysis of Test Results
Use this when you need to analyze test results over time to identify patterns, fluctuations, and inform decision-making for laboratory processes.
Open this prompt Analysis · Beginner
Statistical Analysis of Experimental Data
Use this when you need to apply statistical methods to experimental data to uncover trends, correlations, and significance for research conclusions.
Open this prompt Analysis · Intermediate
Comparative Testing Method Analysis
Use this when you need to compare the effectiveness of different testing methods for a specific condition or context.
Open this prompt Analysis · Intermediate
Presentation-Ready Data Visualizations
Use this when you need to create compelling data visualizations for a presentation to stakeholders or executives.
Open this prompt Creating · Intermediate
Outlier Detection in Test Results
Use this when you need to identify and investigate outliers in experimental or test data to uncover potential issues.
Open this prompt Analysis · Intermediate
Predictive Modeling for Trends
Use this when you need to forecast future trends in laboratory operations, such as testing volumes, equipment downtime, or staffing needs.
Open this prompt Analysis · Advanced
Root Cause Analysis of Lab Errors
Use this when you need to identify the underlying causes of recurring errors in your laboratory processes and develop prevention strategies.
Open this prompt Analysis · Intermediate
Equipment Performance Monitoring
Use this when you need to analyze equipment performance data to identify trends, anomalies, and maintenance needs.
Open this prompt Analysis · Intermediate
Compliance Data Analysis
Use this when you need to analyze data for compliance with regulations and identify potential violations.
Open this prompt Analysis · Intermediate
Inventory Management Data Analysis
Use this when you need to analyze inventory data to identify trends, optimize stock levels, and reduce waste in a laboratory or supply chain setting.
Open this prompt Analysis · Intermediate
Cost Analysis of Testing Procedures
Use this when you need to identify cost-saving opportunities and resource allocation improvements in your testing procedures.
Open this prompt Analysis · Intermediate