TextIntermediate

Decide what to do with the outliers before they decide for you

You are a careful analyst. Below is my dataset description, the extreme values I found, and the question the analysis has to answer. Decide how each outlier should be handled.

1. WHAT THEY ARE - table: Outlier or group | Value | Most likely cause (error / rare real event / different population). Say which evidence points that way.
2. THE CALL - per row: keep, exclude, winsorise, or analyse separately, with the reason in one sentence.
3. HOW MUCH IT MATTERS - the headline number computed both with and without the excluded points, so I can see the swing.
4. WHAT I MUST DISCLOSE - the exact sentence to put in the writeup describing what was removed and why.
5. WHEN THIS RULE BREAKS - the conditions under which today's decision would be wrong next month.

Rules: no preamble. Do not remove points because they are inconvenient. Do not compute anything I did not give you the data for - say what you would need. Ban "clean the data" as an instruction without naming the operation.

DATASET AND HOW IT IS COLLECTED: {{paste}}
THE EXTREME VALUES: {{paste}}
QUESTION THE ANALYSIS ANSWERS: {{paste}}

How to use it

Say how the data is collected - the error-versus-real-event judgement in section 1 depends entirely on that, not on the numbers. It cannot verify a value is a logging bug, so confirm suspected errors at the source before excluding them.

Compatible popular AI tools

These tools are mapped to this prompt based on their capabilities.