EXL Service
20+ Ameriprise Financial Interview Questions and Answers
Q1. Puzzle: There are three ants, each at a corner of an equilateral triangle. Each of them can move along any of the two sides independent of the other two ants. What is the probability that none of the ants colli...
read moreThree ants on an equilateral triangle can move along any two sides. What is the probability of no collision?
Each ant has two possible directions to move
The probability of collision is 1/3
The probability of no collision is 8/27
Q2. Puzzle : Consider the top face of a rubik's cube. An insect is sitting on the middle block. It can only crawl sideways not diagonally i.e for every step it has 4 options. What is the probability that it will co...
read moreCalculate probability of an insect on a Rubik's cube returning to center block after 2 moves and falling on side face on 3rd move.
The insect has 4 options for each move
To return to center block, it must move in opposite direction of its first move
Probability of returning to center block after 2 moves is 0.125
Probability of falling on side face on 3rd move is 0.5
Q3. Puzzle 1 : 2 trains start from respective stations towards each other at the same time say from Delhi & Jaipur. A bird starts with the train from delhi towards the other train & reverses its direction as soon a...
read moreThe bird travels the same distance as the sum of the distances covered by both trains.
The bird starts with one train and reverses its direction when it reaches the other train.
This process continues until the two trains collide.
The distance traveled by the bird is equal to the sum of the distances covered by both trains.
Q4. Tell the smallest number which when divided by 2 gives a remainder 1, when divided by 3 gives a remainder 2, when divided by 4 gives 3 & so on till when divided by 9 gives the remainder 8.
Smallest number with remainders when divided by 2 to 9.
Find the LCM of 2 to 9.
Add 1 to the LCM until it satisfies the given remainders.
The final number is the smallest number that satisfies all the remainders.
Q5. You are a bank owner & you need to design a new credit system. What factors will you consider before judging whether a customer should be given a loan or not
Factors to consider before giving a loan to a customer as a bank owner
Credit score and history
Income and employment status
Debt-to-income ratio
Collateral or assets
Purpose of the loan
Repayment ability
Credit utilization ratio
Legal and regulatory requirements
Q6. Puzzle 2 : There are 25 horses & 1 racing course with 5 lanes. We don't have a stopwatch or anything to note the time. Tell the minimum number of races required to get the fastest 3 horses of the lot.
25 horses, 5 lanes, no stopwatch. Find fastest 3 horses. Minimum races required?
Divide horses into 5 groups of 5 each
Race each group, identify fastest horse from each group
Race the 5 fastest horses, identify the fastest horse
Repeat the process with the remaining 20 horses
Total races required = 7
Q7. Puzzle: There are three jars, one of them is filled with oranges, another with apples and the third one with both apples and oranges. But all the three jars have been labeled wrong. Now you have an option to pi...
read morePick a fruit from the jar with both apples and oranges. Then deduce the contents of each jar based on the fruit you picked.
Pick a fruit from the jar labeled 'apples and oranges'
If you picked an apple, then the jar labeled 'apples' actually contains oranges and the jar labeled 'oranges' actually contains apples
If you picked an orange, then the jar labeled 'oranges' actually contains apples and the jar labeled 'apples' actually contains oranges
Q8. What is the role of Visa or mastercard or AmEx on your credit cards
Visa, Mastercard, and AmEx are payment networks that process transactions made with credit cards.
Visa, Mastercard, and AmEx are payment networks that facilitate transactions between merchants, banks, and cardholders.
They provide the infrastructure for credit card transactions to occur, including authorization, clearing, and settlement.
Visa and Mastercard are accepted at most merchants worldwide, while AmEx is more exclusive and typically accepted at higher-end establishments....read more
Q9. Why there are only 30 rows in airplane? What if number of rows are changed, how will it affect our profits?
The number of rows in an airplane affects profits.
The number of rows determines the seating capacity of the airplane.
More rows can lead to higher profits if the demand for tickets is high.
Fewer rows can lead to lower profits if the demand for tickets is low.
The number of rows also affects the weight and fuel consumption of the airplane.
Changing the number of rows may require adjustments in pricing and seating arrangements.
Q10. Tell some places/fields around you where you think analytics is been used
Analytics is used in various fields around me
Marketing and advertising
Finance and banking
Healthcare and medicine
Sports and fitness
Transportation and logistics
Q11. How many lines can be constructed using 5 non collinear points and 3 collinear points?
The number of lines that can be constructed using 5 non-collinear points and 3 collinear points.
The 3 collinear points will form 3 lines.
Each of the 5 non-collinear points can be connected to the other 4 points to form 20 lines.
However, any line passing through one of the collinear points will be redundant.
Therefore, the total number of lines that can be constructed is 20 - 3 = 17.
Q12. How would you estimate the distance between Delhi and Beijing?
The distance between Delhi and Beijing can be estimated using various methods.
One can use the Haversine formula to calculate the distance based on the latitude and longitude of the two cities.
Another method is to use online distance calculators that take into account the flight distance and driving distance.
The distance can also be estimated by looking at the approximate time it takes to travel between the two cities by air or road.
Factors such as the mode of transportation, ...read more
Q13. By how much precent flipkart should increase its inventory of mobile phones during Diwali season?
The percentage increase in inventory of mobile phones for Flipkart during Diwali season depends on various factors such as demand, competition, and sales data.
Flipkart should analyze the demand for mobile phones during Diwali season based on previous year's sales data.
They should also consider the competition and the inventory levels of their competitors.
Based on these factors, they can decide on the percentage increase in inventory of mobile phones.
For example, if the demand...read more
Q14. Estimate the no. of Rs. 1000 notes in India before demonetization
Estimating the number of Rs. 1000 notes in India before demonetization.
The total currency in circulation before demonetization was around Rs. 17.77 lakh crore.
Rs. 1000 notes constituted around 39% of the total currency in circulation.
Therefore, the estimated number of Rs. 1000 notes in India before demonetization was around 6.92 billion.
However, this is just an estimate and the actual number may vary.
Q15. What is calculated fields (in microsoft excel)
Calculated fields in Microsoft Excel are formulas created by users to perform calculations on data in a table.
Calculated fields are created using formulas
They can perform calculations on data in a table
Examples include summing up columns or calculating averages
Calculated fields are dynamic and update automatically when the data changes
Q16. Estimate the no. of people participated in Delhi Marathon
The estimated number of people who participated in the Delhi Marathon is...
The number of registered participants can be used as a starting point
Factors such as weather conditions, location, and popularity of the event can affect the turnout
Previous years' participation numbers can also be used as a reference
Media coverage and social media activity can provide insights into the event's popularity
An official statement from the organizers can provide an accurate count
Q17. What is VLOOKUP & where you use it
VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.
VLOOKUP stands for Vertical Lookup
It is used to find a specific value in a table and return a corresponding value from the same row
It requires a lookup value, table array, column index number, and range lookup
Example: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
It is commonly used in financial analysis, data management, and reporting
Q18. How does a credit card work
A credit card allows you to borrow money from a bank or financial institution to make purchases.
Credit card issuer gives you a line of credit based on your creditworthiness
You can use the card to make purchases up to your credit limit
You have to pay back the borrowed amount with interest
If you don't pay the full amount, interest is charged on the remaining balance
Late payments or exceeding credit limit can result in fees and damage to credit score
Q19. How many 0's in 100!?
The number of zeros in 100! can be determined by counting the number of factors of 10.
Count the number of factors of 10 in the prime factorization of 100!
Each factor of 10 is made up of 2 and 5, so count the number of 2's and 5's separately
There are more factors of 2 than 5, so count the number of factors of 5
There are 24 factors of 5 in 100!, so there are 24 zeros at the end
Q20. Some functions in R
R is a programming language commonly used for statistical computing and graphics.
R has a wide range of built-in functions for data manipulation, statistical analysis, and visualization.
Some commonly used functions in R include mean(), sum(), max(), min(), sd(), var(), and plot().
R also allows users to create their own functions using the function() keyword.
Functions in R can take arguments and return values.
R functions can be called using the function name followed by parenth...read more
Top HR Questions asked in Ameriprise Financial
Reviews
Interviews
Salaries
Users/Month