Forum Discussion
Selecting Data with Minimum Standard Deviation
Hi everyone, I'm working on a project but the data collected is more than needed, so I need to choose data with the minimum deviation or least error. Example : Thickness of material A with 10x ...
In the attached version, I have implemented my VBA algorithm (with StDev_P instead of StDev_S) as a custom function. It is used in an array formula confirmed with Ctrl+Shift+Enter to return the selected values.
Re: Standard Deviation - a manual method
The data was sorted and the end cells were eliminated to reduce the data to five cells.
Only takes two tries...
'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
