Rm Numerical Data.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Rm Numerical Data.xlsx as PDF for free.
More details
- Words: 2,534
- Pages: 17
1
Outlet
Organized 82
No of Respondants In %
2 Amount Spent
88.17
11 11.83
Organized Organized (%)
Unorganized
Less than 5000 50001-10000 10001-20000 Above 20000
3 What
Unorganized
49 30 2 1
52.68 32.25 2.15 1.07
5 3 3 0
Organized Organized (%)
Unorganized
is the frequency of shopping?
frequency of shopping weekly Monthly Fortnight basis yearly
15 52 12 3
16.73 55.91 12.9 3.22
7 3 1 0
4) Which organized retailer you prefer for shopping? Organized D-Mart Big-Bazar Db's famalies Grocers Other
No of Resodents
Which organize
% 35 40 1 17
36.08 43 1.07 18.27
50 45 40 35 30 25 20 15
36.08
5 Do you always carry your shopping list
Organized and Unorganized yes No
No of Resodents
% 47 46
50.53 49.46
50 45 40 35 30 25 20 15 10 5 0
36.08
D-Mart
Do you alway 50.8 50.6 50.4 50.2 50 49.8 49.6 49.4 49.2 49 48.8
7
ORGANIZED RETAIL OUTLET Attributes Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
Strongly Agree
Agree
Neutral
52 42 35 30 34 41 37 23 23 37 26 18 11 32 14
24 32 32 35 32 26 37 26 34 26 14 27 26 35 19
5 7 14 16 15 13 8 21 20 14 15 27 32 12 23
How much importance do you give to each this attributes on scale of 1 to 5 purchasing grocery from organized retail store?
8
Attributes Price
1
2
3
0
27
7
0 0 0 0
30 25 28 32
12 16 22 24
Strongly Agree
Agree
Neutral
2 1 3 5 1 2 2 0 0 3 3 3 2 2 6
7 4 6 3 1 4 5 3 3 4 3 6 6 0 2
0 5 2 2 5 2 2 3 3 0 2 2 3 4 1
Convenience Transparency in Billing Sales Person Service Advertisement
UNORGANIZED RETAIL OUTLET Attributes Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
How much importance do you give to each this attributes on scale of 1 to 5 purchasing grocery from organized retail store? Attributes Price Convenience Transparency in Billing Sales Person Service Advertisement Gender * Male Female
1
2
3
7 5 4 5 1
3 5 3 1 2
0 0 3 2 2
62 31
Marital status *
Married Unmarried
50 43
8 7 6 5 4 3 2 1 0
7
7
7 6 5 4 3 2 1 0
Age 20-25 26-30 31-35 36-40 41-45 46-50 Above 60 Years
13 15 17 26 11 6 5
30 25 20 15
13
10
Ch
5
0 Les s tha n 12th Standa Post-Gra duate
Education Less than 12th Standard Up to 12th Standard Graduate Post-Graduate Others
12 23 28 22 8
30 25
23
20 15
12
10
Occupation Service Business Retired Student Housewife Other:
25 22 13 13 16 4
5 0
C Servi ce
Family Income (Monthly) Less than 10000 10001 - 25000 25001 - 50000 50001 - 75000 75001 - 100000 100001- 150000 150001 - 200000 200001 - 250000 250001 - 300000 Above 300001
10 14 14 16 12 0 4 3 1 13
Bus i nes s
30 25 20 15 10 5 0
25 22
No of Respondants 11.83%
Orga ni zed Unorga ni zed
88.17%
Amou nt Sp ent
Unorganized(%)
5.37 3.22 3.22 0
Orga ni zed (%) 60
Unorga ni zed(%)
52.68
50 40
32.25
30 20 10 0
5.37
3.22
Les s than 5000
2.15 3.22
50001-10000
10001-20000
Above 20000 0
What is the frequency of shopping?
Unorganized(%) 60
7.52 3.22 1.07 0
55.91
50 40 30 20 10 0
16.73
12.9
7.52 weekl y
3.22
1.07
Monthl y Orga ni zed (%)
Fortni ght bas i s Unorganized(%)
Which organized retailer you prefer for shopping? % 50 45 40 35 30 25 20 15
1.07
43 36.08
18.27
3.22 yearl y0
50 45 40 35 30 25 20 15 10 5 0
43 36.08
18.27
1.07 D-Mart
Big-Bazar
Db's famalies Grocers
Other
Do you always carry your shopping list ? % 50.8 50.6 50.4 50.2 50 49.8 49.6 49.4 49.2 49 48.8
50.53
49.46
yes
No
Char t Title
Disagree Strongly Disagree
1 1 1 0 1 2 0 11 4 4 1 8 10 2 14
0 0 0 1 0 0 0 1 1 1 0 2 3 1 12
Strongl y Agree Agree Neutra l Di s agree Strongl y Di s a gree 60 52 42 50 41 37 37 35 34 35 34 37 32 35 32 30 32 32 32 40 27 26 26 26 26 26 27 23 23 23 30 24 21 20 19 18 15 14 16 15 13 14 14 14 14 12 12 20 11 11 10 8 8 7 10 51 1 1 1 1 2 1 41 41 1 2 3 21 0 0 0 0 0 0 0 00 0 ge n d l i ty ck me i ce i n g e s ce i n g i ce s e o rk e nt l i ty a n b ra u a sto h e r pr o s i l i ti i e n pp e rv h o u f w ym a ci r t o c b o S Q w c o a f u c o re ct Ne a l s s s e Ch g fa Am S h e r my ce f p di t d / f u tt e r p o a o e o m Pr o f rod e s h tio n nt/l m O rk i n tte S to Be e r t p l e s Cr r r y d e p s e e F mo o u d o Pa B n e l o to m m o i d o i c tte r c e er C o O s r e f W Ch e P D i Fr ett B i ty y o B ix m ri et o Pr Va
attributes on scale of 1 to 5 before nized retail store? 4
5
2
1
Pri ce Sal es Pers on Servi ce 35 30 25 20
27
Conveni ence Advertis ement 32
30 25
28 22 16
24
Transparency in Bi l
Pri ce Sal es Pers on Servi ce 35
2 6 11 8
2 1 5 6
30
27
25
Conveni ence Advertis ement 32
30 25
28 22
20
24
16
15
12
10
11
7
6
5 0
Transparency in Bi l
2 2 0 0 0 1 0 0
2
3
8
1 2 4
Disagree Strongly Disagree
2 1 0 1 4 3 2 5 5 4 3 0 0 4 1
0 0 0 0 0 0 0 0 0 0 0 1 0 2 1
Char t Title Strongl y Agree Dis a gree
5
0 0 0 2 2
0 0 0 1 3
Char t Title Char t Title Price Conveni ence Mal e Femal e Sal es Pers on Service Advertisement 8 7 6 5 4 3 2 1 0
Tra ns parency i n Bi l l i ng
7 5
4
5
5 3
3
Char33.33% t Title 2 1
1
Ma rri ed
1
2
Neutra l
8 7 6 6 6 6 7 5 5 5 5 5 5 6 4 4 4 4 4 4 4 5 3 3 3 33 33 3 33 3 3 3 4 2 2 2 2 2 2 2 22 2 2 2 2 2 2 3 1 1 1 11 1 111 2 1 0 g0e 0 n d 0 l i ty00 o ck 0 me 0 ri ce 0 i n g 0 ti0e s 0 0n ce 0 i n0g 0 i ce 0 u s e0 o rk00 e0nt l i ty v i a n b ra u a st h e p r i e p p e r h o f w aym fa c os i l i o p ct re t Q ew l s c s e r h o fa c mb h o r S y t i u o u c /N a m ce S tte f d fC g es rA p od m e r to p l a s o Cre Pr o f ro d e s h tio n nt/l m O rk i n tte S to B e e r y p d a e e Fr m o o u d o Be n e o s o m mo ic er id rP Cl o i s c re e O t e r f W Ch o ett P D F Bett B i ty y o i m ri et x o Pr Va
attributes on scale of 1 to 5 before nized retail store? 4
Agree Strongl y Di s agree
3
2 2
Unma rri ed 0 066.67% 3
3
2 2
0 0 0 4
1 0 0 0 5
7
7 6 5 4 3 2 1 0
5
4
5
5 3
3
1
1
3
Char33.33% t Title 2 1
Ma rri ed
2 2
Unma rri ed 2 0 066.67% 3
Char t Title
20-25 26-30 36-40 41-45 46.24% Above 60 Years53.76% 30
0 0 0 4
31-35 46-50
26
25 20 13
15 10
15
17 11
Char t Title
5
0 Les s tha n 12th Standard Post-Gra duate
6
Up to 12th Standa rd Others
5
Gra duate
28 23
22
12 8
Char t Title Servi ce
Bus i nes s
Retired
Student
Hous ewi fe
Other:
25 22 16 13
3
2 2
13
4
1 0 0 0 5
7 ORGANIZED RETAIL OUTLET Strongly Agree Attributes Wider Product ran 52 Choice of more br 42 Better product Qua 35 Fresh/New stock 30 Promotional sche 34 Discount/lesser pr 41 Freedom Of Choos 37 Better Parking facil 23 Better Ambience 23 One Stop Shoppin 37 Better Service 26 Closer to my hous 18 Proximity to my pl 11 Variety of modes 32 Credit facility 14
Agree
Neutral
Disagree
24 32 32 35 32 26 37 26 34 26 14 27 26 35 19
5 7 14 16 15 13 8 21 20 14 15 27 32 12 23
1 1 1 0 1 2 0 11 4 4 1 8 10 2 14
How much importance do you give to each this attributes on scale of 1 purchasing grocery from organized retail store?
8 Attributes
1
2
3
4
Price Convenience Transparency in Bil Sales Person Serv Advertisement
0 0 0 0 0
27 30 25 28 32
7 12 16 22 24
2 2 6 11 8
UNORGANIZED RETAIL OUTLET Attributes
Strongly Agree
Agree Neutral Disagreegly Disagree
Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
2 1 3 5 1 2 2 0 0 3 3 3 2 2 6
7 4 6 3 1 4 5 3 3 4 3 6 6 0 2
0 5 2 2 5 2 2 3 3 0 2 2 3 4 1
2 1 0 1 4 3 2 5 5 4 3 0 0 4 1
0 0 0 0 0 0 0 0 0 0 0 1 0 2 1
How much importance do you give to each this attributes on scale of 1 to 5 before purchasing grocery from organized retail store? Attributes Price Convenience Transparency in Billing Sales Person Service Advertisement
1
2
3
4
5
7 5 4 5 1
3 5 3 1 2
0 0 3 2 2
0 0 0 2 2
0 0 0 1 3
Strongly Disagree Anova: Single Factor
0 0 SUMMARY 0 Groups Count 1 52 14 0 24 14 0 5 14 0 1 14 1 0 14 1 1 0 ANOVA 2 Source of Variation SS 3 Between Groups 9397.65714286 1 Within Groups 2852.28571429 12 Total 12249.9428571
Sum 403 401 237 59 22
df
Average 28.78571 28.64286 16.92857 4.214286 1.571429
Variance 97.1044 42.4011 48.84066 21.25824 9.802198
MS F P-value F crit 4 2349.414 53.54019 6.97E-20 2.51304 65 43.88132 69
e to each this attributes on scale of 1 to 5 before ery from organized retail store? Anova: Single Factor 5
1 2 1 5 6
SUMMARY Groups
Count 0 27 7 2 1
Sum 4 4 4 4 4
ANOVA Source of Variation SS Between Groups 2261.5 Within Groups 177.5 Total
Anova: Single Factor
2439
0 115 74 27 14
df
Average 0 28.75 18.5 6.75 3.5
Variance 0 8.916667 30.33333 14.25 5.666667
MS F P-value 4 565.375 47.77817 2.32E-08 15 11.83333 19
SUMMARY Groups
Count 2 7 0 2 0
Sum 14 14 14 14 14
33 50 36 33 4
Average 2.357143 3.571429 2.571429 2.357143 0.285714
Variance 2.862637 3.340659 1.956044 3.478022 0.373626
ANOVA Source of Variation Between Groups Within Groups
80.2 156.1428571429
MS F P-value F crit 4 20.05 8.346523 1.7E-05 2.51304 65 2.402198
Total
236.3428571429
69
SS
df
on scale of 1 to 5 before l store? Anova: Single Factor SUMMARY Groups
Count 7 3 0 0 0
ANOVA Source of Variation Between Groups Within Groups Total
Sum 4 4 4 4 4
SS
15 11 7 4 4
df
Average 3.75 2.75 1.75 1 1
Variance 3.583333 2.916667 1.583333 1.333333 2
22.7 34.25
MS F P-value F crit 4 5.675 2.485401 0.088037 3.055568 15 2.283333
56.95
19
F crit 3.055568
Gender Male Female
62 31
77.5 P-value 77.5
2.580284E-08
13 15 17 26 11 6 5
13.29 P-value 13.29 13.29 13.29 13.29 13.29 13.29
0.000802583
50 43
46.5 P-value 46.5
0.467920807
12 23 28 22 8
18.6 P-value 18.6 18.6 18.6 18.6
0.00514426
25 22 13 13 16 4
15.5 P-value 15.5 15.5 15.5 15.5 15.5
0.003070167
Age 20-25 26-30 31-35 36-40 41-45 46-50 Above 60 Years
Marital status
Married Unmarried
Education Less than 12th Standard Up to 12th Standard Graduate Post-Graduate Others
Occupation Service Business Retired Student Housewife Other:
Family Income (Monthly) Less than 10000 10001 - 25000 25001 - 50000 50001 - 75000 75001 - 100000 100001- 150000 150001 - 200000 200001 - 250000 250001 - 300000 Above 300001
10 14 14 16 12 0 4 3 1 13
9.3 P-value 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3
4.160892E-05
Outlet
Organized 82
No of Respondants In %
2 Amount Spent
88.17
11 11.83
Organized Organized (%)
Unorganized
Less than 5000 50001-10000 10001-20000 Above 20000
3 What
Unorganized
49 30 2 1
52.68 32.25 2.15 1.07
5 3 3 0
Organized Organized (%)
Unorganized
is the frequency of shopping?
frequency of shopping weekly Monthly Fortnight basis yearly
15 52 12 3
16.73 55.91 12.9 3.22
7 3 1 0
4) Which organized retailer you prefer for shopping? Organized D-Mart Big-Bazar Db's famalies Grocers Other
No of Resodents
Which organize
% 35 40 1 17
36.08 43 1.07 18.27
50 45 40 35 30 25 20 15
36.08
5 Do you always carry your shopping list
Organized and Unorganized yes No
No of Resodents
% 47 46
50.53 49.46
50 45 40 35 30 25 20 15 10 5 0
36.08
D-Mart
Do you alway 50.8 50.6 50.4 50.2 50 49.8 49.6 49.4 49.2 49 48.8
7
ORGANIZED RETAIL OUTLET Attributes Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
Strongly Agree
Agree
Neutral
52 42 35 30 34 41 37 23 23 37 26 18 11 32 14
24 32 32 35 32 26 37 26 34 26 14 27 26 35 19
5 7 14 16 15 13 8 21 20 14 15 27 32 12 23
How much importance do you give to each this attributes on scale of 1 to 5 purchasing grocery from organized retail store?
8
Attributes Price
1
2
3
0
27
7
0 0 0 0
30 25 28 32
12 16 22 24
Strongly Agree
Agree
Neutral
2 1 3 5 1 2 2 0 0 3 3 3 2 2 6
7 4 6 3 1 4 5 3 3 4 3 6 6 0 2
0 5 2 2 5 2 2 3 3 0 2 2 3 4 1
Convenience Transparency in Billing Sales Person Service Advertisement
UNORGANIZED RETAIL OUTLET Attributes Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
How much importance do you give to each this attributes on scale of 1 to 5 purchasing grocery from organized retail store? Attributes Price Convenience Transparency in Billing Sales Person Service Advertisement Gender * Male Female
1
2
3
7 5 4 5 1
3 5 3 1 2
0 0 3 2 2
62 31
Marital status *
Married Unmarried
50 43
8 7 6 5 4 3 2 1 0
7
7
7 6 5 4 3 2 1 0
Age 20-25 26-30 31-35 36-40 41-45 46-50 Above 60 Years
13 15 17 26 11 6 5
30 25 20 15
13
10
Ch
5
0 Les s tha n 12th Standa Post-Gra duate
Education Less than 12th Standard Up to 12th Standard Graduate Post-Graduate Others
12 23 28 22 8
30 25
23
20 15
12
10
Occupation Service Business Retired Student Housewife Other:
25 22 13 13 16 4
5 0
C Servi ce
Family Income (Monthly) Less than 10000 10001 - 25000 25001 - 50000 50001 - 75000 75001 - 100000 100001- 150000 150001 - 200000 200001 - 250000 250001 - 300000 Above 300001
10 14 14 16 12 0 4 3 1 13
Bus i nes s
30 25 20 15 10 5 0
25 22
No of Respondants 11.83%
Orga ni zed Unorga ni zed
88.17%
Amou nt Sp ent
Unorganized(%)
5.37 3.22 3.22 0
Orga ni zed (%) 60
Unorga ni zed(%)
52.68
50 40
32.25
30 20 10 0
5.37
3.22
Les s than 5000
2.15 3.22
50001-10000
10001-20000
Above 20000 0
What is the frequency of shopping?
Unorganized(%) 60
7.52 3.22 1.07 0
55.91
50 40 30 20 10 0
16.73
12.9
7.52 weekl y
3.22
1.07
Monthl y Orga ni zed (%)
Fortni ght bas i s Unorganized(%)
Which organized retailer you prefer for shopping? % 50 45 40 35 30 25 20 15
1.07
43 36.08
18.27
3.22 yearl y0
50 45 40 35 30 25 20 15 10 5 0
43 36.08
18.27
1.07 D-Mart
Big-Bazar
Db's famalies Grocers
Other
Do you always carry your shopping list ? % 50.8 50.6 50.4 50.2 50 49.8 49.6 49.4 49.2 49 48.8
50.53
49.46
yes
No
Char t Title
Disagree Strongly Disagree
1 1 1 0 1 2 0 11 4 4 1 8 10 2 14
0 0 0 1 0 0 0 1 1 1 0 2 3 1 12
Strongl y Agree Agree Neutra l Di s agree Strongl y Di s a gree 60 52 42 50 41 37 37 35 34 35 34 37 32 35 32 30 32 32 32 40 27 26 26 26 26 26 27 23 23 23 30 24 21 20 19 18 15 14 16 15 13 14 14 14 14 12 12 20 11 11 10 8 8 7 10 51 1 1 1 1 2 1 41 41 1 2 3 21 0 0 0 0 0 0 0 00 0 ge n d l i ty ck me i ce i n g e s ce i n g i ce s e o rk e nt l i ty a n b ra u a sto h e r pr o s i l i ti i e n pp e rv h o u f w ym a ci r t o c b o S Q w c o a f u c o re ct Ne a l s s s e Ch g fa Am S h e r my ce f p di t d / f u tt e r p o a o e o m Pr o f rod e s h tio n nt/l m O rk i n tte S to Be e r t p l e s Cr r r y d e p s e e F mo o u d o Pa B n e l o to m m o i d o i c tte r c e er C o O s r e f W Ch e P D i Fr ett B i ty y o B ix m ri et o Pr Va
attributes on scale of 1 to 5 before nized retail store? 4
5
2
1
Pri ce Sal es Pers on Servi ce 35 30 25 20
27
Conveni ence Advertis ement 32
30 25
28 22 16
24
Transparency in Bi l
Pri ce Sal es Pers on Servi ce 35
2 6 11 8
2 1 5 6
30
27
25
Conveni ence Advertis ement 32
30 25
28 22
20
24
16
15
12
10
11
7
6
5 0
Transparency in Bi l
2 2 0 0 0 1 0 0
2
3
8
1 2 4
Disagree Strongly Disagree
2 1 0 1 4 3 2 5 5 4 3 0 0 4 1
0 0 0 0 0 0 0 0 0 0 0 1 0 2 1
Char t Title Strongl y Agree Dis a gree
5
0 0 0 2 2
0 0 0 1 3
Char t Title Char t Title Price Conveni ence Mal e Femal e Sal es Pers on Service Advertisement 8 7 6 5 4 3 2 1 0
Tra ns parency i n Bi l l i ng
7 5
4
5
5 3
3
Char33.33% t Title 2 1
1
Ma rri ed
1
2
Neutra l
8 7 6 6 6 6 7 5 5 5 5 5 5 6 4 4 4 4 4 4 4 5 3 3 3 33 33 3 33 3 3 3 4 2 2 2 2 2 2 2 22 2 2 2 2 2 2 3 1 1 1 11 1 111 2 1 0 g0e 0 n d 0 l i ty00 o ck 0 me 0 ri ce 0 i n g 0 ti0e s 0 0n ce 0 i n0g 0 i ce 0 u s e0 o rk00 e0nt l i ty v i a n b ra u a st h e p r i e p p e r h o f w aym fa c os i l i o p ct re t Q ew l s c s e r h o fa c mb h o r S y t i u o u c /N a m ce S tte f d fC g es rA p od m e r to p l a s o Cre Pr o f ro d e s h tio n nt/l m O rk i n tte S to B e e r y p d a e e Fr m o o u d o Be n e o s o m mo ic er id rP Cl o i s c re e O t e r f W Ch o ett P D F Bett B i ty y o i m ri et x o Pr Va
attributes on scale of 1 to 5 before nized retail store? 4
Agree Strongl y Di s agree
3
2 2
Unma rri ed 0 066.67% 3
3
2 2
0 0 0 4
1 0 0 0 5
7
7 6 5 4 3 2 1 0
5
4
5
5 3
3
1
1
3
Char33.33% t Title 2 1
Ma rri ed
2 2
Unma rri ed 2 0 066.67% 3
Char t Title
20-25 26-30 36-40 41-45 46.24% Above 60 Years53.76% 30
0 0 0 4
31-35 46-50
26
25 20 13
15 10
15
17 11
Char t Title
5
0 Les s tha n 12th Standard Post-Gra duate
6
Up to 12th Standa rd Others
5
Gra duate
28 23
22
12 8
Char t Title Servi ce
Bus i nes s
Retired
Student
Hous ewi fe
Other:
25 22 16 13
3
2 2
13
4
1 0 0 0 5
7 ORGANIZED RETAIL OUTLET Strongly Agree Attributes Wider Product ran 52 Choice of more br 42 Better product Qua 35 Fresh/New stock 30 Promotional sche 34 Discount/lesser pr 41 Freedom Of Choos 37 Better Parking facil 23 Better Ambience 23 One Stop Shoppin 37 Better Service 26 Closer to my hous 18 Proximity to my pl 11 Variety of modes 32 Credit facility 14
Agree
Neutral
Disagree
24 32 32 35 32 26 37 26 34 26 14 27 26 35 19
5 7 14 16 15 13 8 21 20 14 15 27 32 12 23
1 1 1 0 1 2 0 11 4 4 1 8 10 2 14
How much importance do you give to each this attributes on scale of 1 purchasing grocery from organized retail store?
8 Attributes
1
2
3
4
Price Convenience Transparency in Bil Sales Person Serv Advertisement
0 0 0 0 0
27 30 25 28 32
7 12 16 22 24
2 2 6 11 8
UNORGANIZED RETAIL OUTLET Attributes
Strongly Agree
Agree Neutral Disagreegly Disagree
Wider Product range Choice of more brand Better product Quality Fresh/New stock Promotional scheme Discount/lesser price Freedom Of Choosing Better Parking facilities Better Ambience One Stop Shopping Better Service Closer to my house Proximity to my place of work Variety of modes of payment Credit facility
2 1 3 5 1 2 2 0 0 3 3 3 2 2 6
7 4 6 3 1 4 5 3 3 4 3 6 6 0 2
0 5 2 2 5 2 2 3 3 0 2 2 3 4 1
2 1 0 1 4 3 2 5 5 4 3 0 0 4 1
0 0 0 0 0 0 0 0 0 0 0 1 0 2 1
How much importance do you give to each this attributes on scale of 1 to 5 before purchasing grocery from organized retail store? Attributes Price Convenience Transparency in Billing Sales Person Service Advertisement
1
2
3
4
5
7 5 4 5 1
3 5 3 1 2
0 0 3 2 2
0 0 0 2 2
0 0 0 1 3
Strongly Disagree Anova: Single Factor
0 0 SUMMARY 0 Groups Count 1 52 14 0 24 14 0 5 14 0 1 14 1 0 14 1 1 0 ANOVA 2 Source of Variation SS 3 Between Groups 9397.65714286 1 Within Groups 2852.28571429 12 Total 12249.9428571
Sum 403 401 237 59 22
df
Average 28.78571 28.64286 16.92857 4.214286 1.571429
Variance 97.1044 42.4011 48.84066 21.25824 9.802198
MS F P-value F crit 4 2349.414 53.54019 6.97E-20 2.51304 65 43.88132 69
e to each this attributes on scale of 1 to 5 before ery from organized retail store? Anova: Single Factor 5
1 2 1 5 6
SUMMARY Groups
Count 0 27 7 2 1
Sum 4 4 4 4 4
ANOVA Source of Variation SS Between Groups 2261.5 Within Groups 177.5 Total
Anova: Single Factor
2439
0 115 74 27 14
df
Average 0 28.75 18.5 6.75 3.5
Variance 0 8.916667 30.33333 14.25 5.666667
MS F P-value 4 565.375 47.77817 2.32E-08 15 11.83333 19
SUMMARY Groups
Count 2 7 0 2 0
Sum 14 14 14 14 14
33 50 36 33 4
Average 2.357143 3.571429 2.571429 2.357143 0.285714
Variance 2.862637 3.340659 1.956044 3.478022 0.373626
ANOVA Source of Variation Between Groups Within Groups
80.2 156.1428571429
MS F P-value F crit 4 20.05 8.346523 1.7E-05 2.51304 65 2.402198
Total
236.3428571429
69
SS
df
on scale of 1 to 5 before l store? Anova: Single Factor SUMMARY Groups
Count 7 3 0 0 0
ANOVA Source of Variation Between Groups Within Groups Total
Sum 4 4 4 4 4
SS
15 11 7 4 4
df
Average 3.75 2.75 1.75 1 1
Variance 3.583333 2.916667 1.583333 1.333333 2
22.7 34.25
MS F P-value F crit 4 5.675 2.485401 0.088037 3.055568 15 2.283333
56.95
19
F crit 3.055568
Gender Male Female
62 31
77.5 P-value 77.5
2.580284E-08
13 15 17 26 11 6 5
13.29 P-value 13.29 13.29 13.29 13.29 13.29 13.29
0.000802583
50 43
46.5 P-value 46.5
0.467920807
12 23 28 22 8
18.6 P-value 18.6 18.6 18.6 18.6
0.00514426
25 22 13 13 16 4
15.5 P-value 15.5 15.5 15.5 15.5 15.5
0.003070167
Age 20-25 26-30 31-35 36-40 41-45 46-50 Above 60 Years
Marital status
Married Unmarried
Education Less than 12th Standard Up to 12th Standard Graduate Post-Graduate Others
Occupation Service Business Retired Student Housewife Other:
Family Income (Monthly) Less than 10000 10001 - 25000 25001 - 50000 50001 - 75000 75001 - 100000 100001- 150000 150001 - 200000 200001 - 250000 250001 - 300000 Above 300001
10 14 14 16 12 0 4 3 1 13
9.3 P-value 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3 9.3
4.160892E-05
Related Documents
Rm Numerical Data.xlsx
November 2019 24
Numerical
December 2019 24
Numerical
October 2019 21
Numerical
May 2020 7
Numerical
November 2019 26
Rm
June 2020 36More Documents from "usuarioich"
Rm Numerical Data.xlsx
November 2019 24
References.docx
November 2019 28
Breakout Nations 3.docx
November 2019 28
Ieo Report 26-12-2014.docx
November 2019 24
Vivo.pdf
June 2020 8