data analytics 4, 5, 6

Mean

also known as average

Mean

is defined to be the sum of the data values divided by the total number of values

Mean

is the sample of the values, divided by the total number of values.

x̄

this symbol represents the sample mean

Mean

it is the most familiar measure used, and it employs all available information

Mean

it is affected by the value of every observation. In particular, it is strongly influenced by extreme values

Mean

since it is a calculated number, it may not be an actual number in the data set.

Median

the __ of a set of data is defined as the middle value when the data is arranged inorder of magnitude

Median

it is a positional measure.

Median

it is affected by the position of each item in the series but not by the value of each item. This means that extreme values affect the __ less than the arithmetic mean

Mode

the __ of a set of data is the value which occurs with the greatest frequency.

Mode

it is therefore the most common value

Mode

it does not always exist; and if it does, it may not be unique

Mode

it is not affected by extreme values.

Mode

it can be used for qualitative as well as quantitative data

Symmetrical Distribution

it is a type of probability distribution where the data is evenly distributed around the center or mean of the distribution.

Same

in a perfectly symmetrical distribution, the mean and the median are the __

Skewness

it measures the asymmetry of a distribution

Negative Skewness

it indicates that the extreme values (outliers) are more likely to be on the lower side of the distribution

Higher Values

the bulk of the data is concentrated on the __

Positive Skewness

it indicates that the extreme values (outliers) are more likely to be found on the right side of the distribution, causing the right tail to be longer.

Variability

it provides a quantitative measure of the differences between scores in a distribution and describes the degree to which the scores are spread out or clustered together.

Range

it is the highest value minus the lowest value. The symbol ! is used for the range.

Variance

it is the average of the squares of the distance each value is from the mean.

Standard Deviation

it is the square root of the variance.

Low Standard Deviation

it indicates that the data points tend to be very close to the mean.

High Standard Deviation

it indicates that the data points are spread out over a large range of values.

Coefficient of Variation

it is a statistic that allows you to compare standard deviations when the units are different, denoted by CVar.

Proper Function

it is a function used to capitalize the first letter of each word in a text string, while converting all other letters to lowercase. This is useful for formatting names and titles consistently.

formula for proper function

=PROPER(

Trim Function

it is used to remove extra spaces from text, leaving only single spaces between words and no spaces at the beginning or end of the text.

=TRIM(

formula for trim

Trim and Proper Functions

you can combine __ to clean and properly format text simultaneously.

Upper Function

it converts text to uppercase

Lower Function

it converts text to lowercase.

=UPPER(A1)

formula for upper function

=LOWER(B1)

formula for lower function

=COUNTIF($-$-$-)

frequency

=COUNT(-:-)