Invesco Business Analyst Interview Questions and Answers

Using bitwise operator to check the last bit of the number.

• Use bitwise AND operator with 1 to check the last bit of the number.

• If the result is 0, the number is even. If the result is 1, the number is odd.

• Example: 6 & 1 = 0 (even), 7 & 1 = 1 (odd)

Implement a dynamic 2D excel sheet using DS

• Use a 2D array to store the data

• Implement functions to add, delete, and modify data

• Use data structures like linked lists or hash tables for efficient searching and sorting

• Implement dynamic resizing to handle large amounts of data

• Use GUI libraries like Tkinter or PyQt for user interface

Joining tables in DBMS evolved as a solution to handle complex data relationships.

• Joins allow combining data from multiple tables based on a common column.

• The concept of joins originated from the need to handle complex data relationships.

• Joins can be inner, outer, left, right, or cross depending on the type of data required.

• Joins can improve query performance by reducing the number of queries needed to retrieve data.

• Jo...read more

Morgan Stanley is a top-tier investment bank with a strong reputation for innovation and excellence.

• Morgan Stanley has a long history of success in the financial industry

• The company is known for its innovative approach to investment banking

• Morgan Stanley has a strong reputation for excellence in research and analysis

• The firm offers a wide range of services to clients, including wealth management and investment banking

• M...read more

Tower and Morgan Stanley are both financial services companies.

• Tower is a global investment management firm with over $1 trillion in assets under management.

• Morgan Stanley is a multinational investment bank and financial services company.

• Both companies offer a range of financial services including wealth management, investment banking, and asset management.

• Tower is known for its focus on sustainable investing, while Mo...read more

The job profile offered is for an analyst position. A PhD is not required for this role.

• The job involves analyzing data and providing insights to clients

• A PhD is not necessary as the role focuses more on practical application of analytical skills

• The job may require a bachelor's or master's degree in a related field

• Examples of job responsibilities may include data collection, statistical analysis, and report writing

Innovations to minimize cost of pen

• Use recycled materials for pen body and ink

• Simplify design to reduce production costs

• Implement refillable ink cartridges to reduce waste and cost

• Partner with companies for bulk purchasing of materials

• Automate production process to reduce labor costs

Prove N>=N^.5+N^(1/3)+N^(1/4) for N>=a

• Use AM-GM inequality

• Substitute N with a and prove the inequality holds

• Use calculus to find the minimum value of the expression

Finding the probability distribution for the minimum of two random variables with given distributions.

• Use the formula P(min(x,y)>z) = P(x>z)P(y>z)

• Integrate over the range of z to get the distribution of min(x,y)

• Final distribution is 2ke^(-kx)ue^(-ux)exp(-uz)

Given prob. p of dying out and prob. (1-p) of spawning into 2, find prob. of dying out starting from 1 organism.

• Use probability tree to visualize outcomes

• Probability of dying out starting from 1 is p + (1-p) * (probability of dying out starting from 2)^2

• Solve recursively to get final answer

Probability of a rectangle being inside a unit circle with p chosen uniformly on the circle and q inside the circle.

• The probability can be found by calculating the ratio of the area of the rectangle to the area of the circle.

• The area of the circle is pi and the area of the rectangle can be found using the distance between p and q.

• The probability is 1/4.

• Example: If the distance between p and q is 0.5, then the area of t...read more

Find local minima of an array in o(log n) in functional programming.

• Use binary search to find the local minima.

• Check if the mid element is a local minima, if not, move towards the lower side.

• If the mid element is greater than its left element, move towards the left side, else move towards the right side.

• Repeat until a local minima is found.

• Example: [5, 3, 2, 4, 6, 8, 9] -> local minima is 2.

Code to sort a list without pipes

• Use a sorting algorithm like bubble sort, insertion sort, or selection sort

• Implement the algorithm in the programming language of your choice

• Test the code with different input sizes and types

To find an even length palindrome in a string in O(n), we can use the two-pointer approach.

• Initialize two pointers at the center of the string.

• Expand the pointers outwards while checking if the characters at both pointers are equal.

• If they are not equal, return the previous substring as the even length palindrome.

• If the pointers reach the end of the string, return the entire string as the even length palindrome.

Possible values of determinant of matrix A given Avi=Vj for n linear vectors

• The possible values of |A| are non-zero as the given vectors are linearly independent

• The value of |A| can be calculated using the formula |A| = (-1)^n * det(A)

• If the given vectors are orthogonal, then |A| is the product of the magnitudes of the vectors

A and B play a game with unfair coin. A wins if # of heads > #tails +1 at any point. Find prob. of A winning.

• The game is played with an unfair coin with P[Heads]=p

• A wins if # of heads > #tails +1 at any point

• Find the probability of A winning

Find two elements in a sorted array that add up to a given sum in linear time.

• Use two pointers, one at the beginning and one at the end of the array.

• If the sum of the two pointers is greater than the target, move the right pointer to the left.

• If the sum of the two pointers is less than the target, move the left pointer to the right.

• Repeat until the sum is found or the pointers meet.

• Example: Given [1, 2, 3, 4, 5] and ta

The probability of element at 20th position landing up at 31st position after the first iteration.

• The probability depends on the size of the dataset and the algorithm used for iteration.

• If the algorithm involves swapping adjacent elements, the probability is higher.

• If the dataset is sorted in a way that the element at 20th position is adjacent to the element at 31st position, the probability is 1.

• The probability can be...read more

Expected number of collisions between randomly moving ants on a rod after 30 seconds.

• Calculate the probability of two ants colliding at any given time.

• Use the formula for expected value to find the expected number of collisions.

• Assume that the ants are point masses and collisions are perfectly elastic.

• Consider the possibility of multiple ants colliding at the same time.

• Simulation can also be used to estimate the expect

Counting permutations where numbers between u and i+1 are less than i for all i in the permutation.

• The first number in the permutation must be 1.

• For each i in the permutation, all numbers between u and i+1 must be less than i.

• Use dynamic programming to count the number of valid permutations.

• The answer is (n-1)th Catalan number.

• Example: for n=4, the answer is 5.

Finding f(n) for a normal standard distribution with a given constant k.

• Calculate the product of probability density function and cumulative distribution function.

• Integrate the product of f(x) and F(kx) from -inf to +inf.

• The value of k is a constant greater than 0.

Number of inversions in an array in O(nlogn) time.

• Use merge sort algorithm to count inversions

• Divide the array into two halves and recursively count inversions

• Merge the two halves and count split inversions

• Time complexity is O(nlogn)

The Convex Hull is the smallest convex polygon that encloses all given points.

• Sort the points based on their x-coordinate.

• Find the upper hull by starting from the leftmost point and moving clockwise.

• Find the lower hull by starting from the rightmost point and moving counterclockwise.

• Combine the upper and lower hulls to form the convex hull.

The strategy is to always subtract the number chosen by the friend from 4 to ensure reaching 16 first.

• Start with 20 and subtract the number chosen by the friend from 4.

• Continue this strategy until reaching 16 before the friend reaches 17-19.

• Ensure the friend ends up at any number between 17 to 19 before reaching 16.

The problem involves finding an element in a matrix that is sorted both row-wise and column-wise.

• Start from the top-right corner of the matrix

• Compare the target element with the current element

• If the target is smaller, move left; if larger, move down

• Repeat until the target is found or the matrix boundaries are crossed