Online Table for Calculating the Average

Created by David Alderoty © 2012

 

This website provides an online calculation table,

that can hold up to 40 numbers (or scores), for

calculating the average score, and a number

of other computations, explained below

 

If you want to download free databases,

with various types of calculation mechanisms,

created with Microsoft Excel, left click on the link below.

 

www.TechForText.com/Calculating-Spreadsheet-Databases

 

To contact the author (David Alderoty) use this

e-mail address: David@TechForText.com, or left click

on the link below for a website communication form.

 

Link for a Website Communication Form

 

 

If you want a printer friendly version of this software click on the link below:

 

www.TechForText.com/Online-Table-for-Calculating-the-Average/P

   
  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.  
   
   
             
  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)