๐ข GeeksforGeeks โ Puzzles & Guesstimates (60 Questions)
Fresher Data Analyst โ Brain Teasers & Estimationโ
PART A: PUZZLES (30 Questions)
Logic & Pattern Puzzles (Q1โQ10)โ
Q1: You have 8 identical-looking balls. One is heavier. Find it using a balance scale in minimum weighings.โ
Answer: 2 weighings
Weighing 1: Put 3 balls on each side, keep 3 aside.
โ If balanced: Heavy ball is in the 3 kept aside.
โ If unbalanced: Heavy ball is in the heavier group of 3.
Weighing 2: Take the group of 3 containing the heavy ball.
Put 1 on each side, keep 1 aside.
โ If balanced: The one kept aside is heavy. โ
โ If unbalanced: The heavier side has it. โ
๐ง Pattern: For N balls, minimum weighings = โlogโ(N)โ. For 8 balls: โlogโ(8)โ = 2.
Q2: You have two hourglasses โ one measures 7 minutes, one measures 4 minutes. Measure exactly 9 minutes.โ
Step 1 (t=0): Start BOTH hourglasses simultaneously.
Step 2 (t=4): 4-min hourglass finishes. Flip it immediately.
7-min hourglass has 3 minutes left.
Step 3 (t=7): 7-min hourglass finishes (3 mins passed since step 2).
4-min hourglass has 1 minute left. Flip the 7-min glass.
Step 4 (t=8): 4-min hourglass finishes (1 min passed).
7-min hourglass has been running for 1 minute.
Flip the 7-min glass.
Step 5 (t=9): 7-min hourglass runs for 1 more minute.
Total = 9 minutes โ
Q3: 3 people check into a hotel. They pay โน30 (โน10 each). The manager realizes the room is โน25 and sends โน5 back with the bellboy. The bellboy keeps โน2 and gives โน1 back to each person. Each person paid โน9 (total โน27). Bellboy has โน2. โน27 + โน2 = โน29. Where's the missing โน1?โ
Answer: There is NO missing rupee โ the question is phrased to mislead.
Correct accounting:
- Guests paid: โน27 total
- Of that โน27: โน25 went to the hotel + โน2 to the bellboy
- โน27 = โน25 + โน2 โ
(All accounted for)
The trick: โน27 + โน2 should NOT be added together.
โน27 is what they PAID (includes bellboy's โน2).
The โน2 is already inside the โน27, not separate. โ
Q4: You have 1000 data entries. 1% are labelled "fraud." You build a model that has 90% accuracy. How many fraud entries does it correctly identify?โ
Total entries = 1000
Fraud entries = 1% of 1000 = 10
Non-fraud = 990
If model has 90% accuracy overall, that doesn't tell us about fraud specifically.
Let's assume 90% recall for fraud:
Correctly identified fraud = 90% of 10 = 9 โ
Missed fraud = 1
BUT: If 90% is overall accuracy, and the model just predicts "Not Fraud"
always โ Accuracy = 990/1000 = 99%! Way above 90%.
This is the accuracy paradox โ 90% accuracy can still miss fraud. โ
๐ง Data analyst insight: Always ask what KIND of accuracy. Overall accuracy is meaningless for imbalanced datasets.
Q5: A father is 4 times as old as his son. In 20 years, he'll be twice as old. Find their current ages.โ
Let son's age = x, father's age = 4x
In 20 years: 4x + 20 = 2(x + 20)
4x + 20 = 2x + 40
2x = 20
x = 10
Son = 10 years, Father = 40 years โ
Check: In 20 years โ Son=30, Father=60 โ 60=2ร30 โ
Q6: A circular table has 6 seats. In how many ways can 6 people be seated?โ
Circular permutations = (n-1)!
= (6-1)! = 5! = 120 ways โ
Why (n-1)!: In a circle, one person is "fixed" as reference
(rotations of the same arrangement are identical).
Q7: There are 100 doors. All closed. Person 1 opens all. Person 2 toggles every 2nd. Person 3 toggles every 3rd... Person 100 toggles the 100th. Which doors remain open?โ
Answer: Doors 1, 4, 9, 16, 25, 36, 49, 64, 81, 100 โ Perfect squares!
Why: Door N gets toggled once for each of its divisors.
Most numbers have an EVEN number of divisors โ net closed.
Perfect squares have ODD number of divisors (e.g., 36: 1,2,3,4,6,9,12,18,36)
โ net open. โ
Q8: A snail climbs 3 meters during the day and slips 2 meters at night. The wall is 10 meters. How many days to reach the top?โ
Net progress per day = 3 - 2 = 1 meter
BUT: On the last day, the snail reaches the top and doesn't slip back.
After 7 days: Position = 7 meters
Day 8: Climbs 3 meters โ reaches 10 meters โ DONE!
Answer: 8 days โ
(not 10!)
Q9: You're given a dataset of 1 million rows. 500 rows have missing values in the "income" column. Should you drop those rows or impute?โ
Answer: IMPUTE (almost certainly).
Reasoning:
- Missing = 500/1,000,000 = 0.05% โ negligible loss if dropped
- BUT: Check if missing is random (MCAR) or patterned (MNAR)
- If missing because high-income people don't report โ dropping
introduces bias
- If random โ either approach works
Best approach:
1. Check the pattern of missing data
2. If MCAR โ Mean/Median imputation is fine
3. If MNAR โ Use model-based imputation or create a "missing" indicator
4. With 1M rows, dropping 500 is also acceptable if truly random โ
Q10: Three friends each pick a number from 1-10. What's the probability all three pick the same number?โ
Person 1: Any number โ 10/10 = 1
Person 2: Must match Person 1 โ 1/10
Person 3: Must match both โ 1/10
P(all same) = 1 ร 1/10 ร 1/10 = 1/100 = 1% โ
Data & Analytics Puzzles (Q11โQ20)โ
Q11: A website has 10,000 daily visitors and 2% conversion rate. After a redesign, conversion becomes 2.5%. How many extra conversions per month?โ
Before: 10,000 ร 0.02 = 200 conversions/day
After: 10,000 ร 0.025 = 250 conversions/day
Extra per day = 50
Extra per month = 50 ร 30 = 1,500 conversions โ
Q12: If you pick 2 cards from a deck, what's the probability they're both aces?โ
P(1st ace) = 4/52
P(2nd ace | 1st ace) = 3/51
P(both aces) = 4/52 ร 3/51 = 12/2652 = 1/221 โ 0.45% โ
Q13: You have sales data for 12 months. The average is โน10L/month. You know Jan=โน8L, Feb=โน12L. Someone claims the SD is โน1L. Is this reasonable?โ
Already Jan is โน2L below mean and Feb is โน2L above mean.
Deviations of ยฑ2L from a mean of 10L suggest SD > 1L.
If SD were truly 1L, then 95% of months should be within
โน8L-โน12L (mean ยฑ 2SD). Both Jan and Feb are at the 2ฯ boundary.
With only 2 data points already at 2ฯ away, the claim of SD=โน1L
is suspicious but not impossible. We'd need all 12 months to verify.
Most likely SD is closer to โน2L or more. โ
Q14: A city bus arrives every 15 minutes. You show up at a random time. Average wait time?โ
If arrivals are perfectly periodic (every 15 min) and you
arrive at a uniformly random time within the interval:
Average wait = 15/2 = 7.5 minutes โ
For exponential arrivals (Poisson process with mean 15 min):
Average wait = 15 minutes (memoryless property) โ counter-intuitive!
Q15: In a room of 30 people, what's the probability at least two share a birthday?โ
This is the Birthday Paradox!
P(no shared birthday) = 365/365 ร 364/365 ร 363/365 ร ... ร 336/365
โ 0.2937
P(at least one shared) = 1 - 0.2937 โ 70.6% โ
With just 23 people, it crosses 50%!
Q16: A/B test: Group A (1000 users): 50 conversions. Group B (1000 users): 65 conversions. Is this significant?โ
Rate A = 5.0%, Rate B = 6.5%
Difference = 1.5 percentage points
Quick significance check (pooled proportion):
p_pool = (50+65)/(1000+1000) = 115/2000 = 0.0575
SE = sqrt(p_pool ร (1-p_pool) ร (1/1000 + 1/1000))
= sqrt(0.0575 ร 0.9425 ร 0.002) โ 0.01043
Z = (0.065 - 0.05) / 0.01043 โ 1.44
p-value โ 0.075 โ NOT significant at ฮฑ=0.05 โ
Need more data (larger sample size) to confirm. โ
Q17: You get 3 job offers with salaries โน5L, โน6L, โน8L. The โน8L job has 40% chance of being rescinded. Expected salary if you pick the highest?โ
E(salary from โน8L offer) = 0.6 ร 8L + 0.4 ร 0 = โน4.8L
(Assuming you get nothing if rescinded and don't have a backup)
If backup is the โน6L offer:
E = 0.6 ร 8L + 0.4 ร 6L = 4.8L + 2.4L = โน7.2L โ
Best strategy: Accept โน8L but keep โน6L as backup.
Q18: A data pipeline processes 10,000 records/minute. If a batch of 500,000 records needs processing and the pipeline has 5% failures (which need reprocessing), how long will it take?โ
First pass: 500,000 records โ 500,000/10,000 = 50 minutes
Failures: 5% of 500,000 = 25,000 records
Second pass: 25,000/10,000 = 2.5 minutes
Failures from second: 5% of 25,000 = 1,250 โ negligible
Total โ 50 + 2.5 + 0.125 โ 52.6 minutes โ
(Geometric series: 50 ร (1/(1-0.05)) โ 52.63 minutes)
Q19: You flip a coin until you get heads. Expected number of flips?โ
Geometric distribution with p = 0.5
E(X) = 1/p = 1/0.5 = 2 flips โ
Intuition: 50% chance on first flip, 25% chance on second,
12.5% on third... averages out to 2.
Q20: In a dataset of customer ages, you notice the mean is 35 and median is 28. What can you conclude?โ
Mean > Median โ RIGHT-skewed distribution
Interpretation:
- Most customers are younger (clustered around 28)
- A few older customers pull the mean up to 35
- The "typical" customer is closer to 28 (median)
Report the median as the central tendency measure.
The distribution looks similar to income distributions โ
many young users with a long tail of older ones. โ
Rapid-Fire Logic (Q21โQ30)โ
Q21: If it takes 5 machines 5 minutes to make 5 widgets, how long would 100 machines take to make 100 widgets?โ
Each machine makes 1 widget in 5 minutes.
100 machines make 100 widgets in 5 minutes (all work in parallel). โ
Q22: A lily pad doubles in size every day. It takes 48 days to cover the entire lake. On what day was it half-covered?โ
Day 47 โ
(Because it doubles on day 48 to cover the whole lake)
Q23: You have 12 months of data showing declining sales. Is this enough to conclude the product is failing?โ
NO. Need to consider:
1. Seasonality โ is this the off-season? Compare YoY
2. Market trends โ is the entire category declining?
3. External factors โ recession, competitor launch?
4. Sample size โ 12 data points is very few for trend analysis
5. Statistical significance โ is the decline significant or random?
Action: Compare YoY same-month, check industry benchmarks. โ
Q24: Two trains start from the same station in opposite directions at 40 km/hr and 60 km/hr. How far apart after 3 hours?โ
Relative speed = 40 + 60 = 100 km/hr (opposite directions โ add)
Distance after 3 hours = 100 ร 3 = 300 km โ
Q25: A password must be 4 characters: 2 letters (A-Z) followed by 2 digits (0-9). How many possible passwords?โ
Letter 1: 26 choices
Letter 2: 26 choices
Digit 1: 10 choices
Digit 2: 10 choices
Total = 26 ร 26 ร 10 ร 10 = 67,600 โ
Q26: You survey 1000 people. 600 say they exercise daily. What's the margin of error at 95% confidence?โ
p = 0.6, n = 1000
ME = 1.96 ร sqrt(pร(1-p)/n)
= 1.96 ร sqrt(0.6ร0.4/1000)
= 1.96 ร sqrt(0.00024)
= 1.96 ร 0.01549
= 0.0304 โ 3.0% โ
Report: 60% ยฑ 3% with 95% confidence.
Q27: An e-commerce site has 1M users. 10% are monthly active. 5% of active users make a purchase. Average order = โน2000. Monthly revenue?โ
Active users = 1M ร 10% = 100,000
Purchasing users = 100,000 ร 5% = 5,000
Monthly revenue = 5,000 ร โน2,000 = โน1,00,00,000 = โน1 Crore โ
Q28: What is the probability of rolling at least one 6 in four rolls of a die?โ
P(no 6 in one roll) = 5/6
P(no 6 in four rolls) = (5/6)โด = 625/1296 โ 0.482
P(at least one 6) = 1 - 0.482 = 0.518 โ 51.8% โ
Q29: You have a CSV with 50 columns. 5 columns have >50% missing data. What do you do?โ
Step 1: Analyze WHY data is missing (MCAR/MAR/MNAR)
Step 2: For columns with >50% missing:
- Check if they're important for the analysis
- If not critical โ DROP the column (not the rows)
- If critical โ consider creating a "missing" indicator
variable plus imputation of remaining values
Step 3: For moderate missing (5-50%):
- Numerical: median imputation
- Categorical: mode imputation or "Unknown" category
NEVER drop 50% of your rows just because one column is empty! โ
Q30: A company's customer base grew from 10,000 to 15,000 in one year, but revenue dropped from โน5 Crore to โน4.5 Crore. Explain this paradox.โ
Customer growth: +50%
Revenue decline: -10%
Revenue per customer changed:
Before: 5Cr / 10,000 = โน5,000 per customer
After: 4.5Cr / 15,000 = โน3,000 per customer โ DOWN 40%
Possible explanations:
1. New customers are lower-value (freemium or discount-acquired)
2. Existing customers are spending less (churn of high-value segment)
3. Pricing changes (discounts to drive growth)
4. Product mix shift (selling cheaper products)
Key insight: Growth in users โ growth in revenue.
Quality of customers matters more than quantity. โ
PART B: GUESSTIMATES (30 Questions)
Framework: Always structure your answer as: Assumptions โ Breakdown โ Calculation โ Sanity Check
G1: How many ATMs are there in India?โ
Assumptions:
- India population: ~140 crore
- Banking population (adults with accounts): ~60% = 84 crore
- Urban:Rural = 35:65
- Urban areas: 1 ATM per 2,000 people
- Rural areas: 1 ATM per 10,000 people
Calculation:
- Urban: 49 crore / 2,000 = 2,45,000
- Rural: 91 crore / 10,000 = 91,000
- Total โ 2,45,000 + 91,000 โ 3,36,000
Sanity check: RBI data says ~2.5L ATMs.
Our estimate is slightly high but in the right ballpark. โ
G2: How many litres of milk does Delhi consume daily?โ
Assumptions:
- Delhi population: ~2 crore (20 million)
- Average household size: 4 people
- Households: 50 lakh
- 80% households consume milk
- Average consumption: 1 litre per household per day
Calculation:
- Consuming households: 50L ร 0.8 = 40 lakh
- Daily consumption: 40 lakh litres โ 40 million litres
Sanity check: Mother Dairy alone supplies ~30L litres/day to Delhi.
Total market including Amul, local vendors โ 40-50L litres. โ
G3: Estimate the number of Uber rides in Bangalore per day.โ
Assumptions:
- Bangalore population: ~1.3 crore
- Working population: ~45% = 58.5 lakh
- Daily commuters: ~70% = 41 lakh
- % using ride-sharing: ~8% = 3.3 lakh
- Average rides per user per day: 1.5 (some do round trips)
Calculation:
- Daily rides = 3.3L ร 1.5 = ~5 lakh rides
- Add non-commute rides (shopping, airport, etc.): +30%
- Total โ 5L ร 1.3 = 6.5 lakh rides โ 650,000 rides/day
Split: Uber ~45% of market โ ~2.9 lakh Uber rides/day โ
G4: How many pizza deliveries does Domino's India make per day?โ
Assumptions:
- Domino's India stores: ~1,900
- Categories: Metro stores, Tier-2, Tier-3
- Metro (40%): 760 stores ร 120 orders/day = 91,200
- Tier-2 (35%): 665 stores ร 80 orders/day = 53,200
- Tier-3 (25%): 475 stores ร 40 orders/day = 19,000
Calculation:
- Total daily orders โ 1,63,400
- Delivery % (vs dine-in/takeaway): ~65%
- Daily deliveries โ 1,63,400 ร 0.65 โ 1,06,000 โ
G5: Estimate the number of data analysts in India.โ
Assumptions:
- India IT/ITES workforce: ~50 lakh
- % in analytics/data roles: ~8% = 4 lakh
- Non-IT companies with data analysts:
BFSI, Retail, Consulting, etc. โ 2 lakh
- Startups: ~1 lakh
Total data analysts โ 4 + 2 + 1 = ~7 lakh โ
Industry reports estimate 5-8 lakh. Our number checks out.
G6: How much revenue does a typical chai stall near a Delhi metro station make per month?โ
Assumptions:
- Operating hours: 7 AM - 9 PM (14 hours)
- Peak hours (7-10 AM, 5-8 PM): 6 hours โ 40 cups/hr
- Off-peak: 8 hours โ 15 cups/hr
- Average price: โน15 per cup
- Days/month: 28 (2 off days)
Daily cups = (6 ร 40) + (8 ร 15) = 240 + 120 = 360 cups
Daily revenue = 360 ร โน15 = โน5,400
Monthly revenue = โน5,400 ร 28 = โน1,51,200
Cost (tea, sugar, milk, rent, labor) โ 55%
Monthly profit โ โน68,000 โ
G7: How many mobile phones are sold in India per year?โ
Assumptions:
- India population: 140 crore
- Mobile internet users: ~75 crore
- Average phone replacement cycle: 2.5 years
- New users per year: ~3 crore
Annual sales = existing users replacing + new users
= (75 crore / 2.5) + 3 crore = 30 crore + 3 crore = 33 crore
Sanity check: IDC reports ~15 crore smartphones + feature phones.
Our estimate is high โ adjustment: many feature phone users
don't replace as often (5-year cycle).
Revised: (40Cr smartphones/2.5) + (35Cr feature/5) + 3Cr new
= 16 + 7 + 3 = ~26 crore โ reasonable โ
G8: Estimate the total amount of data generated by Swiggy per day.โ
Assumptions:
- Daily orders: ~25 lakh
- Data per order:
- Order details: ~2 KB
- Location pings (GPS): 100 pings ร 200 bytes = 20 KB per order
- App events/logs: ~50 KB per order session
- Images (menu, restaurant): cached, not regenerated
Per order data = ~72 KB
Order data = 25L ร 72 KB โ 180 GB
Additional:
- Search queries: 50L queries ร 1 KB = 50 GB
- Restaurant analytics: ~10 GB
- Driver tracking: 5L drivers ร 1000 pings ร 200B = 100 GB
- App logs/errors: ~50 GB
Total โ 180 + 50 + 10 + 100 + 50 โ 390 GB/day โ ~400 GB/day โ
G9: How many WhatsApp messages are sent in India per day?โ
Assumptions:
- WhatsApp users in India: ~50 crore
- Daily active users: ~70% = 35 crore
- Categories:
- Heavy users (20%): 7Cr ร 100 messages/day = 700Cr
- Moderate (50%): 17.5Cr ร 30 messages/day = 525Cr
- Light (30%): 10.5Cr ร 10 messages/day = 105Cr
Total = 700 + 525 + 105 = 1,330 crore โ 13 billion messages/day
Global WhatsApp: ~100 billion messages/day
India โ 13% of global โ plausible (India has ~25% of users). โ
G10: What's the annual revenue of the Indian wedding industry?โ
Assumptions:
- Marriages per year: ~1 crore (Census data)
- Categories by budget:
- Budget (40%): 4L weddings ร โน5L avg = โน20,000 Cr
- Mid-range (40%): 4L weddings ร โน15L avg = โน60,000 Cr
- Luxury (15%): 1.5L weddings ร โน50L avg = โน75,000 Cr
- Ultra-luxury (5%): 0.5L ร โน2Cr avg = โน1,00,000 Cr
Total โ โน2,55,000 Crore โ โน2.5 Lakh Crore โ $30 Billion
Industry estimates: $50-75 billion โ our estimate is conservative.
We likely undercount vendor services, jewelry, real estate etc. โ
G11โG15: Quick Estimates (Answer in one calculation block each)โ
G11: Number of petrol pumps in Indiaโ
India has ~6 lakh villages + ~8,000 cities/towns.
Assume: 1 pump per 3 villages + 10 pumps per town avg
= 2L + 80,000 = ~2.8 lakh
Actual: ~85,000 (government regulated โ much fewer than expected)
Lesson: Regulated industries don't follow pure demand-supply logic. โ
G12: Daily water consumption of Mumbaiโ
Population: 2 crore, Per capita: 150 litres/day
= 2Cr ร 150L = 300 crore litres = 3,000 million litres/day (MLD)
Actual: BMC supplies ~3,800 MLD โ
G13: Number of flights from Delhi airport per dayโ
Terminals: 3, Gates: ~100, Avg turnaround: 1 hour
Operating hours: 18 hours (6 AM - midnight)
= 100 gates ร 18 departures/gate = 1,800
But utilization ~60% = ~1,080 departures
Add arrivals โ same โ ~2,000 flight movements/day
Actual: ~1,200 flights/day (departures+arrivals) โ
G14: Revenue of a single Zomato delivery partner per monthโ
Deliveries/day: 12-15 (avg 13)
Per delivery earning: โน35 (base) + โน15 (distance) = โน50
Working days: 26
Monthly = 13 ร 50 ร 26 = โน16,900
Plus tips and incentives โ โน2,000
Total โ โน18,900/month โ
G15: How many teachers are there in India?โ
Students: ~25 crore (school) + ~4 crore (college) = 29 crore
Student-teacher ratios: School ~30:1, College ~25:1
Teachers: 25Cr/30 + 4Cr/25 = 83L + 16L = ~99 lakh โ 1 crore
Actual: ~95 lakh (school) + ~15 lakh (higher ed) = ~1.1 crore โ
G16โG20: Business & Market Sizingโ
G16: Estimate the total revenue of coaching institutes (like BYJU's, Unacademy) in India per year.โ
Target market: Students in classes 6-12 + competitive exam aspirants
= ~15 crore students (school) + ~2 crore aspirants
Online coaching penetration: ~12% = ~2 crore paid users
Average annual fee: โน8,000 (mix of โน2K basic to โน50K premium)
Online revenue = 2Cr ร โน8,000 = โน16,000 Crore
Offline coaching: ~5 crore students ร โน15,000 avg fee
= โน75,000 Crore
Total Ed-tech + Offline โ โน91,000 Crore โ ~$11 Billion โ
G17: Monthly revenue of a Starbucks store in a Delhi mallโ
Operating hours: 10 AM - 10 PM (12 hours)
Footfall: ~300 customers/day (mall location)
Average ticket size: โน350 (coffee + snack)
Daily revenue: 300 ร 350 = โน1,05,000
Monthly: โน1,05,000 ร 30 = โน31,50,000 โ โน31.5 Lakh/month โ
G18: Estimate the number of CCTV cameras in India.โ
Government/public: ~20 lakh (smart city projects, traffic, railways)
Commercial (malls, offices, banks): ~50 lakh
Residential: ~30 lakh
Total โ 1 crore โ
Global estimates put India at ~15L CCTVs per capita basis โ ~2Cr
G19: How much does India spend on digital advertising per year?โ
Total ad market: ~โน1,00,000 Crore
Digital share: ~45% = โน45,000 Crore โ $5.5 Billion
Breakdown: Google (40%), Facebook/Meta (25%),
Ecommerce ads (15%), Others (20%) โ
G20: Estimate daily UPI transactions in India.โ
UPI users: ~35 crore
Daily active: ~40% = 14 crore
Avg transactions per active user: 2.5/day
Daily transactions = 14Cr ร 2.5 = 35 crore = 350 million
NPCI data: ~400 million daily transactions โ
(Close!)
G21โG30: Quick-Fire Guesstimates (One paragraph each)โ
G21: Number of restaurants in Mumbaiโ
Population 2Cr รท 250 people/restaurant = ~80,000 restaurants
FSSAI data: ~75,000 licensed. Plus unlicensed โ ~1 lakh total. โ
G22: How many laptops does TCS have?โ
TCS employees: ~6 lakh. Each gets 1 laptop + ~10% spare stock.
= 6L ร 1.1 = 6.6 lakh laptops โ
G23: Annual electricity consumption of all Indian data centersโ
~140 data centers ร avg 10 MW each = 1,400 MW
ร 8,760 hours/year = 12,264 GWh โ 12 TWh
India total consumption ~1,500 TWh โ DCs are ~0.8% โ
G24: How many auto-rickshaws in Delhi?โ
Registered: ~1 lakh (transport dept data)
Include e-rickshaws: ~1 lakh
Total motorized three-wheelers โ 2 lakh โ
G25: Daily revenue of IRCTC (train ticket bookings)โ
Tickets/day: ~25 lakh, Avg ticket: โน400
= 25L ร 400 = โน100 Crore/day
Service charges: ~โน15/ticket ร 25L = โน3.75 Cr/day
IRCTC commission โ โน3-4 Crore/day revenue โ
G26: Number of Excel users in Indiaโ
Office workers: ~8 crore. Excel usage: ~60% = 4.8 crore
Students learning: ~1 crore. Total โ 5.8 crore โ
G27: How much data does YouTube India consume daily?โ
YT India users: 45 crore, DAU: 50% = 22.5 crore
Avg watch time: 40 min/day at 480p (avg quality)
Data rate: ~3 MB/min โ 120 MB/user/day
Total: 22.5Cr ร 120 MB = 2,700 crore MB = 27 Petabytes/day โ
G28: Monthly rent of a 1000 sq ft office in Cyber City, Gurugramโ
Rate: โน80-120/sqft/month for Grade A
1000 sqft ร โน100 = โน1,00,000/month โ
G29: Number of grocery stores (kirana shops) in Indiaโ
1 kirana per 100-150 people. Population 140Cr.
= 140Cr / 125 = 1.12 Crore
Actual: ~1.2 Crore kirana stores (various surveys) โ
G30: Estimate yearly revenue of Indian Premier League (IPL)โ
Broadcasting rights: ~โน24,000 Cr (5-year deal / 5 = โน4,800 Cr)
Sponsorships: ~โน3,000 Cr
Tickets: 10 teams ร 7 home games ร 40,000 seats ร โน1,500 avg
= โน420 Cr
Merchandise: ~โน500 Cr
Total โ โน8,720 Crore โ ~$1 Billion/year โ