Xcalar Design is calculating standard deviation using a number of rows that includes the number of non-numeric values in the column. These will appear as FNFs in the profile. Here's an example:
In this case, you will need to remove these FNFs from the table before profiling to calculate a standard deviation which should coincide with the Excel number:
- Click on the column.
- Click the column menu and select Filter...
- Select the Filter Function named exists.
- Confirm that the name of the column is listed in the fieldName field.
- Click FILTER.
After filtering FNFs out of the table, the number of rows in your table will decrease, and the Standard Deviation should be in line with what Excel calculated.
Did that do the trick?