I cannot find the "WINSORIZE" function in Excel add-in

[erickwy]

May I please know how I can find the "WINSORIZE" function in Excel add-in?
I am using Office 365.
I cannot find/locate the "WINSORIZE" add-in within my add-in feature.
I would appreciate if I can get help on this please.

[Ron Coderre]

Depending on your data, the options described at this site may be helpful:
https://www.howtogeek.com/400211/how...tion-in-excel/

Does that help?

[erickwy]

Thank you. But in particular, I am looking for the "WINSORIZE" function.
The following thread shows such a function which I cannot find it.
http://www.real-statistics.com/descr...nd-robustness/

[MrShorty]

If the add-in is properly installed, I would not expect you to need to do anything special to "find" the function. If you type =WINSORIZE(range,p) (obviously replacing range with the range containing your data and p with an appropriate value), does it not automatically load the function?

[erickwy]

No it doesn’t.

[MrShorty]

Pull up the Excel options dialog, click on Add-ins and see if the real-statistics add-in is installed and active. Use the Manage Addins button at the bottom and make sure the add-in is available and checked. If the add-in does not appear in either of these locations, then check the installation instructions for how to install the add-in.