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.
People who liked this prompt
0 community likes