Composite Score Tool

Original Data

Composite Score Information

What is a composite score and why would I use it?

A composite score is a single data point that combines information from multiple variables. An advantage of this is it is easier to analyse interpret than multiple variables. I use this frequently when game balancing or mathmatical optimisation as the data tells a story.

How to use the tool?

  1. Upload a valid .csv file
  2. Apply scoring weights and direction
  3. View Normalised Results

.csv file?

A csv file stands for comma separated values. It is a common format, and can be created of most software even a text editor.

score weight?

Weight refers to how much a variable score contributes to the result. As a designer you can decide what % of the total score that variable contributes.

score direction?

Depending on what you are measuring, lower or higher value may be better. When calculate weight you must decide which direction scores higher.

Normalised Data

To be able to calculate the score, the data must be normalised. The result of the composite score will be displayed bot has Min-Max and Z-Score.

What is Min-Max?

In Min-Max every value is between 0-1, with 0 being the minumum and and 1 being the maximum. This rescales the data to a common range.

The min-max normalization formula is:

\[x' = \frac{x - x_{\min}}{x_{\max} - x_{\min}}\]

where:

  • $x$ is the original value.
  • $x_{\min}$ is the minimum value of the feature.
  • $x_{\max}$ is the maximum value of the feature.
  • $x’$ is the normalized value.

What is Z-Score

Z-Score also know as standard score, measures the difference from the mean in standard deviations.

Assuming the population mean and population standard deviation are known, a raw score (x) is converted into a standard score (or z-score) by:

\[z = \frac{x - \mu}{\sigma}\]

where:

  • $\mu$ is the mean of the population.
  • $\sigma$ is the standard deviation of the population.
  • $x$ is the raw score.
  • $z$ is the standardized (z) score.

Exported data

The export .zip contains 6 files. The notes contains the {Column, Direction, Weight, Percentage} for the score weights, so you know how to values were calculated. The other files are the spreadsheets including the original .csv so you can continue to use it.

  1. notes
  2. name_minmax
  3. name_minmax_composite
  4. name_original
  5. name_zscore
  6. name_zscore_composite

Note the data uploaded is cilent-side so we at Intrepid Toad do not store or use your data.