Statistical Functions for Beginners
Describe data with the right measures.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Explain and apply basic statistical functions to my data. App: [SPREADSHEET_APP]. Data description and sample values (fake or real, not sensitive): [DATA_DESCRIPTION]. What I want to understand: [QUESTIONS]. Return a table: Measure | Function | What it tells you | When it misleads | Result on my data. Cover: AVERAGE, MEDIAN, MODE, MIN/MAX, range; STDEV.S versus STDEV.P; percentiles and quartiles; COUNT, COUNTA, COUNTBLANK; frequency counts and histograms (FREQUENCY or COUNTIFS bins); correlation (CORREL) and the warning that correlation is not causation; simple trend (FORECAST.LINEAR, SLOPE) and its limits; confidence-type language in plain terms (avoid claiming significance without a proper test); outliers (IQR method with formulas); and weighted averages (SUMPRODUCT). For each, show the formula on my data and interpret the result in a sentence. Add a section on choosing between mean and median, a checklist for data preparation (remove blanks, check units), and a chart suggestion for each question. Remind me that small samples are noisy, and that for decisions with high stakes I should consult a statistician. Provide a quick quiz of five questions with answers.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.