Find Interview Questions for Amex

Right Answer:

Probability plays a key role in data interpretation by helping us measure uncertainty and make predictions based on data. Instead of relying on guesses, probability gives us a way to express how likely an event is to happen — using numbers between 0 and 1 (or 0% to 100%).

In simple terms, probability helps answer questions like:

• How confident are we in our results?

• What are the chances this happened by random chance?

• Can we trust the trend we’re seeing in the data?

Right Answer:

Data representation is all about showing information in a clear and visual way so it’s easier to understand and analyze. Instead of reading long tables of numbers, we use charts, graphs, and diagrams to quickly spot patterns, trends, and insights.

Different types of data call for different types of visual representation. Choosing the right one can make your data more meaningful and impactful.

—

📊 Common Types of Data Representation:

1. Bar Charts
Bar charts show comparisons between categories using rectangular bars.
Use it when you want to compare values across different groups (e.g., sales by product).

2. Pie Charts
Pie charts show how a whole is divided into parts.
Each slice represents a percentage of the total.
Best for showing proportions or percentages (e.g., market share).

3. Line Graphs
Line graphs show trends over time using connected data points.
Ideal for tracking changes over days, months, or years (e.g., monthly revenue growth).

4. Histograms
Histograms look like bar charts but are used to show the distribution of continuous data.
Great for understanding how data is spread out (e.g., exam scores, age ranges).

5. Scatter Plots
Scatter plots show relationships between two variables using dots.
Useful for spotting correlations or trends (e.g., hours studied vs. test score).

6. Tables
Tables display exact numbers in rows and columns.
Helpful when details matter and you need to show raw values.

7. Box Plots (Box-and-Whisker)
Box plots show the spread and skewness of data, highlighting medians and outliers.
Useful for comparing distributions across groups.

8. Heat Maps
Heat maps use color to show values within a matrix or grid.
Often used in website analytics, performance tracking, or survey responses.

9. Infographics
Infographics combine visuals, icons, and brief text to explain complex data in a simple and engaging way.
Perfect for reports, presentations, or sharing insights with a general audience.

Right Answer:

Percentages and ratios are simple but powerful tools for understanding and comparing data. They help you express relationships between numbers in a way that’s easy to read, compare, and communicate.

Both are commonly used in business reports, surveys, research, and everyday decision-making.

—

🔢 How to Calculate Percentages:

A percentage shows how much one value is out of 100.

👉 Formula:
Percentage = (Part ÷ Total) × 100

📊 Example:
If 40 out of 200 customers gave a 5-star review:
(40 ÷ 200) × 100 = 20%
So, 20% of customers gave top ratings.

✅ Interpreting It:
You can now say, “20% of our customers were highly satisfied.”

—

📏 How to Calculate Ratios:

A ratio compares two quantities directly, showing how many times one value contains or relates to another.

👉 Formula:
Ratio = Value A : Value B

Right Answer:

Interpreting data is a powerful skill, but it’s easy to misread or misrepresent information if you’re not careful. To get accurate insights, it’s important to avoid common mistakes that can lead to incorrect conclusions or poor decisions.

Here are key mistakes to watch out for:

🔹 1. Ignoring the Context
Numbers without context can be misleading. Always ask: What is this data measuring? When and where was it collected?

🔹 2. Confusing Correlation with Causation
Just because two things move together doesn’t mean one caused the other. Correlation does not always equal causation.

🔹 3. Focusing Only on Averages
Relying only on the mean can hide important differences. Consider looking at the median, mode, or range for a fuller picture.

🔹 4. Overlooking Outliers
Extreme values can skew your interpretation. Identify outliers and decide whether they’re meaningful or errors.

🔹 5. Misreading Charts and Graphs
Not checking axes, scales, or labels can lead to misunderstanding. Always read titles and units carefully.

🔹 6. Using Small or Biased Samples
Drawing conclusions from limited or unrepresentative data can be dangerous. Make sure your data is complete and fair.

🔹 7. Cherry-Picking Data
Only focusing on data that supports your view while ignoring the rest can lead to false conclusions. Look at the full dataset.

🔹 8. Ignoring Margin of Error or Uncertainty
Statistical results often come with a margin of error. Don’t treat every number as exact.

Right Answer:

Regression analysis is a statistical method used to understand the relationship between one dependent variable and one or more independent variables. In simpler terms, it helps you see how changes in one thing affect another.

For example, you might use regression to see how advertising budget (independent variable) affects product sales (dependent variable).

Right Answer:
BI stands for Business Intelligence, which involves analyzing data to help make informed business decisions. For OLAP (Online Analytical Processing) reporting, a star schema or snowflake schema is suitable because they optimize query performance and simplify data retrieval.

Steps to create a database:
1. Define the purpose and requirements.
2. Design the schema (tables, relationships).
3. Choose a database management system (DBMS).
4. Create the database and tables using SQL.
5. Populate the database with data.
6. Implement indexing for performance.
7. Test the database for functionality and performance.

Right Answer:
FALSE

Right Answer:
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. The main types of normalization are:

1. **First Normal Form (1NF)**: Ensures that all columns contain atomic values and each entry in a column is of the same type.
2. **Second Normal Form (2NF)**: Achieves 1NF and ensures that all non-key attributes are fully functionally dependent on the primary key.
3. **Third Normal Form (3NF)**: Achieves 2NF and ensures that all non-key attributes are not only dependent on the primary key but also independent of each other.
4. **Boyce-Codd Normal Form (BCNF)**: A stronger version of 3NF that deals with certain types of anomalies not handled by 3NF.
5. **Fourth Normal Form (4NF)**: Achieves BCNF and addresses multi-valued dependencies.
6. **Fifth Normal Form (5NF)**: Achieves 4

Right Answer:
Second Normal Form (2NF) is a database normalization level where a table is in First Normal Form (1NF) and all non-key attributes are fully functionally dependent on the entire primary key, meaning there are no partial dependencies on a composite primary key.

Right Answer:
Denormalization should be considered when you need to improve read performance, reduce the complexity of queries, or when you have specific reporting requirements that benefit from fewer joins in the database.

Right Answer:
In my previous role, I worked with a colleague who seemed stressed during a project meeting. I noticed they were quiet and avoided eye contact. After the meeting, I approached them and asked if they needed help with their workload. They opened up about feeling overwhelmed and needing support. I offered to assist with their tasks, which helped alleviate their stress and improved our collaboration.

Right Answer:
Yes, the Union Budget 2017-18 is considered taxpayer-friendly because it introduced measures like increased tax slabs for individuals, reduced corporate tax rates for small businesses, and a focus on digital transactions, which aimed to simplify the tax structure and promote transparency.

Right Answer:
The son's age five years back was 19 years.

Right Answer:
Equity warrants are financial instruments that give the holder the right, but not the obligation, to buy a company's stock at a specific price within a certain time frame.

- **Call warrants** allow the holder to purchase shares at a predetermined price, benefiting if the stock price rises above that price.
- **Put warrants** give the holder the right to sell shares at a predetermined price, benefiting if the stock price falls below that price.

Right Answer:
The rate of interest is 6%.

Right Answer:
Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time.

**Acceptance Rules:**
1. Accept projects with a positive NPV.
2. Reject projects with a negative NPV.
3. If NPV is zero, the project can be considered indifferent.

**Advantages:**
- Considers the time value of money.
- Provides a clear measure of profitability.
- Helps in comparing different investment opportunities.

**Disadvantages:**
- Requires accurate estimation of future cash flows.
- Sensitive to the discount rate used.
- Can be complex to calculate for large projects.

Right Answer:
**Advantages of Deep Discount:**
1. Attracts price-sensitive customers.
2. Increases sales volume quickly.
3. Helps clear out inventory.
4. Can enhance market share.

**Risks of Deep Discount:**
1. May erode profit margins.
2. Can devalue the brand.
3. Risk of creating a price war with competitors.
4. Potential for customers to expect discounts regularly.

Right Answer:
Under the Companies Act, 1956, shareholders have the right to participate in a rights issue, which allows them to purchase additional shares in the company in proportion to their existing holdings, typically at a discounted price, before the shares are offered to other investors.

Right Answer:
Preference shares are a type of equity security that gives shareholders preferential treatment in terms of dividends and asset distribution. Their features include:

1. Fixed Dividend: Preference shareholders receive a fixed dividend before any dividends are paid to common shareholders.
2. Priority in Liquidation: In the event of liquidation, preference shareholders are paid before common shareholders.
3. Non-voting Rights: Typically, preference shares do not carry voting rights in the company.
4. Cumulative or Non-Cumulative: Some preference shares are cumulative, meaning unpaid dividends accumulate, while others are not.
5. Redeemable or Irredeemable: Preference shares can be redeemable (the company can buy them back) or irredeemable (they cannot be bought back).

Right Answer:
The provisions for buyback of shares as per the Companies Act, 1956 include:

1. A company can buy back its shares only if it is authorized by its articles of association.
2. The buyback must be approved by a special resolution in a general meeting.
3. The buyback should not exceed 25% of the total paid-up capital and free reserves of the company.
4. The buyback must be financed out of the company's free reserves, securities premium account, or proceeds of any shares or other specified securities.
5. The buyback must be completed within 12 months from the date of passing the resolution.
6. The company must maintain a register of shares bought back.
7. The shares bought back must be extinguished and cannot be reissued.