-
Parameterize a Statistical analysis as follows:
-
Columns to Analyze
- twm_customer.income
- twm_customer.age
-
Basic Statistics Options
- Number of Values
- Minimum Value
- Maximum Value
- Mean Value
- Standard Deviation
- Skewness
- Kurtosis
- Standard Error
- Coefficient of Variance
- Variance
- Sum
- Uncorrected Sum of Squares
- Corrected Sum of Squares
-
Columns to Analyze
- Run the analysis.
-
When it completes, click the RESULTS tab.
For this example, the Statistical analysis generated the following results. Note that for brevity, the SQL is not shown.
Statistics - Example #1 Data (Part 1) xtbl xcol xcnt xmin xmax xmean xstd xskew xkurt TWM_C… income 747 0 144157 22728.2811245 22192.3521561 1.751929 4.3293003 TWM_C… age 747 13 89 42.4792503 19.1020801 .2342409 -.7738404 Statistics - Example #1 Data (Part 2) xtbl xcol xste xcv xvar xsum xuss xcss TWM_C… income 811.9757039 97.6420172 492500494.2181 16978026 753779217048 367897869180.964 TWM_C… age .6989086 44.9680253 364.8894624 31732 1620524 272572.4283802 Statistics Example #1 Graph
Thumbnails for each column in the analyses are shown in a box and whisker plot. The “box” is comprised of a green dot within a blue rectangle. The dot represents the mean value, while the rectangle itself represents plus/minus one standard deviation from the mean. Two “whiskers” are drawn from minus one standard deviation to the minimum value, and from plus one standard deviation to the maximum value.
As the mouse passes over each thumbnail, the cursor changes to indicate a hyperlink, and the individual graphs can be maximized by clicking on the thumbnail:
Statistics Example #1 Graph: Maximize Thumbnail