a statistical analysis of malls(customers)

21

Upload: prosenjit-banerjee

Post on 15-Jul-2015

136 views

Category:

Marketing


3 download

TRANSCRIPT

Page 1: A statistical Analysis of Malls(Customers)
Page 2: A statistical Analysis of Malls(Customers)

Agenda Malls Visited

About Malls

Statistical Data on Survey

Conclusion

Page 3: A statistical Analysis of Malls(Customers)

Malls Visited Mani Square

South City Mall

Forum

Page 4: A statistical Analysis of Malls(Customers)

Mani Square Located in Kolkata

Owned by Mani Group

Operational from June 2008

More than 250 stores

Page 5: A statistical Analysis of Malls(Customers)

South City Mall

Located in Kolkata

Opened since January, 2008

Largest mall in Eastern India

134 stores

Page 6: A statistical Analysis of Malls(Customers)

Forum Located in Kolkata

Owned by Rahul saraf

Opened in 2003

Page 7: A statistical Analysis of Malls(Customers)

Statistical Analysis(Male to Female Ratio) Total Female Visitor in Manisquare : 8

Total Male Visitor in Manisquare : 10

Total Female Visitor in South City : 8

Total Male Visitor in South City : 13

Total Female Visitor in Forum : 4

Total Male Visitor in Forum : 7

Page 8: A statistical Analysis of Malls(Customers)

Total Number Customers

Mode = Male

Page 9: A statistical Analysis of Malls(Customers)
Page 10: A statistical Analysis of Malls(Customers)

Ages of CustomerClass Interval Frequency(Fi) Midpoint(Xi) XiFi (Xi-X)2 Cf

0-20 13 10 130 556.96 13

20-40 21 30 630 12.96 34

40-60 10 50 500 268.96 44

60-80 6 70 420 1324.96 50

∑Fi = 50 ∑XiFi =1680 ∑(Xi-X)2=2163.84

Mean=33.6 Mode=28.42 Median=24.8Variance =(∑(Xi-X)2)/49=44.16Standard Deviation =((∑(Xi-X)2)/49) 1/2= 6.64529909 Quartile Deviation=14.4425Coefficient of Variation=Standard Deviation/mean=0.192

Page 11: A statistical Analysis of Malls(Customers)

Age of Customer(Median using graph)

0

10

20

30

40

50

60

0- 20 20-40 40-60 60-80

MorethanLessThan

Page 12: A statistical Analysis of Malls(Customers)
Page 13: A statistical Analysis of Malls(Customers)

Time SpentClass Interval Frequency(Fi) Midpoint(Xi) XiFi (Xi-X)2 Cf

0--1 0 0.5 0 7.0756 0

1--2 9 1.5 13.5 2.7556 9

2--3 13 2.5 32.5 0.4356 22

3--4 18 3.5 63 0.1156 40

4--5 6 4.5 27 1.7956 46

5--6 4 5.5 22 5.4756 50

∑Fi = 50 ∑XiFi =158 ∑(Xi-X)2=17.65

Mean=3.16 Mode=3.294 Median=3.06Variance =(∑(Xi-X)2)/49=0.36Standard Deviation =((∑(Xi-X)2)/49) 1/2= 0.6Quartile Deviation=3.096Coefficient of Variation=Standard Deviation/mean=0.189

Page 14: A statistical Analysis of Malls(Customers)

0

10

20

30

40

50

60

0-1 1--2 2--3 3--4

More Than

Less Than

Page 15: A statistical Analysis of Malls(Customers)
Page 16: A statistical Analysis of Malls(Customers)

Amount SpentClass Interval Frequency(Fi) Midpoint(Xi) XiFi (Xi-X)2 Cf

0-2000 28 1000 28000 2433600 28

2000-4000 11 3000 33000 193600 39

4000-6000 7 5000 35000 5953600 46

6000-8000 2 7000 14000 19713600 48

8000-10000 2 9000 18000 41473600 50

∑Fi = 50 ∑XiFi

=128000∑(Xi-X)2=17.65

Mean=2560 Mode=1217.39 Median=1000Variance =(∑(Xi-X)2)/49=1423836.735 Standard Deviation =((∑(Xi-X)2)/49) 1/2= 1193.246301 Quartile Deviation=1476.47 Coefficient of Variation=Standard Deviation/mean=0.466111836

Page 17: A statistical Analysis of Malls(Customers)

Amount Spent(Median using graph)

0

10

20

30

40

50

60

0-2000 2000-4000 4000-6000 6000-8000 8000-10000

Less than

More than

Page 18: A statistical Analysis of Malls(Customers)

Most Visited Shops(Top 10)

Mode = Spencer

Page 19: A statistical Analysis of Malls(Customers)

Most Items Bought(Top 10)

02468

1012141618

Number of Items bought

Number ofItems…

Mode=Jeans

Page 20: A statistical Analysis of Malls(Customers)

Conclusion More male customers

Age group 0f 20-40 visits mall more

Most customer spends 3.24 hrs(approx)

Most customer spend around Rs 1217

Spencer is the most visited

Jeans was the most sold item

Page 21: A statistical Analysis of Malls(Customers)

Thank you