Prompt lesson · 20 prompts
Mortality and Morbidity Analysis prompts for Insurance Actuaries
20 ready-to-use prompts from our AI for Insurance Actuaries course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Clean and Standardize Mortality and Morbidity Data
Use this when you need to collect, clean, and standardize mortality and morbidity data for actuarial analysis.
Role You are a data analyst specializing in actuarial data, ensuring mortality and morbidity datasets are accurate, complete, and standardized for analysis.
Context you provide
- {{data_sources}} — list of sources for mortality/morbidity data (e.g., CDC, WHO, internal claims).
- {{data_types}} — types of data (e.g., death records, disease prevalence).
- {{specific_requirements}} — any specific variables or standards to follow.
Instructions
- Ask for missing inputs if not provided.
- Outline a plan to extract data from the given sources, including any necessary APIs or manual collection.
- Identify common data quality issues (e.g., missing values, inconsistencies) and propose cleaning steps.
- Standardize variables (e.g., age groups, disease codes) to ensure consistency across sources.
- Validate the cleaned data by cross-referencing sources and flagging remaining issues.
Output format Provide a data cleaning checklist with steps, tools (e.g., Python, Excel), and a summary of potential issues. Use concise, practical language.
Guardrails Do not fabricate data or assume specific sources; ask for clarification. Flag any assumptions about data formats. Stay within the scope of cleaning, not analysis.
Example {{data_sources}}=CDC mortality files, WHO morbidity reports, {{data_types}}=death counts by cause, disease prevalence rates, {{specific_requirements}}=standardize by age and sex.
Open this prompt Analysis · Intermediate
Mortality and Morbidity Trend Analysis
Use this when you need to analyze mortality or morbidity data to identify patterns, correlations, and trends that inform insurance risk assessment.
Role You are a data analyst with expertise in actuarial statistics. Your goal is to provide clear, actionable insights from mortality and morbidity data to support insurance pricing and underwriting decisions.
Context you provide
- {{data_source}}: The dataset or source of mortality/morbidity data.
- {{time_period}}: The time frame for analysis (e.g., past 10 years).
- {{demographic}}: The specific demographic group (e.g., age, gender, region).
- {{analysis_type}}: The type of analysis (e.g., regression, time series, cluster).
Instructions
- If any required context is missing, ask for it before proceeding.
- Perform the requested statistical analysis on the provided data, explaining your methodology.
- Identify significant patterns, correlations, or trends and interpret their implications for insurance risk.
- Suggest additional variables or data that could improve the analysis.
- Provide a concise summary of key findings and their potential impact on pricing or underwriting.
Output format Present your analysis in a structured format with sections: Methodology, Findings, Implications, and Recommendations. Use bullet points and include any relevant statistical measures (e.g., p-values, confidence intervals) where applicable. Keep the tone professional and data-driven.
Guardrails
- Do not fabricate data or results; clearly state any assumptions.
- Flag any limitations in the data or analysis.
- Stay within the scope of the provided data and analysis type.
Example Data source: National mortality database; Time period: 2010-2020; Demographic: ages 50-70; Analysis type: time series.
Open this prompt Analysis · Advanced
Mortality and Morbidity Risk Assessment
Use this when you need to evaluate the impact of mortality and morbidity trends on insurance policies and portfolios.
Open this prompt Analysis · Advanced
Forecast Mortality and Morbidity Trends
Use this when you need to predict future mortality or morbidity rates based on historical data and current trends.
Open this prompt Analysis · Advanced
Insurance Scenario Modeling
Use this when you need to model hypothetical mortality, morbidity, or economic scenarios to assess their impact on insurance products.
Open this prompt Analysis · Advanced
Actuarial Report Generation
Use this when you need to compile actuarial findings into comprehensive reports for internal or external stakeholders.
Open this prompt Creating · Intermediate
Visualize Mortality and Morbidity Data for Insights
Use this when you need to create clear visualizations of mortality and morbidity data to support insurance decisions.
Open this prompt Creating · Intermediate
Regulatory Compliance in Mortality Analysis
Use this when you need to ensure your mortality and morbidity analyses comply with industry regulations and standards.
Open this prompt Analysis · Intermediate
Mortality Rate Trend Analysis
Use this when you need to analyze historical mortality data to identify trends and forecast future patterns for a specific demographic or region.
Open this prompt Analysis · Intermediate
Compare Morbidity Rates Across Groups
Use this when you need to compare morbidity rates across demographic groups or geographic regions to identify risk factors.
Open this prompt Analysis · Intermediate
Analyze Disease-Specific Mortality for Risk Assessment
Use this when you need to analyze mortality rates for specific diseases to inform insurance risk and pricing.
Open this prompt Analysis · Advanced
Project Long-Term Care Morbidity
Use this when you need to project future morbidity rates for long-term care insurance products to inform pricing and underwriting.
Open this prompt Analysis · Advanced
Mortality Improvement Study
Use this when you need to analyze mortality improvement trends to adjust reserves and pricing assumptions.
Open this prompt Analysis · Advanced
Morbidity Risk Scoring Model
Use this when you need to develop a risk scoring model to assess morbidity risk for insured individuals.
Open this prompt Analysis · Advanced
Mortality Experience Study
Use this when you need to analyze actual mortality experience against expected rates for an insurance portfolio.
Open this prompt Analysis · Advanced
Analyze Morbidity Claim Costs
Use this when you need to estimate the financial impact of morbidity-related claims on insurance portfolios and reserves.
Open this prompt Analysis · Advanced
Mortality Risk Modeling
Use this when you need to build predictive models to assess mortality risk for underwriting and pricing strategies.
Open this prompt Analysis · Advanced
Visualize Morbidity Data Patterns
Use this when you need to create visualizations of morbidity data to uncover patterns and trends that inform risk assessments.
Open this prompt Creating · Intermediate
Mortality and Morbidity Correlation Analysis
Use this when you need to analyze the relationship between mortality and morbidity rates to better understand insurance risk.
Open this prompt Analysis · Advanced
Morbidity Risk Mitigation Strategies
Use this when you need to develop data-driven strategies to reduce morbidity-related risks in an insurance portfolio.
Open this prompt Analysis · Advanced