When running the attached query, "Stat Error Quest.yxmd" on the "EXAMPLEDATA.yxmd" set, the model creates the output file "ExampleErrors.xls" as a worksheet.
The objective of the query is to simply output the basic statical breakdown of average pricing that one would find in a Box Plot Whisker chart with the transaction count and the standard deviation.
Column "K" has a formula added to find and display where the query returned a median value greater than the maximum. Also, please note, that in these cases the 3rd Quartile value is also incorrect.
Can you tell me how to fix the formulas in the SUMMARIZE to make these values return corrected to true Median and true 3rd Quartile?
Hi @ptaylor_ds
This thread here from one of our other discussions provides a couple of options on how to achieve this - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Quartiles/td-p/28479
Kind regards,
Will