| |
|
|
| |
When a set of numbers (or scores) are
entered in column C, this software calculates an average score, which is
displayed approximately four paragraphs below. This software
also carries out three statistical calculations for each score that was
entered. These calculated results are displayed in a table,
in columns D, E and F, which is about five paragraphs below.
The formulas used for the three calculations are explained in the
following three paragraphs. |
|
| |
|
| |
|
| |
Online
Table for Calculating the Average Created by David Alderoty © 2012
David@TechForText.com
|
|
| |
Calculations performed in Column D |
|
| |
 |
|
| |
The calculations in column D, are the individual
score, divided by the sum of all the scores. |
|
| |
This is multiplied by 100 to
display the results as a percentage. |
|
| |
|
|
|
|
|
|
| |
Calculations performed in Column E |
|
| |
 |
|
| |
The calculations in column E, are the individual
score, divided by the highest score. |
|
| |
This is multiplied by 100 to
display the results as a percentage. |
|
| |
|
|
|
|
|
|
| |
Calculations performed in Column F |
|
| |
 |
|
| |
The calculations in this column, are the
individual score, divided by the average score. |
|
| |
This is multiplied by 100 to
display the results as a percentage. |
|
| |
|
|
|
|
|
|
| |
|
|
| |
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
CALCULATED RESULTS ARE PRESENTED BELOW, IN RED
TYPE. |
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
| |
IN THE WHITE BOXES BELOW, ENTER NUMBERS ON THE
RIGHT AND NAMES ON THE LEFT. NAMES ARE OPTIONAL |
CALCULATED RESULTS INVOLVING THE INDIVIDUAL
SCORES, ARE PRESENTED BELOW IN RED TYPE, in columns D, E, and F. |
|
| |
In COLUMN B
enter names or descriptive phrases, which relate to the numbers you are
entering in this column. |
In COLUMN C
Enter numbers Do NOT enter words or letters in this
column |
In COLUMN D the
calculations are the individual score, divided by the sum of all the
scores, multiplied by 100 |
In COLUMN E the calculations are the individual score,
divided by the highest score, multiplied by 100 |
In COLUMN F the
calculations are the individual score, divided by the average score,
multiplied by 100 |
|
| |
|
|
score/(sum all scores) |
score/(highest score) |
score/(average score) |
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|