1. Home

LSM9DS1 A 9 degree of freedom Inertial Navigation Chip

You are reading a single comment by @ClearMemory041063 and its replies. Click here to read the full conversation.
  • •

    Elimination of data outside of 2 standard deviations

    The following cell formulas were used to flag data with R > Ravg + 2* Standard Deviation, data with R < Ravg – 2 *Standard Deviations. Addif combines the two test. Sort is a copy of sort but pasting the values.
    The data set is then sorted on the sort column so that the data that fails the two test appears at the end.
    The range of the average R and error squared cells is then adjusted to omit the failed data.

    If> If< addif sort
    =+IF(K11>2*$W$16+$K$8,1,0) =+IF(K11<-2*$W$16+$K$8,1,0) =+M11+N11 0
    =+IF(K12>2*$W$16+$K$8,1,0) =+IF(K12<-2*$W$16+$K$8,1,0) =+M12+N12 0
    =+IF(K13>2*$W$16+$K$8,1,0) =+IF(K13<-2*$W$16+$K$8,1,0) =+M13+N13 0

    The statistics before and after culling points

    X2 Y2 Z2 R R culled
    Mean -364.5748567 391.871392 632.4737844 1830.168415 1836.695918
    Standard Error 67.04595875 76.48066792 84.76943069 3.236027167 1.512956317
    Median -437.737373 492.0129977 869.7152389 1831.87751 1837.17791
    Mode #N/A #N/A #N/A #N/A #N/A
    Standard Deviation 829.3127091 946.0136164 1048.53995 40.02744545 18.1554758
    Sample Variance 687759.5696 894941.7624 1099436.026 1602.19639 329.6213015
    Kurtosis -0.804853975 0.040187749 -0.812408283 13.51531831 1.605392491
    Skewness 0.029365323 -0.813405054 -0.704273669 -1.200036996 0.376826799
    Range 3116.687258 3519.235059 3363.996524 402.5993238 125.1034715
    Minimum -1839.702418 -1770.78729 -1533.311636 1588.830427 1780.98384
    Maximum 1276.984841 1748.447769 1830.684887 1991.429751 1906.087312
    Sum -55779.95308 59956.32298 96768.48901 280015.7674 264484.2122
    Count 153 153 153 153 144

    Compare the Range of the R and R culled items.

    The calibration constants

    Mag8Gauss 30Apr2017

    Offset A B C
    X 1060.852426 0.987424002 0.01417124 -0.000599842
    Y 24.46995621 0.124389675 0.996380859 -0.000561968
    Z 561.2217795 0.020594208 0.00552387 1

    Next using the calibrations.

    1 Attachment

About

Avatar for ClearMemory041063 @ClearMemory041063 started

© Espruino, powered by microcosm.

About Terms of Use Privacy Policy Cookie Policy Report a problem