02-11-2021, 15:32
|
#10
|
Sulking in the Corner
Join Date: Jul 2009
Location: RG41
Services: 1 Gbps; Hub 4 MM; ASUS RT-AX88U; Ultimate VOLT. BT Infinity2; Devolo 1200AV
Posts: 11,955
|
Re: Budget 2021
Quote:
Originally Posted by Hugh
Depends how large your sample size is - for instance, the ONS stats normally come from a sample size of around 180,000, but for the ast year it was 140,000 (due to COVID).
|
At both sample sizes you've given, TRIMMEAN would not be inapplicable. The real kicker in TRIMMEAN is the range of values at each extreme; the Excel formula allows you to snip at each extreme end.
__________________
Seph.
My advice is at your risk.
|
|
|