Find Interview Questions for Top Companies
Ques:- What are outliers in data and how do you identify and handle them in data interpretation
Right Answer:

Outliers are data points that are significantly different from the rest of the values in a dataset. They appear unusually high or low compared to the majority and can affect the accuracy of your analysis.

For example, if most students score between 60 and 90 on a test, but one student scores 10, that 10 is likely an outlier.

🔍 How to Identify Outliers:

You can detect outliers using several common methods:

1. Visual methods:
- Box plot: Outliers appear as dots outside the “whiskers” of the box.
- Scatter plot: Outliers stand far away from the main cluster of points.

2. Statistical methods:
- Z-score: Measures how far a data point is from the mean. A score above 3 or below -3 is often considered an outlier.
- IQR (Interquartile Range):
 Outliers fall below Q1 – 1.5×IQR or above Q3 + 1.5×IQR

3. Domain knowledge:
Sometimes, a value may look extreme but is valid based on real-world context. Always consider the background before deciding.

Explanation:

Let’s say you have the following data on daily sales:
45, 48, 50, 47, 49, 100

Here, “100” stands out from the rest and may be an outlier.

✅ How to Handle Outliers:

- Investigate: Is it a typo or a valid value?
- Remove: If it’s an error or not relevant, you can exclude it from analysis.
- Transform: Use techniques like log transformation to reduce its impact.
- Use robust statistics: Median and IQR are less affected by outliers than mean and standard deviation.

Ques:- How do you interpret and compare data across different time periods or categories
Right Answer:

Interpreting and comparing data across different time periods or categories helps you spot patterns, measure progress, and make informed decisions. It allows you to see what has changed, what stayed the same, and what might need attention.

Whether you’re comparing sales by month, customer feedback by product, or website traffic by country — the goal is to understand how performance or behavior differs over time or between groups.

🔍 How to Interpret Data Over Time:

1. Look for Trends
 Is the data increasing, decreasing, or staying flat over time?
 Example: Are your monthly sales growing quarter by quarter?

2. Compare Periods
 Compare the same data from different time frames:
 This year vs. last year, or before vs. after a marketing campaign.

3. Use Averages and Percent Changes
 Instead of just raw numbers, calculate averages, growth rates, and percentage differences for better understanding.

4. Visualize with Charts
 Use line charts, bar graphs, or area charts to clearly show how things have changed over time.

🔍 How to Compare Data by Categories:

1. Group the Data
 Organize your data by categories such as location, department, product, or customer type.

2. Use Side-by-Side Comparisons
 Bar charts, grouped tables, or dashboards make it easier to compare categories at a glance.

3. Look for Outliers or Top Performers
 Which category performed the best? Which underperformed?

4. Ask “Why?”
 After identifying the differences, try to understand the reason behind them.

Explanation:

Let’s say you’re comparing monthly website traffic between January and June:

  • January: 10,000 visits

  • June: 15,000 visits

This shows a 50% increase in traffic over six months — a clear upward trend. Now compare mobile vs. desktop traffic in June:

  • Mobile: 9,000 visits

  • Desktop: 6,000 visits

From this, you can conclude that most users are accessing your site from mobile devices.



AmbitionBox Logo

What makes Takluu valuable for interview preparation?

1 Lakh+
Companies
6 Lakh+
Interview Questions
50K+
Job Profiles
20K+
Users