Skip to content
Reference > Prepare Methods

norm(value)

Definition

Double norm(Number value)

Description

similar to stack, but scaled so that the max value is one. Short hand for: stack(value)/sum(value). See dnorm(...)

Parameter Definition

Name Type Description
value Number

Example

1
Prepare *,norm(Price) as Sample from SampleData Partition by Symbol

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
+------+--------+-----+-------------------+
|Symbol|Sequence|Price|Sample             |
+------+--------+-----+-------------------+
|CAT   |1       |50.0 |0.18867924528301888|
|CAT   |2       |54.0 |0.39245283018867927|
|CAT   |3       |52.0 |0.5886792452830188 |
|CAT   |4       |52.0 |0.7849056603773585 |
|CAT   |5       !null |0.7849056603773585 |
|CAT   |6       |57.0 |1.0                |
|IBM   |1       |20.0 |0.21505376344086022|
|IBM   |2       |24.0 |0.4731182795698925 |
|IBM   |3       |22.0 |0.7096774193548387 |
|IBM   |4       |27.0 |1.0                |
|IBM   |5       !null |1.0                |
+------+--------+-----+-------------------+