CARS24 Senior Data Analyst Interview Questions and Answers

Q1. SQL Basic Questions
Add your answer
Q2. RCA question if consumption metric goes down
Add your answer

Given time series data of provider, compute hour wise provider wise no of seconds online

Q1. Case study on the customer churn.
Add your answer
Q2. Questions on Probability and CLT
Add your answer

Q1. What are assumptions in Linear Regression
Ans. 
Assumptions in Linear Regression
• Linear relationship between independent and dependent variables

• Homoscedasticity (constant variance) of residuals

• Independence of residuals

• Normal distribution of residuals

• No multicollinearity among independent variables
Answered by AI
Add your answer
Q2. What are overfitting and underfitting
Ans. 
Overfitting and underfitting are two common problems in machine learning models.
• Overfitting occurs when a model is too complex and fits the training data too closely, resulting in poor performance on new data.

• Underfitting occurs when a model is too simple and cannot capture the underlying patterns in the data, resulting in poor performance on both training and new data.

• Overfitting can be prevented by using regularizati...read more
Answered by AI
Add your answer
Q3. How do you improve the performance of Linear Regression
Ans. 
To improve the performance of Linear Regression, you can consider feature engineering, regularization, and handling outliers.
• Perform feature engineering to create new features that capture important information.

• Apply regularization techniques like L1 or L2 regularization to prevent overfitting.

• Handle outliers by either removing them or using robust regression techniques.

• Check for multicollinearity among the independent...read more
Answered by AI
View 1 more answer
Q4. What are the metrics used to evaluate Linear Regression
Ans. 
Metrics used to evaluate Linear Regression
• Mean Squared Error (MSE)

• Root Mean Squared Error (RMSE)

• R-squared (R²)

• Adjusted R-squared (Adj R²)

• Mean Absolute Error (MAE)

• Residual Sum of Squares (RSS)

• Akaike Information Criterion (AIC)

• Bayesian Information Criterion (BIC)
Answered by AI
Add your answer
Q5. What is Cost function and Error Function
Ans. 
Cost function measures the difference between predicted and actual values. Error function measures the average of cost function.
• Cost function is used to evaluate the performance of a machine learning model.

• It measures the difference between predicted and actual values.

• Error function is the average of cost function over the entire dataset.

• It is used to optimize the parameters of the model.

• Examples of cost functions are ...read more
Answered by AI
Add your answer
Q6. How do you handle Overfitting in Linear Regression
Ans. 
Overfitting in Linear Regression can be handled by using regularization techniques.
• Regularization techniques like Ridge regression and Lasso regression can help in reducing overfitting.

• Cross-validation can be used to find the optimal regularization parameter.

• Feature selection and dimensionality reduction techniques can also help in reducing overfitting.

• Collecting more data can help in reducing overfitting by providing
Answered by AI
View 1 more answer
Q7. What is the difference between Least Squares Method and the maximum likelihood
Ans. 
Least Squares Method and Maximum Likelihood are both used to estimate parameters, but differ in their approach.
• Least Squares Method minimizes the sum of squared errors between the observed and predicted values.

• Maximum Likelihood estimates the parameters that maximize the likelihood of observing the given data.

• Least Squares Method assumes that the errors are normally distributed and independent.

• Maximum Likelihood does n...read more
Answered by AI
Add your answer
Q8. What is the formula of Logistic Regression
Ans. 
Logistic Regression formula is used to model the probability of a certain event occurring.
• The formula is: P(Y=1) = e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn) / (1 + e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn))

• Y is the dependent variable and X1, X2, ..., Xn are the independent variables

• b0, b1, b2, ..., bn are the coefficients that need to be estimated

• The formula is used to predict the probability of a binary outcome, such as whether...read more
Answered by AI
Add your answer
Q9. What is Type I and Type II error
Ans. 
Type I error is rejecting a true null hypothesis, while Type II error is failing to reject a false null hypothesis.
• Type I error is also known as a false positive

• Type II error is also known as a false negative

• Type I error occurs when the significance level is set too high

• Type II error occurs when the significance level is set too low

• Examples: Type I error - Convicting an innocent person, Type II error - Failing to convi...read more
Answered by AI
Add your answer
Q10. What metrics do you use to evaluate classification models
Ans. 
Metrics used to evaluate classification models
• Accuracy

• Precision

• Recall

• F1 Score

• ROC Curve

• Confusion Matrix
Answered by AI
Add your answer
Q11. How do you handle overfitting and underfitting in Decision Trees
Ans. 
Overfitting in decision trees can be handled by pruning, reducing tree depth, increasing dataset size, and using ensemble methods.
• Prune the tree to remove unnecessary branches

• Reduce tree depth to prevent overfitting

• Increase dataset size to improve model generalization

• Use ensemble methods like Random Forest to reduce overfitting

• Underfitting can be handled by increasing tree depth, adding more features, and reducing regu...read more
Answered by AI
Add your answer

Case Study - How do you improve user engagement of Facebook?
Guesstimates - How many people watched the Squid Game series on Netflix

How do you reduce partner churn in UC?

Sql based questions on hackerrank.

Q1. Why Swiggy? Where do you see yourself in 5 years?
Add your answer

Questions from arrays and strings and some aptitude questions

Q1. How to merge 2 csv files
Ans. 
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
• Open both CSV files in a software like Microsoft Excel.

• Copy the data from one CSV file and paste it into the other CSV file.

• Save the merged CSV file with a new name.

• Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
Answered by AI
Add your answer
Q2. Basic questions on arrays
Add your answer

Q1. 3 reasons why u choose this company
Ans. 
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
• Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

• Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

• Company culture - I value a positive work environment and the...read more
Answered by AI
Add your answer

Q1. Questions on python
Add your answer

Q1. Tell me about your projects?
Add your answer
Q2. How do you approach the project if you are using logistic regression model?
Ans. 
Approach involves data preprocessing, model training, evaluation, and interpretation.
• Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

• Split the data into training and testing sets.

• Train the logistic regression model on the training data.

• Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

• Interpret the model coefficients to under...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
Q2. What would you do if your interested field doesnt have any work in the company?
Ans. 
I would seek opportunities to apply my skills in related fields within the company.
• Explore other departments or teams within the company that may have projects related to my field of interest

• Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

• Seek out professional development opportunities to expand my skills and knowledge in related areas
Answered by AI
Add your answer

Q1. Basic Excel Questions
Add your answer
Q2. Medium and Basic SQL Questions
Add your answer
Q3. Resume based Question
Add your answer
Q4. Case Study Questions
Add your answer
Q5. Questions on Project
Add your answer

SQL based questions wer asked on joins , rank function,