Request specific statistical analysis on selected data
Ask ChatGPT to calculate median and standard deviation for highlighted numerical columns in a table.
Calculate the median and standard deviation for this data.
This prompt is used after selecting one or more numerical columns within an interactive table view in ChatGPT.
ChatGPT will return the calculated median and standard deviation values for the selected columns.
After uploading a dataset and expanding the table view, select one or more numerical columns. Then, use this prompt to ask ChatGPT to compute the median and standard deviation for the selected data.
ChatGPT can perform statistical calculations on numerical data. By selecting specific columns, you direct the model to apply these calculations to the precise data points you are interested in.
- Extracting Insights with ChatGPT Data Analysis ↗OpenAI · OpenAI Help Center · Sep 6, 2026 · quoted as shared
First seen on Subvolts Sep 6, 2026. Updated Sep 11, 2026. Spotted a problem? Tell us.
- Extracting Insights with ChatGPT Data AnalysisOpenAI · OpenAI Help Center · Sep 6, 2026
The Playbook: reusable how-tos, prompts, configs and tips pulled out of the news.
- HeuristicBuild skills as small, mix-and-match building blocksDesign skills as small, modular components rather than one large, end-to-end process. · 15 min
- PromptDeep research task with specific outcome and sourcesInitiate a deep research task specifying the desired report structure, context, and sources. · 5 min
- PromptAnalyze spreadsheet and produce KPI table, charts, and exec summaryAnalyze uploaded spreadsheet data to generate a KPI table, charts, and an executive summary with risks and actions. · 15 min
- PromptBuild simple forecast, show model, assumptions, confidence, and staffing implicationsBuild a 8-week forecast from historical data, detailing model, assumptions, confidence, and staffing impact. · 20 min
- PromptMarketing analyst: identify conversion drivers, compute rates, recommend optimizationsAct as a marketing analyst to find conversion drivers, calculate channel rates, and suggest optimizations from uploaded datasets. · 20 min
- PromptScan export for anomalies, flag rows, explain suspicion, suggest next checkScan an export file for anomalies like duplicates or spikes, flag suspicious rows, explain why, and suggest next steps. · 10 min
Questions people ask
- Which AI tools does this work with?
- The sources used it with ChatGPT.
- Where did this come from?
- OpenAI (OpenAI Help Center). Subvolts collected, normalized and credited it; the link above opens the original.