TABLE OF CONTENTS

• Standardised testing: Calculating the statistical data
• Add in the formulas
• What are the Min, Q1, Median, Q3 and Max values?

Standardised testing: Calculating the statistical data

NOTE: The statistics for National, Organisation or State will need to be obtained from the relevant body. School statistics can be formulated using a spreadsheet of your data. 

The following formulae can be copy-pasted into Excel, where X1:Xn is the range of the cells in which the results are stored. Similar formulae are available for other spreadsheet programs.

• Min: =MIN(X1:Xn)
• Q1: =QUARTILE(X1:Xn,1)
• Median: =MEDIAN(X1:Xn)
• Q3: =QUARTILE(X1:Xn,3)
• Max: =MAX(X1:Xn)

Your spreadsheet data may need to be sorted and filtered to allow you to easily calculate the statistics. A simple example spreadsheet is available here, which contains a subset of some NAPLAN data.

Add in the formulas

1. Choose a convenient place to enter the above formulas, depending on how your data is set out.
   1. Ensure you select the correct cell range. Save the spreadsheet if you want to keep it for reference.
2. Format the values to whole numbers:
   1. Select the cells with the formula
   2. Right-click on the selected area
   3. Select Format cells.
   4. Select Number and set Decimal places to 0 and click OK
3. Copy and paste the numbers into SEQTA Teach

What are the Min, Q1, Median, Q3 and Max values?

The median is the middle point of a number set, in which half the numbers are above the median and half are below. If there are an even number of numbers in a set, to establish the median add the two middle numbers and divide by 2.

Quartile 1 is the point where 25% of all recorded values are are below that point. It is the median of the lower 50% of the values.

Quartile 3 is similar but 75% of the recorded values are below the Q3 point. It is the median of the upper 50% of the values.