Based on the Salesfact database perform various customer segmentation studies Including only continuous variables: customer segments are based on purchases of 3 main product families (food, drink and nonconsumables). What are the characteristics of customers in each segment? Perform a profiling study on three categorical variables that are not included in clustering. That is how the clusters vary in different levels of these categorical variables such as gender or member card.- Which data preprocessing tasks do you apply before applying clustering algorithms? Do you need to scale (z-normalize) the data?- Solve the clustering problem with k-means, PAM, CLAA, a hierarchical agglomerative method and a density based method DBSCA- Experiment with a few different number of clusters (k) and choose and appropriate k What is the effect of increasing k?- Apply the procedure fining number of clusters with PAM or CLARA,- Interpret the resulting clusters and profiles comparing results of different algorithms.- What marketing strategies could be developed on these clusters or customer segments.P.S: Can you please write the necessary codes in the R program. AВFGHKMQR1TotalDrinkUnitSales TotalDrinkSales TotalFoodSales TotalFoodUnitSales TotalNonConUnitSales TotalNonConSales customer_id marital_status yearly_income gender total_children num_children_at_home educationmember_cardoccupationhouseowner num_cars_owned21 M$3ОK - $50K F42 Partial High School BronzeSkilled Manual Y42 S3 МO Partial High School Bronze1 Bachelors Degree3$70K - $90K М1Professional34715.34124.01532963.82$50K - $70K F1BronzeProfessionalY254 M$10K - $30K M4.4 Partial High School NormalSkilled Manual N25 S6 SO Partial CollegeO Bachelors Degree1 Partial High School Bronze61.082$3ОK - $50K FSilverManualN37817.6484.2732310.83$70K - $90K FBronzeProfessionalY387 M$30K - $50K F2ManualY3910.38196.37902952.398 M$50K - $70K М22 Bachelors DegreeBronzeProfessionalY3109 M$10K - $30K M3 Partial High School NormalO Bachelors DegreeO High School Degree BronzeO High School Degree BronzeO High School Degree Bronze925.0553.372411.16Skilled Manual Y1111830.0889.9432643.0110 S$30K - $50K M4GoldenManagement N41243.3241.031911 S$50K - $70K М4Manual21312 S$30K - $50K F1Skilled Manual N31413 S$30K - $50K M4Manual41526.55181322.3914 M$50K - $70K F22 Bachelors DegreeBronzeManagement Y21615 S$90K - $110K M30 Graduate DegreeBronzeProfessionalY31716 M$50K - $70K F22 High School Degree BronzeSkilled Manual Y2O High School Degree Bronze2 Partial College1842.652077.5217 S$90K - $110K M3Management Y31942.4424.041418 M$3ОK - $50K м3BronzeProfessionalY4$70K - $90K FO High School Degree BronzeO Partial High School NormalO High School Degree Normal200.6112.76719 S1Professional121512.1211.85931426.7720 S$10K - $30K F2ManualY2211.0699.29471322.5521 S$30K - $50K M1ManualY22322 M$30K - $50K F44 High School Degree GoldenSkilled Manual Y4$30K - $50K FO High School Degree SilverO High School Degree Bronze2457.062319.923 S2ManualN32517.6100.99531747.1224 S$3ОK - $50K FManualN3쁘0ㅇ 이ㅇ ㅇ0 8g ㅇㅇㅇㅇㅇ0이g 크8ㅇㅇ6

#include<bits/stdc++.h> using namespace std; // To represent a data point corresponding to x…

Answered: ased on the Salesfact database…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Based on the Salesfact database perform various customer segmentation studies

Including only continuous variables: customer segments are based on purchases of 3 main product families (food, drink and nonconsumables). What are the characteristics of customers in each segment? Perform a profiling study on three categorical variables that are not included in clustering. That is how the clusters vary in different levels of these categorical variables such as gender or member card.

- Which data preprocessing tasks do you apply before applying clustering algorithms? Do you need to scale (z-normalize) the data?

- Solve the clustering problem with k-means, PAM, CLAA, a hierarchical agglomerative method and a density based method DBSCA

- Experiment with a few different number of clusters (k) and choose and appropriate k What is the effect of increasing k?

- Apply the procedure fining number of clusters with PAM or CLARA,

- Interpret the resulting clusters and profiles comparing results of different algorithms.

- What marketing strategies could be developed on these clusters or customer segments.

P.S: Can you please write the necessary codes in the R program.

A
В
F
G
H
K
M
Q
R
1
TotalDrinkUnitSales TotalDrinkSales TotalFoodSales TotalFoodUnitSales TotalNonConUnitSales TotalNonConSales customer_id marital_status yearly_income gender total_children num_children_at_home education
member_card
occupation
houseowner num_cars_owned
2
1 M
$3ОK - $50K F
4
2 Partial High School Bronze
Skilled Manual Y
4
2 S
3 М
O Partial High School Bronze
1 Bachelors Degree
3
$70K - $90K М
1
Professional
3
4
7
15.34
124.01
53
29
63.82
$50K - $70K F
1
Bronze
Professional
Y
2
5
4 M
$10K - $30K M
4.
4 Partial High School Normal
Skilled Manual N
2
5 S
6 S
O Partial College
O Bachelors Degree
1 Partial High School Bronze
6
1.08
2
$3ОK - $50K F
Silver
Manual
N
3
7
8
17.64
84.27
32
3
10.83
$70K - $90K F
Bronze
Professional
Y
3
8
7 M
$30K - $50K F
2
Manual
Y
3
9
10.38
196.37
90
29
52.39
8 M
$50K - $70K М
2
2 Bachelors Degree
Bronze
Professional
Y
3
10
9 M
$10K - $30K M
3 Partial High School Normal
O Bachelors Degree
O High School Degree Bronze
O High School Degree Bronze
O High School Degree Bronze
9
25.05
53.37
24
11.16
Skilled Manual Y
1
11
18
30.08
89.9
43
26
43.01
10 S
$30K - $50K M
4
Golden
Management N
4
12
4
3.32
41.03
19
11 S
$50K - $70K М
4
Manual
2
13
12 S
$30K - $50K F
1
Skilled Manual N
3
14
13 S
$30K - $50K M
4
Manual
4
15
26.55
18
13
22.39
14 M
$50K - $70K F
2
2 Bachelors Degree
Bronze
Management Y
2
16
15 S
$90K - $110K M
3
0 Graduate Degree
Bronze
Professional
Y
3
17
16 M
$50K - $70K F
2
2 High School Degree Bronze
Skilled Manual Y
2
O High School Degree Bronze
2 Partial College
18
42.65
20
7
7.52
17 S
$90K - $110K M
3
Management Y
3
19
4
2.44
24.04
14
18 M
$3ОK - $50K м
3
Bronze
Professional
Y
4
$70K - $90K F
O High School Degree Bronze
O Partial High School Normal
O High School Degree Normal
20
0.61
12.76
7
19 S
1
Professional
1
21
5
12.1
211.85
93
14
26.77
20 S
$10K - $30K F
2
Manual
Y
22
11.06
99.29
47
13
22.55
21 S
$30K - $50K M
1
Manual
Y
2
23
22 M
$30K - $50K F
4
4 High School Degree Golden
Skilled Manual Y
4
$30K - $50K F
O High School Degree Silver
O High School Degree Bronze
24
57.06
23
19.9
23 S
2
Manual
N
3
25
17.6
100.99
53
17
47.12
24 S
$3ОK - $50K F
Manual
N
3
쁘0ㅇ 이ㅇ ㅇ0 8g ㅇㅇㅇㅇㅇ0이g 크8ㅇㅇ6

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.