Skip to main content
data advanced

Analyze Time Series Data with Statistical Insights

Advanced AI prompt for comprehensive time series analysis with trend detection, seasonality, forecasting, and statistical insights.

Works with: chatgptclaudegemini

Prompt Template

You are an expert data scientist specializing in time series analysis. Please perform a comprehensive analysis of the provided time series data. Dataset: [DATASET_DESCRIPTION] Time Period: [TIME_PERIOD] Frequency: [DATA_FREQUENCY] Key Metric: [PRIMARY_METRIC] Please provide the following analysis: 1. **Data Overview & Quality Assessment** - Summarize the dataset characteristics - Identify missing values, outliers, and data quality issues - Provide basic descriptive statistics 2. **Trend Analysis** - Identify long-term trends (increasing, decreasing, stable) - Quantify trend strength and direction - Highlight any trend breakpoints or structural changes 3. **Seasonality & Cyclical Patterns** - Detect seasonal patterns (daily, weekly, monthly, yearly) - Quantify seasonal strength and consistency - Identify any cyclical behaviors 4. **Statistical Decomposition** - Break down the series into trend, seasonal, and residual components - Assess the relative contribution of each component 5. **Anomaly Detection** - Identify significant outliers or anomalies - Provide potential explanations for unusual patterns 6. **Forecasting Insights** - Recommend appropriate forecasting methods - Provide short-term predictions with confidence intervals - Discuss forecast reliability and limitations 7. **Business Implications** - Translate statistical findings into actionable business insights - Highlight key risks and opportunities - Suggest monitoring strategies Present findings with clear explanations, avoiding overly technical jargon. Include specific numerical insights where relevant and provide recommendations for next steps.

Variables to Customize

[DATASET_DESCRIPTION]

Brief description of your time series dataset

Example: Monthly sales revenue data for e-commerce platform, including product categories and geographic regions

[TIME_PERIOD]

The time range covered by your data

Example: January 2020 to December 2023

[DATA_FREQUENCY]

How frequently the data points are recorded

Example: Monthly observations

[PRIMARY_METRIC]

The main variable you want to analyze

Example: Total revenue in USD

Example Output

## Time Series Analysis: Monthly E-commerce Revenue (2020-2023) ### Data Overview & Quality Assessment The dataset contains 48 monthly observations with total revenue ranging from $2.3M to $8.7M. No missing values detected. Two potential outliers identified in December 2020 ($8.7M) and March 2020 ($2.3M), likely related to holiday surge and COVID-19 impact respectively. ### Trend Analysis Strong upward trend detected with 12% average annual growth rate. Revenue increased from $4.2M baseline in 2020 to $6.8M average in 2023. One structural break identified in Q2 2021, coinciding with platform expansion. ### Seasonality & Patterns Clear seasonal pattern with 23% average increase in Q4 (holiday season) and 15% dip in Q1. Weekly patterns show 40% higher weekend sales. Seasonality accounts for 35% of total variance. ### Statistical Decomposition - Trend component: 45% of variance - Seasonal component: 35% of variance - Residual/noise: 20% of variance ### Forecasting Insights Recommend SARIMA model for next 6 months. Predicted Q1 2024 revenue: $6.2M ±$0.8M (95% CI). High forecast reliability given strong historical patterns. ### Business Implications Sustained growth trajectory with predictable seasonality enables better inventory planning and marketing spend allocation. Monitor for potential saturation signals as growth rate shows slight deceleration in recent quarters.

Pro Tips for Best Results

  • Provide actual data samples or summary statistics for more accurate analysis
  • Mention any known external factors (holidays, campaigns, market events) that might influence patterns
  • Specify your forecasting horizon and business objectives to get targeted recommendations
  • Include context about your industry or business model for more relevant insights
  • Ask follow-up questions about specific patterns or anomalies the AI identifies

Tags

Want 500+ Expert Prompts?

Get the Premium Prompt Pack — organized, tested, and ready to use.

Get it for $29

Related Prompts You Might Like