EXL Service Consultant Interview Questions and Answers

R square measures the proportion of variance explained by the independent variables, while adjusted R square penalizes for adding unnecessary variables.

• R square increases as more variables are added, even if they are not significant

• Adjusted R square increases only if the added variable improves the model more than would be expected by chance

• Adjusted R square is always lower than R square

• Adjusted R square is a bett...read more

Approximately 500 kgs of paneer are used in Bangalore per day.

• Estimate the population of Bangalore

• Assume average consumption of paneer per person per day

• Consider the number of restaurants and households in Bangalore

• Factor in the demand for paneer-based dishes in Bangalore

Automating a report in Excel involves using macros or VBA code to perform repetitive tasks and generate the report automatically.

• Use Excel's built-in macro recorder to record your actions and generate VBA code.

• Write VBA code to manipulate data, format cells, and generate charts or tables.

• Schedule the report to run at specific times using Excel's built-in scheduling tools or external tools like Windows Task Schedul...read more

I identified improvement opportunities in process by analyzing data, observing the process, and gathering feedback from stakeholders.

• Analyze data to identify bottlenecks, inefficiencies, and areas for improvement

• Observe the process to identify areas where steps can be eliminated or streamlined

• Gather feedback from stakeholders to identify pain points and areas for improvement

• Use process mapping and flowcharting to ...read more

Cumulative sum in SQL is the running total of a column's values.

• Use the SUM() function with the OVER() clause to calculate the cumulative sum.

• The ORDER BY clause is used to specify the order of the rows for the cumulative sum calculation.

• Example: SELECT column1, SUM(column2) OVER (ORDER BY column1) AS cum_sum FROM table_name;

The number of 0s in 1 to 1000 is 192.

• There are 1000 numbers from 1 to 1000.

• Every 10 numbers have one 0 in the units place.

• Every 100 numbers have ten 0s in the tens place.

• Every 1000 numbers have one hundred 0s in the hundreds place.

• Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.