Statistical Analysis

Main Menu — Sales – Instrument Table

Once the Sales Module opens, go to: Order – Index

CLICK Create to Create a Temporary Index

SELECT Temporary Index

From here, user can create an Index based on the data they want to run on their analysis.
In this example:
Sale Date Range: 01/01/2019..12/31/2019
Nbhd Code: 1150
Qual Code: Q * (The Q here, represents qualified sale. User may also used QV* to represent qualified/verified sale— if it is set up in the sale qualifications table. DO NOT use QC for quit claim deed. Many times, these have a sales price of 0, which may lead to division by 0 errors.)

To avoid getting deleted records in the Index:
OPEN the query filter
TYPE deleted=0
CLICK OK

CLICK The Lightening Bolt*
CLICK X

In the Index
CLICK Tools — Statistical Analysis

User can run analysis by Assessed Values or Appraised Values.
This example is Assessed.
CLICK Spreadsheet

It will build an Excel File that the user can review data from there.