TGViewer
Data Analytics Data Analytics @sqlspecialist · 111K subscribers
Post #2568 6.85K
✅ Data Analyst Interview Questions with Answers: Part-6

51. Difference between mean and median?
Mean is the average. Median is the middle value.
Example: Salaries - 20k, 22k, 25k, 30k, 1,00k
Mean = 39.4k (skewed)
Median = 25k (better representative)

52. What is standard deviation?
It measures how spread out data is from the mean.
Example: Avg sales = ₹10,000
Std dev = ₹500 → stable
Std dev = ₹5,000 → volatile

53. What is variance?
Square of standard deviation. Shows data spread mathematically.

54. What is correlation?
Measures relationship between two variables. Range -1 to +1
Example: Ad spend vs sales = 0.8 → strong positive correlation.

55. Difference between correlation and causation?
Correlation does not mean one causes the other.
Example: Ice cream sales and drowning both increase in summer.

56. What is an outlier?
A value far from others.
Example: Order values - 500, 700, 800, 50,000

57. What is sampling?
Using a subset of data to represent full dataset.
Example: Survey 1,000 customers instead of 1 million.

58. What is distribution?
Pattern showing how data values are spread.
Example: Normal, skewed, uniform distributions.

59. What is skewness?
Measures asymmetry of data.
Example: Income data usually right-skewed.

60. When do you use median over mean?
When data has outliers.
Example: House prices, salaries.

Double Tap ♥️ For Part-7
  • ❤ 28
  • 👍 1
More from @sqlspecialist
  1. Oct 12, 2026🚀 𝗪𝗵𝗶𝗰𝗵 𝗧𝗲𝗰𝗵 𝗦𝗸𝗶𝗹𝗹 𝗪𝗶𝗹𝗹 𝗬𝗼𝘂 𝗠𝗮𝘀𝘁𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟲? Want to buil…
  2. Oct 9, 2026“Here, the data is sorted by the second column in descending order and the first five rows…
  3. Oct 9, 2026📊 Data Analyst Interview Series — Part 6 Guys, let's continue our Data Analyst Interview…
  4. Oct 9, 2026🇮🇳 𝗚𝗢𝗩𝗘𝗥𝗡𝗠𝗘𝗡𝗧 𝗢𝗙 𝗜𝗡𝗗𝗜𝗔 — 𝗔𝗜𝗖𝗧𝗘 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝟮𝟬𝟮𝟲 🚀…
  5. Oct 8, 2026🎓 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘄𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀! 🚀🔥 Upgr…
  6. Oct 7, 2026📊 Kandinsky 6.0 Video: AI-Powered Content Creation for Analysts The new Kandinsky 6.0 Vid…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →