NBA Stats Mean is determined by adding all data points in a single column together and dividing by the number of data points (in this case, 100). The Excel "AVERAGE" function was used to save time on arithmetic, but performs exactly this calculation.

Median simply takes the central value in a data set when the set is arranged in order of numerical value (or the mean of the two central data points when the data set contains an even number of points). Data was sorted first by height and then by points to determine the median scores for each data set, respectively; the mean of the values in rows 51 and 52 of the spreadsheet (corresponding to the 50th and 51st values in the data set, as row 1 was occupied by the column titles) were taken as the median.

Mode is given simply by frequency; data was again sorted independently for each data set an the most frequent value in each column was determined....

Two values had the same highest frequency in the "points" data set (four times each), making this set multimodal (bimodal).
Standard deviation is calculated first by taking the difference of each data point from the mean and squaring the result. Each of these resulting figures is then averaged (i.e. The mean is calculated), and the square root of this number is the standard deviation. The Excel function STDEV was used to save time on arithmetic.

Pearson's Correlation Coefficient is calculated by dividing the covariance of the data sets by the product of the standard deviations. In order to calculate covariance, each pair of data points (i.e. height and the number of points achieved) is combined first by subtracting the expected value of the data point (i.e. The mean) from the value of the data point itself, then multiplying these together. For instance, the first data pair (when…