STATATHON: Unleashing the Power of Statistics in a 48-Hour Knowledge Extravaganza"

sengarvivek696 118 views 17 slides Aug 09, 2024
Slide 1
Slide 1 of 17
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17

About This Presentation

"Join us for STATATHON, a dynamic 2-day event dedicated to exploring statistical knowledge and its real-world applications. From theory to practice, participants engage in intensive learning sessions, workshops, and challenges, fostering a deeper understanding of statistical methodologies and t...


Slide Content

STATATHON
Group 1
Presented by :-
Vivek Sengar
Dhwani Patel
Prince Vadher
Lipi Oza
Sameer Shah
Dhruvi Dudhat

Objectives
To summarise the data
To identify patterns and links by utilizing recent
and historical data.
To find trend pattern
To compare and analyse the data

Discriptive Analysis
Graph and tabular format
Mean, Mode, Median
Correlation and regression

Graph And Tabular Format
This bar chart shows that the
age group between 48-57
shows highest frequency.
723 741 725 767
714
230
0
500
1000
18-2728-3738-4748-5758-6768-77
FREQUENCY
AGE
BAR CHART
AGE FREQUENCY RF CF % F
18-27 723 0.1972318.5385
28-37 741 0.191464 19
38-47 725 0.19218918.5897
48-57 767 0.2295619.6667
58-67 714 0.18367018.3077
68-77 230 0.0639005.89744
GRAND TOTAL 3900 1

Graph and tabular format
This pie chart shows that
maximum shopping behavior is
seen in males.
32%
68%
PIE
FemaleMale
GENDER FREQUENCY RF CF %F
FEMALE 1248 0.321248 32
MALE 2652 0.683900 68
GRAND TOTAL 3900 1

Graph and tabular format
This graph shows that
maximum review rating is given
to 4.5 –5.
REVIEW RATING F RF CF LLULMP
2.5-3 6850.18685 2.532.75
3-3.5 8050.211490 33.53.25
3.5-4 766 0.22256 3.543.75
4-4.5 8050.213061 44.54.25
4.5-5 8390.223900 4.554.75
GRAND TOTAL 3900 1

Graph and tabular format
This line chart shows that
clothing is the category
showing maximum frequency.
0
500
1000
1500
2000
AccessoriesClothing Footwear Outerwear
FREQUENCY
CATEGORY FREQUENCY RF CF %F
ACCESSORIES 1240 0.32124031.7949
CLOTHING 1737 0.45297744.5385
FOOTWEAR 599 0.15357615.359
OUTERWEAR 324 0.0839008.30769
GRAND TOTAL 3900 1

Graph and tabular format
This ogive shows relation
between upper limit and
cumulative frequency.
UL CF
3 685
3.5 1490
4 2256
4.5 3061
5 3900
0
500
1000
1500
2000
2500
3000
3500
4000
4500
3 3.5 4 4.5 5
CF

Graph and tabular format
This pie chart shows that the
shopping does not include
maiximum discount.
PIE CHART
NoYes
DISCOUNT F RF CF %F
NO 2847 0.732847 73
YES 1053 0.273900 27
GRAND TOTAL 3900 1

Mean, Mode, Median and quartile
FEMALE
Purchase Amount (USD)
Mean 59.764
Standard Error 0.379
Median 60.000
Mode 36.000
Standard Deviation 23.685
Sample Variance 560.998
Kurtosis -1.237
Skewness 0.013
Range 80.000
Minimum 20.000
Maximum 100.000
Sum 233081.000
Count 3900.000
MALE
Purchase Amount (USD)
Mean 59.76435897
Standard Error 0.379269813
Median 60
Mode 36
Standard Deviation 23.68539225
Sample Variance 560.9978061
Kurtosis -1.236593691
Skewness 0.012701758
Range 80
Minimum 20
Maximum 100
Sum 233081
Count 3900

INTERPRETATION
●Mean, mode and median of data given is
same as comparison is done between
purchase amount from male and female
point of view.
●There is a slight difference in skewness of
both the data otherwise whole data is same
means there is not much difference
between them.

CORRELATION
PURCHASE AMOUNT (USD) REVIEW RATING
PURCHASE AMOUNT (USD) 1
REVIEW RATING 0.030775923 1
INTERPRETATION
●Correlation between purchase amount and
review rating is positive, meaning that as
one variable increases, the other tends to
increase as well but in this case it is 0.0307
which is close to zero showing a negligible
relationship.

REGRESSION
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.030775923
R Square 0.000947157
Adjusted R Square 0.000690859
Standard Error 23.67720921
Observations 3900
ANOVA
DF SS MS F SIGNIFICANCE F
REGRESSION 1 2071.7463082071.7463083.695519944 0.054631574
RESIDUAL 3898 2185258.7 560.6102359
TOTAL 3899 2187330.446
CoefficientsStandard Errort Stat P-value Lower 95% Upper 95% Lower 95.0%Upper 95.0%
Intercept55.947827512.02120057927.68049253 0.00 51.98511672 59.9105383 51.9851167259.9105383
X Variable 11.0177556420.5294265821.9223735180.054631574-0.020223692 2.055734977 -0.0202236922.055734977

INTERPRETATION
●Inabovegivenregressiontable,
significanceFshowsvalueslightgreater
than0.05,whichisborderline,andthep-
valueforXVariable1isalsoclosetothe
commonsignificancelevelwhichsuggesta
veryweakrelationbetweenselected
variables.

FORECAST
0
5
10
15
20
25
30
35
40
0 5 10 15 20 25
SCATTERED DIAGRAM
●The scattered diagram show random
fluctuation, upward trend with no
seasonality.
●So the best method to find forecast of next
year is moving average method as it shows
minimum error in comparisioin with the
other two.
INTERPRETATION

Conclusion
Thedataishelpfulinknowing
consumer‘sshoppingbehavior.
Thisanalysiscanbeusedinpredicting
futurescopeandtodeterminethe
probabilityofevents.
Thiscanfurtherbeusedindifferent
departmentsforeg:inmaking
marketingstrategyandfinancial
analysis.

Thank You!
Tags