Icon

KNIME_​FDP_​Stats

BASIC CONTROLS

DATA PREPROCESSING

UNIVARIATE ANALYSIS

BIVARIATE ANALYSIS

MULTIVARIATE ANALYSIS

INSIGHTS

  1. Single people tend to spend more

  2. If married, those without kids spend more than those with kids.

  3. Web purchases are preferred by middle aged and retired - possibly for convenience?

  4. Responders spent more than non-responders - Campaigning works!

  5. Higher the income, higher the spending.

  6. Recency may not have any influence on total spending.

  7. Most purchased products were Wine and Meat.

  8. Mean number of store purchases were higher than other channels.

  9. Spain spends lot more than other countries - graduates more than post grads and PhDs

There is a significant difference in the total spending between the campaign responders and non-responders.

At least one group mean is significantly different from the others among the compared groups.

  1. Customers who responded to campaigns spend substantially more.

  2. Customers purchasing through catalogs tend to spend significantly more.

  3. Website engagement translates into customer value. (Digital Channels Work!)

  4. Households with children—especially teenagers—spend less overall.

  5. Deals are not driving value - Discount-oriented customers are not necessarily valuable customers.

  1. Income strongly drives customer value

  2. Wine and meat products are the biggest contributors to spending

  3. Catalog and store purchases are strongly associated with higher spending

  4. Higher browsing activity does not necessarily translate into purchases and may reflect weak digital conversion

  5. Behavioral variables are stronger predictors of spending than demographics.

SAMPLE STATISTICAL ANALYSIS AND INSIGHTS

Math Formula
Digital Adoption
Numeric Binner
Bar Chart
18 - Age Computation
Math Formula
Total_spend_outlierCorrected
Numeric Outliers
19 - Age Distribution
Histogram
Independent groups t-test
Education x Country x Total_Spend
Sunburst Chart
Marital Status x Country x Total Spend
Heatmap
22 - Spender Segment
Binner
Games-Howell Post-hoc Test
R Snippet
Rule Engine
Linear Correlation
20 - Total Spend
Math Formula
Not valid as variances are not homogenous
One-way ANOVA
21 - Top Spenders
Top k Row Filter
Welch's ANOVA
R Snippet
24 - Total_Spend Outlier
Box Plot
25 - Mean vs median
Statistics
23 - Income Outlier
Box Plot
Linear Regression Learner
Heatmap
Row Filter
Column Filter
Table View
30. Top product Category by Mean Spending
GroupBy
26, 27 - Outlier Winsorization
Numeric Outliers
Box Plot
CSV Reader
1, 2 - # of Variables and Customers
Extract Table Dimension
3, 4
Column Filter
Table View
5 - Behaviour subset
Column Filter
Table View
6-Demographic subset
Column Filter
Bar Chart
used to manipulate RowID
RowID
Table Transposer
Column Renamer
RowID
Column Renamer
32 - Channel Usage
GroupBy
Table Transposer
Pie Chart
33. Income vs. Total Spend
Scatter Plot
Education x Income
Density Plot
10 - Web Customers
Row Filter
35. Total_Spend vs Campaign
Rule Engine
7-Amount Spent Subset - Wildcard
Column Filter
Bar Chart
9- High Income Customers
Row Filter
13-16 - Missing Values
Missing Value
Kids x Total Spend
Bar Chart
11- High Recency Customers
Row Filter
Box Plot
12- Last Campaign responders
Row Filter
Recency x Total Spend
Binner
Pivot
Bar Chart
17 - Pattern Missing
Rule Engine
Teen s x Total Spend
Pie Chart
GroupBy

Nodes

Extensions

Links