Data Analysis
Summarize Trends from a Series of Notes
Analyze the following key points/action items from a series of [Number] meetings about '[Project/Topic Name]' held between [Start Date] and [End Date]...
Explain Complex Data Analysis Concepts
Explain the following data analysis / statistics / machine learning concept in simple terms, suitable for someone without a deep technical background:...
Calculate Descriptive Statistics
Provide the code ([Language/Tool, e.g., Python/Pandas, R, SQL]) or Excel function(s) to calculate the following descriptive statistics for the variabl...
Define Clear Analysis Goals
Help me define specific, measurable analytical goals based on this business problem/objective: '[Describe the general problem or objective, e.g., We w...
Suggest Data Cleaning Techniques
Suggest data cleaning techniques or generate code ([Specify Language/Tool, e.g., Python/Pandas, R, SQL]) for handling the following issue in my datase...
Generate Exploratory Data Analysis (EDA) Steps/Code
Generate starter code in [Language/Library, e.g., 'Python using Pandas, Matplotlib, and Seaborn', 'R using dplyr and ggplot2'] for performing basic Ex...
Identify Appropriate Statistical Tests
Suggest appropriate statistical test(s) to use for the following hypothesis/research question: '[State your hypothesis clearly, e.g., 'Is there a stat...
Interpret Statistical Results
Explain the meaning of these statistical results in the context of my research question: '[State your research question/hypothesis briefly]'. Test Per...
Suggest Data Visualization Types
Recommend the most effective type(s) of data visualization (e.g., bar chart, line chart, scatter plot, histogram, box plot, heatmap) to show the follo...
Generate Code for Data Visualizations
Generate starter code in [Language/Library, e.g., 'Python using Matplotlib/Seaborn', 'R using ggplot2'] to create a '[Specific Chart Type, e.g., 'grou...
Identify Patterns, Trends, or Outliers (Conceptual)
Suggest analytical techniques or specific functions/methods (mention tool if relevant, e.g., Excel, Python/Pandas, R) to identify potential [patterns...
Draft Analysis Summaries or Reports
Draft a concise summary paragraph or bullet points for a data analysis report section. Target Audience: [e.g., Non-technical executives, Marketing te...
Generate Python/R Code for Specific Analyses
Generate starter code in [Language/Library, e.g., 'Python using Scikit-learn', 'R using lm function', 'Python using Statsmodels'] to perform the follo...
Identify Key Recruitment Metrics (KPIs)
Identify and briefly define 5-7 key performance indicators (KPIs) that are essential for measuring the effectiveness and efficiency of a recruitment p...
Set Up Data Validation Rules
Explain how to set up an Excel data validation rule for the range [Specify cell range, e.g., C2:C100] to ensure that users can only [Describe the rest...
Generate Sample Data Sets
Generate a table of realistic sample data with [Number] rows for testing or demonstration purposes. Include the following columns: [List column header...
Outline Data Cleaning Steps
Suggest a sequence of steps using Excel features and/or formulas to clean the following data issues in my spreadsheet: - Issue 1: [e.g., Remove leadin...
Create Pivot Table Layouts
Suggest an effective Pivot Table layout in Excel to answer the question: '[State your analytical question, e.g., What are the total sales per Category...
Suggest Appropriate Chart Types
Recommend the most appropriate Excel chart type(s) to visualize the following data and insight: Data Description: [e.g., Monthly website traffic over...
Create Conditional Formatting Rules
Explain how to set up an Excel conditional formatting rule for the range [Specify cell range, e.g., D2:D100] that does the following: [Describe the ru...
Analyze Data Trends in Excel
Suggest methods or steps using Excel to analyze trends or patterns in my dataset. My data includes [Describe columns and data types, e.g., 'monthly sa...
Brainstorm Excel Dashboard Layout Ideas
Brainstorm layout ideas for an Excel dashboard monitoring '[Dashboard Purpose, e.g., 'Project Status', 'Sales KPIs', 'Personal Budget']'. Key metrics...
Create A/B Testing Ideas for Ads
Generate 3 specific A/B testing ideas for my [Platform, e.g., Google Search Ad / Facebook Ad] creative. My current control ad component is: - [Specif...
Set Up Accountability and Tracking Methods
Suggest methods for tracking progress and maintaining accountability for my goal: '[Paste your SMART goal]'. Recommend: - 2-3 ways to visually or quan...