Skip to content

RayforceDB

Avg

RayforceDB

Home
Documentation
Documentation
- Getting Started
  Getting Started
  - Install
  - Tutorial
- Benchmarks
  Benchmarks
  - Compare to other DBs
  - Run benchmarks
- Reference card
- Syntax
- Atomic functions
- Math
  Math
  - Add
  - Sub
  - Mul
  - Div
  - Mod
  - Sum
  - Avg Avg
    Table of contents
    
    Notes
  - Med
  - Dev
  - Min
  - Max
  - Ceil
  - Floor
  - Round
  - Xbar
- Evaluation Control
  Evaluation Control
  - Do
  - If
  - Try
  - Raise
  - Return
  - Exit
- Compose
  Compose
  - Casting
  - Concat
  - Create Dict
  - Create Table
  - Create List
  - Create Vector
  - Group
  - GUID
  - Rand
  - Reverse
  - Til
  - Distinct
- Env
  Env
  - Set
  - Let
  - Get env
  - Memstat
- Format
  Format
  - Format
  - Print
  - Println
  - Show
- IO
  IO
  - Get
  - Get Splayed
  - Set Splayed
  - Get Parted
  - Set Parted
  - Read CSV
  - Read
  - Write
  - Hopen
  - Hclose
- Logic
  Logic
  - And
  - Or
  - Not
  - Like
  - Nil?
- Items
  Items
  - At
  - First
  - Last
  - Take
  - Except
  - Union
  - Sect
  - In
  - Where
  - Filter
  - Find
  - Key
  - Value
  - Enum
  - Within
- Order
  Order
  - Asc
  - Desc
  - Iasc
  - Idesc
  - Neg
  - Xasc
  - Xdesc
- Comparison
  Comparison
- Temporal
  Temporal
  - Date
  - Time
  - Timestamp
- Iter
  Iter
  - Apply
  - Map
  - Fold
- Queries
  Queries
  - Select
- Joins
  Joins
- Updates
  Updates
  - Alter
  - Insert
  - Upsert
  - Update
- REPL
  REPL
  - Parse
  - Eval
  - Exec
  - Load
  - Args
  - Commands
  - Quote
  - Resolve
  - Display width
  - FPR
  - Use unicode format
- Serialization
  Serialization
  - Serialize
  - Deserialize
- Misc
  Misc
  - Type
  - Count
  - Reference count
  - GC
  - Meta
- Time
  Time
  - Timer
  - Timeit
- Interfacing
  Interfacing
  - IPC
  - Load function
FAQ
License

Average `avg`¶

Calculates average value of the vector. Always returns a float value.

↪ (avg [1.0 2.0 3.0])
2.0

↪ (avg [-24 12 6])
-2.0

↪ (avg [1i 2i -3i])
0.0

↪ (avg 5i)
5.0

↪ (avg [-24 12 6 0Nl])
-2.0

Notes¶

Returns 0Nf (null float) for null inputs: (avg 0Nf) → 0Nf
Null values in vectors are skipped: (avg [-24 12 6 0Nl]) → -2.0
Always returns float, even for integer inputs