Analysis with Excel

The same UNIX script (mkclass) that converts the Cloudant JSON into CSV files suitable to Watson Analytics is also suitable for consumption by Excel. The script builds the classifier (or classifier set, e.g. 'people') population statistics model for the specified device. The results are processed in the Excel spreadsheet to produce the charts below.

  1. All Activity; the sum of 'person' events in the kitchen
  2. Expected Activity; when 'person' count by 'intervals' "near" mean of interval count
  3. Over Activity; when 'person' count by 'interval' is +2SD over mean of interval count
  4. Under Activity; when 'person' count by 'interval' is -2SD under mean of interval count