AI Compare Ninja AI Compare Ninja

Compare AI tools. Use prompts and skills.

Language
EN

Spot seasonal patterns in weekly or monthly figures

Prompt that separates season, trend and outliers in weekly or monthly figures and gives an adjusted answer. Paste it into an AI tool of your choice, which then spots seasonal patterns.

Topic
Spreadsheets & data
Type
Prompt
Level
Intermediate
Time
about 10 min

Results depend on the tool, the model and what you enter.

Result preview

Example: written by our editors, not real AI output.

Data: 24 months of revenue, two full cycles, enough for a cautious statement | Month | Seasonal index | | January | 78 | | March | 96 | | July | 84 | | November | 131 | | December | 148 | Trend: about +1% per month after seasonal adjustment Outlier: May a year earlier (+35%, discount campaign) Answer: July was not weak; adjusted, it is 3% above June. Certainty: medium, only two years of data

Fill in

What you type stays in this browser window. We store and send nothing.

Which metric, which figures?
Which period, which interval?
What do you want to know?

Your prompt

This is an instruction for an AI, not the result itself.

Where this prompt works

These AI tools are a good fit for this prompt:

How to use it

  1. Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
  2. Copy the finished prompt into an AI tool of your choice.
  3. Add the seasonal index as its own column in your sheet. Then you can compare future months directly with the expected level.

Why does this work?

Many apparent slumps or successes are just the season. Separating pattern, trend and outliers lets you compare like with like and decide more calmly.

Tips

  • When a holiday such as Easter moves between March and April, it looks like a seasonal jump. Mark such months in the data.

Also a good fit

You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use