Z-Score standardization
This method standardizes the mean and standard deviation of the original data. The processed data are in accordance with the standard normal distribution, i.e. the mean value is 0 and the standard deviation is 1. Conversion function:
A |
|
1 |
=T("D://house_prices_train.csv") |
2 |
=A1.avg(LotArea) |
3 |
=sqrt(var@s(A1.(LotArea))) |
4 |
=A1.run(LotArea=(LotArea-A2)/A3) |
Z-Score standardization:
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL