Collegepond Interview Questions and Answers for Freshers

Q1. How to run linear regression model in R
Ans. 
To run a linear regression model in R, use the lm() function with the formula specifying the relationship between variables.
• Use the lm() function to fit a linear regression model, specifying the formula with the dependent and independent variables.

• For example, to predict sales based on advertising spend, use lm(sales ~ advertising, data = dataset).

• Use summary() to view the results of the linear regression model, includ...read more
Answered by AI
Add your answer
Q2. How to run linear regression model without intercept in R
Ans. 
To run linear regression model without intercept in R, set the intercept parameter to 0
• Set the intercept parameter to 0 in the lm() function in R

• Example: lm(y ~ x - 1, data = dataset) will fit a linear regression model without intercept
Answered by AI
Add your answer

Q1. Securitisation and how it works.
Ans. 
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based...read more
Answered by AI
View 1 more answer
Q2. Financial Ratios and how they work and what is a good number to have.
Ans. 
Financial ratios are tools used to evaluate a company's financial performance and health.
• Financial ratios are calculated using data from a company's financial statements.

• They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.

• A good number for a financial ratio can vary depending on the industry and company size.

• For example, a current ratio of 2 or higher is generally cons...read more
Answered by AI
Add your answer
Q3. Random number crunching based on some scenario that needs you to make assumptions and get an answer
Add your answer
Q4. How an Excel function works. (Vlookup, Hlookup, Xlookup, IF/AND/OR)
Ans. 
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
• Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup: Similar to Vlookup but searches for a value in the first row of a table.

• Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.

• IF: Retu...read more
Answered by AI
Add your answer

Q1. Personal Questions.
Add your answer
Q2. My expertise and proficiency of excel
Add your answer

Q1. No questions. Was confirmed my job
Add your answer

Q1. Probability and statistics, game theory based brain teasers
Add your answer
Q2. Two rounds phone call, then final round
Add your answer

Q1. What is polymorphism
Ans. 
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: Animal class with methods eat() and sleep(). Dog and Cat classes can inherit from Animal and override
Answered by AI
Add your answer
Q2. A method acting as multiple methods is known as polymorphism of 2 types compile time polymorphism and run time polymorphism
Ans. 
Polymorphism in programming refers to the ability of a method to behave differently based on the object it is acting upon.
• Compile time polymorphism is achieved through method overloading, where multiple methods have the same name but different parameters.

• Run time polymorphism is achieved through method overriding, where a subclass provides a specific implementation of a method that is already defined in its superclass.

• ...read more
Answered by AI
Add your answer

Webpage desgin and copy, startegies, 5 social media copies each for different channels

Q1. Excel 5-6 questions. 4 sheets with some common id.
Add your answer
Q2. Guesstimate of number of tea sold in Delhi
Ans. 
Approximately 10 million cups of tea are sold in Delhi daily.
• Consider population of Delhi (approximately 20 million)

• Assume 50% of population consumes tea daily

• On average, a person consumes 2 cups of tea per day

• Total tea sold = 20 million * 0.5 * 2 = 10 million cups
Answered by AI
Add your answer
Q3. Questions of basic Tableau and excel formulas
Add your answer

Q1. Test cased for ATM
Add your answer

Q1. Academic finance related questions
Add your answer
Q2. Question on basic academic finance
Add your answer