In the Query Tool, the average column on the right will show the average per day, week, month, or year, either for "all time periods" or "active periods only". However, the Average values in the CSV file exported from the Query Tool are calculated as "Total" divided by "Count".
The values for the Average column in the CSV file should match the values for the Average column in the Query Tool table.