Data Functions Flashcards
What is a data function?
A data function is a method of mapping inputs to outputs. It involves specifying what to use as the basis for calculations and where to place the results.
Find and replace
Search for a specific value or string and replace it with another value
Statistical functions
Calculate descriptive statistics, such as averages, counts, and medians
Text manipulation
Piece together parts of text, such as names, addresses, and file paths
Date and time manipulation
Work with date and time, such as with EOMONTH and EDATE
Other Common Functions
conditional statements, concatenating and splitting, trimming, changing data types, finding unique values, sorting, and filtering
What are Descriptive Statistics?
Descriptive statistics summarize certain aspects of a data set or a population using numeric calculations.
Minimum
Ordering a data set from lowest to highest value, the minimum is the smallest value.
Maximum
Ordering a data set from highest to lowest value. The maximum is the highest amount.
Range
The range of a data set is the difference between the minimum and maximum.
Sum
The sum is the total of all data values
Count
Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Mean
The mean of a data set is the sum of all of the data divided by the size. The mean is also known as the average.
Median
Ordering a data set from lowest to highest value, the median is the numeric value separating the upper half of the ordered sample data from the lower half. ( If n is odd the median is the center value. If n is even the median is the average of the 2 center values. )
Mode
The mode is the value or values that occur most frequently in the data set. A data set can have more than one mode, and it can also have no mode.
