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)  
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
             

 Online Table for Calculating the Average Created by David Alderoty © 2012 David@TechForText.com