Prem Chandran TM (19039)

Report on Data analysis (Combination 1)

Objective:
To find the average satisfaction of the male customers who are from outside Mysore, who
visit the store for 6 or more times with respect to the service on Likert’s scale to be 4,5.

Methodology:
Tabular and graphical representation.

Stage 1: Data Dictionary

Gender - Male - a
Female – b
Place of stay - From Mysore - a
Outside Mysore - b
No. of times of visit – 1 time – a
2-4 times – b
4-6 times – c
>=6 times – d
Service – Likert’s – (4,5)

Stage 2: Construct tables depending on the combination of variable

a) Gender – Univariate table

Count of Overall
Row Labels satisfaction
Gender
Male 31
Female 19
Grand Total 50

Gender Count Percentage

Male (Y)
Female (N)
 b) Gender/No. of times of visit - Bivariate Table
Count of Overall
satisfaction Column Labels
2-4 4-6 >=6 Grand
Row Labels 1 time times times times Total
Male 2 6 8 15 31
Female 6 5 8 19
Grand Total 8 6 13 23 50

Gender/No. of times 1 time 2-4 times 4-6 times >=6 times

of visit
Male(a)
Female(b)
Count

c) Gender/No. of times of visit/ Service - Trivariate Table

Count of Overall
satisfaction Column Labels
2-4 4-6 >=6 Grand
Row Labels 1 time times times times Total
Male 2 6 8 15 31
3 2 3 5
4 2 4 5 6 17
5 2 1 5 8
2 1 1
Female 6 5 8 19
3 1 1 1 3
4 2 4 3 9
5 3 4 7
Grand Total 8 6 13 23 50
 Gender/Education/Service 1 2-4 4-6 >=6
time times times times
Gender
Male(a)
Female(b)
Service
5
4
3
2
1
Count

Report on Data Analysis:

d) Gender/No. of times of visit/ Service/ Place of stay - Multivariate Table:
Count of Overall
satisfaction Column Labels
2-4 4-6 >=6 Grand
Row Labels 1 time times times times Total
Male 2 6 8 15 31
From Mysore 1 4 5 11 21
3 3 3
4 1 2 4 3 10
5 2 1 5 8
Outside Mysore 1 2 3 4 10
2 1 1
3 2 2
4 1 2 1 3 7
Female 6 5 8 19
From Mysore 5 3 5 13
3 1 1 1 3
4 1 2 3 6
5 3 1 4
Outside Mysore 1 2 3 6
4 1 2 3
5 3 3
Grand Total 8 6 13 23 50
Graphical Representation:
6

3 1 time
2-4 times
4-6 times
2
>=6 times

0
3 4 5 2 3 4 3 4 5 4 5
From Mysore Outside Mysore From Mysore Outside Mysore
Male Female

Inference/ Conclusion – The average satisfaction of male customers who are staying
outside Mysuru visiting the store for 6 or more times is drawn as 4
i.e. Number of people who have given the rating as 4 is 3, likewise with the rating 5 is 0.
Calculation = 4*3/3 = 4
Report on Data Analysis (Combination 2)

Objective 1:
To find the average satisfaction level of the customers who have received the gift and who are
staying in Mysuru and whose marital status is married with respect to home delivery (4, 5). Also, to
find out the percentage of the same.

Methodology:
Tabular and Graphical Representation:

Stage 1: Data dictionary

Received the gift- Yes- a
Stay in Mysore- Yes- a
Marital Status- Married- a
Home delivery- Likert’s scale

Stage 2: Construct Univariate tables

a) Received a gift
Count of Overall
Row Labels satisfaction Percentage of grand total
Received Gift 37 74.40%
Not Received
Gift 13 25.60%
Grand Total 50 100.00%

b) Stay in Mysore
Count of Overall
Row Labels satisfaction Percentage of grand total
Mysuru 34 68.84%
Not Mysuru 16 31.16%
Grand Total 50 100.00%
 c) Marital Status
Count of Overall
Row Labels satisfaction Percentage of grand total
married 28 55.56%
unmarried 22 44.44%
Grand Total 50 100.00%

Stage 3: Construct Trivariate Table

Count of Overall
Row Labels satisfaction Sum of grand total
Received Gift 37 74.40%
married 18 35.99%
unmarried 19 38.41%
Not Received Gift 13 25.60%
married 10 19.57%
unmarried 3 6.04%
Grand Total 50 100.00%
Stage 4: Multivariate Table
Row Labels Mysuru Not Mysuru Grand Total
Received Gift 28 9 37
Married 14 4 18
2 1 1
3 2 2
4 6 2 8
5 5 2 7
Unmarried 14 5 19
1 1 1
2 4 4
3 3 3
4 5 3 8
5 1 2 3
Not Received Gift 6 7 13
Married 4 6 10
2 1 1
3 2 2
4 2 3 5
5 1 1 2
Unmarried 2 1 3
3 1 1
4 1 1
5 1 1
Grand Total 34 16 50
 Graphical Representation
9
8
7
6
5
4
3 Total
2
1
0
2 3 4 5 1 2 3 4 5 2 3 4 5 3 4 5
married unmarried married unmarried
Received Gift Not Received Gift

Inference/Conclusion: There are total 6 customers with 4 score and 5 customers with 5
score. Calculation = Average is 49/11= 4.45
The Average Satisfaction level is 4.45

Report on Data Analysis (Combination 3)

Objective: To find out the average satisfaction of male customers, who are married with
educational qualification of PG course with respect to quality of the products.

Methodology: Tabular and Graphical representation

Stage 1: Data Dictionary

Gender – Male – a

Female – b

Married - Married – a

Un-married – b

Educational Qualification – Tenth – a

Plus-two or intermediate – b

Under-graduation – c

Post-graduation – d

Quality of the products – Likert’s Scale – 4,5

 Stage 2: Construction of Table – Multivariate Table
Count of Overall
satisfaction Column Labels
Plus-two or Under- Post- Grand
Row Labels Tenth intermediate graduation graduation Total
Male 4 6 8 13 31
Married 2 5 8 8 23
2 1 1
3 3 3
4 1 3 6 2 12
5 2 2 3 7
Un-married 2 1 5 8
2 3 3
3 1 2 3
4 1 1 2
Female 6 3 6 4 19
Married 1 1 1 2 5
2 1 1
3 1 1
4 1 1
5 1 1 2
Un-married 5 2 5 2 14
1 1 1
2 1 1
3 1 1
4 3 1 3 7
5 2 1 1 4
Grand Total 10 9 14 17 50

Graphical Representation:
7
6
5
4 Tenth
3
Plus-two or intermediate
2
1 Under-graduation
0 Post-graduation
2 3 4 5 2 3 4 2 3 4 5 1 2 3 4 5
Married Un-married Married Un-married
Male Female

Inference/ Conclusion – The average satisfaction of male customers who are married with
educational qualification of PG course with respect to quality of the products is drawn as 4.6 i.e.
Number of people who have given the rating as 4 is 2, likewise with the rating 5 is 3. Calculation =
4*2+5*3/5 = 4.6
Report on Data Analysis (Combination 4)

Objective: To find the average satisfaction of female customers who are unmarried and
who spend >=15,000 with respect to branded products on Likert’s scale as 4,5.

Methodology: Tabular and graphical representation.

Stage 1: Data Dictionary
Gender - Male – a
Female – b
Married - Married – a
Un-married – b
Average amount spent - <5,000 - a
5,000-10,000 - b
10,000-15,000 - c
>=15000 – d
Branded products – Likert’s scale – 4,5

Stage 2: Construction of tables – Multivariate Table

 Count of Overall
satisfaction Column Labels
5,000- 10,000- Grand
Row Labels <5,000 10,000 15,000 >=15000 Total
Male 9 2 8 12 31
Married 8 2 5 8 23
2 1 1
3 1 2 2 5
4 4 2 1 3 10
5 3 1 3 7
Un-married 1 3 4 8
4 1 3 3 7
5 1 1
Female 5 1 8 5 19
Married 2 2 1 5
4 2 1 1 4
5 1 1
Un-married 3 1 6 4 14
3 1 1 1 3
4 1 1 1 2 5
5 1 4 1 6
Grand Total 14 3 16 17 50

Graphical Representation:
4.5
4
3.5
3
2.5
<5,000
2
5,000-10,000
1.5
10,000-15,000
1
>=15000
0.5
0
2 3 4 5 4 5 4 5 3 4 5
Married Un-married Married Un-married
Male Female

Inference/ Conclusion – The average satisfaction of female customers who are un-
married and who spend >=15,000 with respect to branded products is drawn as 4.3,
i.e. Number of people who have given the rating as 4 is 2, likewise with the rating 5 is 1.
Calculation = 4*2+5*1/3 = 4.3
 Report on Data Analysis (Combination 5)

Objective: To find the average satisfaction of both male, female who are self-
employed, who have been purchasing the product from the store for 5 or more
years with respect to Children play space on Likert’s scale as 4,5.
Methodology: Tabular and Graphical representation.

Stage 1: Data Dictionary

Gender – Male – a
Female – b
Profession – Self-employed – a
Salaried – b
Since how many years they are purchasing the product from the store –
<1 year – a
2-3 years – b
4-5 years – c
>=5 years – d
Children play space – On Likert’s scale – 4,5
Stage 2: Construction on tables – Multivariate Table
Count of Overall satisfaction Column Labels
2-3 4-5 >=5 Grand
Row Labels < 1 year years years years Total
Male 1 8 7 15 31
Self-employed 1 4 3 10 18
2 1 1
3 1 2 3
4 3 2 5 10
5 1 3 4
Salaried 4 4 5 13
3 1 1 2
4 2 2 3 7
5 1 1 2 4
Female 2 8 6 3 19
Self-employed 1 5 4 2 12
3 1 1
4 2 3 1 6
5 1 2 1 1 5
Salaried 1 3 2 1 7
3 1 1 2
4 2 1 3
5 1 1 2
Grand Total 3 16 13 18 50

Graphical Representation:
6

3 < 1 year
2-3 years
2
4-5 years
1 >=5 years

0
2 3 4 5 3 4 5 3 4 5 3 4 5
Self-employed Salaried Self-employed Salaried
Male Female

Inference/ Conclusion – The average satisfaction of both male & female customers who are self-employed
and who have been purchasing the product from the store for 6 or more years with respect to Children play
space is drawn as 4.4, i.e. Number of people who have given the rating as 4 is 6, likewise with the rating 5 is 4.

Calculation = 4*5+5*3+4*1+5*1/10 = 4.4