How to Analyse CAT Mock Test: Free Mock Analysis Excel Sheet

CAT Mock Test Analysis Guide

Taking a CAT mock test is only half the job. The real improvement happens when you sit down after the mock and understand exactly what went right, what went wrong and where you lost marks.

A 2-hour mock should not end with checking your percentile and moving on to the next test. Every question contains information about your preparation, question selection, time management and decision-making.

A good mock analysis should answer three simple questions: What did I do well? What mistakes did I make? What should I change in my next mock?

The objective is not to feel good or bad about your score. The objective is to extract useful information from the mock and convert it into action.

CAT Mock Analysis Process

Do not start your analysis by immediately checking the solutions. First, try to reconstruct your own thought process.

For every question, identify what happened: Did you solve it correctly? Did you make a silly mistake? Did you spend too much time? Did you leave an easy question? Or did you correctly decide that the question was not worth attempting?

Step 1: Record your basic performance

Before looking at solutions, note down your score, attempts, correct answers, incorrect answers and time spent in each section.

This gives you a baseline. Don't worry if the numbers are not impressive initially. The purpose of maintaining this table is to identify the trend across multiple mocks.

Step 2: Analyse every question

Now classify every question in the following categories:

This classification is much more useful than simply looking at the answer key.

Step 3: Analyse the questions you did not attempt

This is where many aspirants miss valuable information.Go through the unattempted questions and ask: Could I have solved this question?

If the answer is yes, mark it separately. These questions represent potential marks that you are currently leaving on the table.

Analyse Your CAT Mock Section-Wise: VARC, DILR and Quant

Each CAT section requires a slightly different analysis strategy. VARC is heavily dependent on reading and option elimination, DILR is about set selection and structured reasoning, while Quant requires concept clarity, calculation and question selection. Therefore, simply looking at the overall score is not enough.

VARC Mock Analysis

In VARC, don't only analyse why an answer was wrong. Analyse why you selected that option. For Reading Comprehension, check whether you misunderstood the passage, missed the author's viewpoint, fell for an extreme option or simply rushed through the question.

A useful habit is to write down the reason for every wrong RC question in one sentence. For example: “I selected B because it sounded reasonable, but the passage actually supported C.” That one sentence can reveal a recurring option-selection problem.

Also Read: CAT VARC PYQ Analysis 2026, Difficulty, Repeated Topics

DILR Mock Analysis

DILR analysis should focus heavily on DILR set selection. You may know how to solve a difficult set, but if you spend 20 minutes on it while another set could have been solved in 10 minutes, the problem is not your calculation ability. It is your selection strategy.

For every DILR set, record three things: Time taken → Number of questions solved → Accuracy. For example:

Over multiple mocks, this table can reveal your preferred set types and your recurring selection mistakes.

Also Read: CAT DILR PYQ Analysis 2026, Difficulty, Repeated Topics

Quant Mock Analysis

Quant analysis should go beyond identifying the chapter. Suppose you got three Arithmetic questions wrong. That does not automatically mean your entire Arithmetic preparation is weak. Find out why each question went wrong.

Also maintain a topic-wise performance table.

Don't automatically spend the next week studying your weakest chapter. First check whether the problem is conceptual weakness, poor selection or lack of practice.

Also Read: CAT Quants PYQ Analysis 2026, Difficulty, Repeated Topics

How to Identify and Categorise Mistakes in CAT Mocks

One of the biggest mistakes aspirants make is putting every wrong answer into one bucket called “silly mistake.” That doesn't help. A calculation mistake, a conceptual gap and a bad question-selection decision are three completely different problems and require three different solutions.

Use a mistake log after every mock.

How to Use Mock Analysis to Improve Your CAT Score

Mock analysis should eventually change your preparation. If you keep making the same mistake in five consecutive mocks, simply taking more mocks will not solve the problem.

The correct cycle is: Mock → Analyse → Identify Problem → Practise → Reattempt → Take Next Mock

Also Read: How CAT Mocks Help in Scoring 99+ Percentile in CAT 2026?

Don't measure improvement only through score

Your mock score may fluctuate. Instead, track several metrics over time.

This tells you whether your preparation is actually improving. For example, moving from 60% to 80% accuracy is a meaningful improvement even if your total score has not changed dramatically because of a difficult mock.

Also Read: CAT Mock Journey of DashCAT Toppers: From 30s to 100+

Build a Personal Mock Analysis Sheet

Maintain one spreadsheet or notebook or download the provided excel sheet above throughout your preparation. For every mock, record: Mock number, Date, Overall score, VARC score, DILR score, Quant score, Attempts, Accuracy, Easy questions missed, Major mistakes, Topics requiring revision and Main strategy change for next mock

After five to ten mocks, patterns become much easier to identify.

You may discover that:

• You consistently spend too much time on the first DILR set.
• You attempt too many doubtful VARC questions.
• You leave easy Quant questions because of difficult questions earlier.
• Your accuracy drops significantly in the final part of a section.
• You repeatedly make the same calculation error.

These patterns are far more valuable than a single mock percentile.

What to Do Before Attempting Your Next CAT Mock

Do not take your next mock immediately just because you finished analysing the previous one. First, fix the most important problems identified in your analysis. If you made ten mistakes in a mock, you do not necessarily need to fix all ten before the next test. Identify the two or three mistakes that are costing you the most marks.

CAT Mock Analysis Checklist

Before considering your mock analysis complete, ask yourself these questions:

If you can answer yes to these questions, you have extracted much more value from the mock than simply checking your percentile.

Also Read: How to Improve CAT 2026 Mock Score? Next 30 Days Plan PDF

CAT Mock Test Analysis: Conclusion

A CAT mock is not a judgement of your preparation. It is a diagnostic tool. A low score can still be extremely useful if the analysis tells you exactly where the marks were lost. Similarly, a high score is not enough if you don't understand why you scored well or if the same mistakes continue to appear. The goal should be to make every mock teach you something. Don't ask only, “What did I score?” Ask: “Where did I lose marks?”, “Which of those marks were avoidable?”, “What mistake caused them?” and “What will I change before my next mock?”

That is how mock tests gradually become one of the strongest tools in CAT preparation.

Taking a CAT mock is only the first step. The real value comes from looking at your attempts, accuracy, time spent, mistakes, and the questions you left unattempted. A proper review helps you understand what went well, what needs attention, and what you should change before your next mock.