TGViewer
Data Analytics Data Analytics @sqlspecialist ยท 111K subscribers
Post #2866 2.51K
๐Ÿš€ Data Analytics Interview Questions & Answers โ€“ Statistics Part 6 ๐Ÿ“Š๐Ÿ”ฅ

146. Mean vs Median vs Mode

Mean Average of all values.

Example: Data = 10, 20, 30 Mean = 20

Median Middle value after sorting data.

Example: 10, 20, 30, 40, 50 Median = 30

Mode Most frequently occurring value.

Example: 10, 20, 20, 30 Mode = 20

147. What is Standard Deviation

Answer: Standard deviation measures how spread out data is from the mean.

Low Standard Deviation = Data points close to mean

High Standard Deviation = Data points spread out

Example: Sales 100, 102, 101, 99 Low variation.

148. Explain Variance

Answer: Variance measures the average squared distance from the mean.

Relationship: Standard Deviation = โˆšVariance

149. What is Probability

Answer: Probability measures the likelihood of an event occurring.

Range: 0 Impossible, 1 Certain

Example: Coin toss P(Head) = 0.5

150. What is Correlation

Answer: Correlation measures the strength and direction of relationship between two variables.

Range: -1 to +1

Value Meaning: +1 Perfect Positive, 0 No Relationship, -1 Perfect Negative

Example: Experience โ†‘ Salary โ†‘ Positive correlation.

151. Difference Between Correlation and Causation

Correlation Two variables move together.

Example: Ice Cream Sales โ†‘ Swimming Accidents โ†‘

Causation One variable directly causes another.

Example: Ad Spend โ†‘ Sales โ†‘

Important Interview Point: Correlation does NOT imply causation.

152. What is Hypothesis Testing

Answer: A statistical method used to determine whether a claim is supported by data.

Steps: 1. Define hypothesis 2. Collect data 3. Calculate test statistic 4. Compare p-value 5. Draw conclusion

153. Explain p-value

Answer: The p-value measures the probability that observed results happened by chance.

Common Rule: p < 0.05 Result is statistically significant.

Example: p = 0.02 Reject the null hypothesis.

154. What is Confidence Interval

Answer: A range of values likely to contain the true population parameter.

Example: Average Salary โ‚น50,000 ยฑ โ‚น2,000

95% Confidence Interval: โ‚น48,000 to โ‚น52,000

155. What is Regression

Answer: Regression predicts the relationship between variables.

Example: Ad Spend Sales

Used for: Forecasting, Trend Analysis, Prediction

Simple Linear Regression

156. What is A/B Testing

Answer: A/B Testing compares two versions to determine which performs better.

Example: Version A Blue Button, Version B Green Button

Measure: Click Rate, Conversion Rate, Revenue

157. Explain Normal Distribution

Answer: A bell-shaped distribution where most observations cluster around the mean.

Characteristics: Symmetrical, Mean = Median = Mode, Bell Curve Shape

Examples: Heights, Exam Scores, IQ Scores

158. What are Outliers

Answer: Outliers are observations significantly different from other values.

Example: 10, 12, 11, 9, 500 500 is an outlier.

Detection Methods: Box Plot, IQR, Z-Score

159. What is Sampling

Answer: Sampling means selecting a subset of data from a larger population.
  • โค 1
More from @sqlspecialist
  1. Oct 8, 2026๐ŸŽ“ ๐— ๐—ถ๐—ฐ๐—ฟ๐—ผ๐˜€๐—ผ๐—ณ๐˜ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ฒ๐˜€! ๐Ÿš€๐Ÿ”ฅ Upgrโ€ฆ
  2. Oct 7, 2026๐Ÿ“Š Kandinsky 6.0 Video: AI-Powered Content Creation for Analysts The new Kandinsky 6.0 Vidโ€ฆ
  3. Oct 7, 2026Alternatively, depending on the Excel version and requirement, I could use functions suchโ€ฆ
  4. Oct 7, 2026๐Ÿ“Š Data Analyst Interview Series โ€” Part 5 Guys, let's continue our Data Analyst Interviewโ€ฆ
  5. Oct 7, 2026๐Ÿš€๐—ฃ๐—ฎ๐˜† ๐—”๐—ณ๐˜๐—ฒ๐—ฟ ๐—ฃ๐—น๐—ฎ๐—ฐ๐—ฒ๐—บ๐—ฒ๐—ป๐˜ ๐—ง๐—ฟ๐—ฎ๐—ถ๐—ป๐—ถ๐—ป๐—ด | ๐—•๐—ฒ๐—ฐ๐—ผ๐—บ๐—ฒ ๐—ฎ ๐—™๐˜‚๐—น๐—น๐˜€๐˜๐—ฎ๐—ฐโ€ฆ
  6. Oct 7, 2026๐Ÿ”Ÿ What is the difference between UNION and JOIN? Sample Answer: "JOIN combines columns frโ€ฆ
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 โ†’