Download the excel sheet here:

Enter your Last few Mock scores (Atleast 3 for result and best result add 5 Mock Scores) It will give you the Minimum targets for next 2 Mocks

AI Method used
The moving average method is a commonly used statistical technique in time series analysis and forecasting. It’s used to smooth out fluctuations in data and identify underlying trends by calculating the average of a specific number of consecutive data points. This can help in reducing noise and making patterns more apparent.

Here’s how the moving average method works:

1. Select a Window Size: The first step is to choose a window size, also known as the “period” or “lag.” This determines the number of data points that will be included in each calculation of the moving average. For example, if you choose a window size of 3, you’ll calculate the average of the first three data points, then the average of the next three points, and so on.
2. Calculate the Moving Averages: For each time period, you calculate the average of the data points within the chosen window size. This is done by summing up the values of the data points in the window and then dividing by the window size.
3. Create the Moving Average Series: The calculated moving averages form a new time series dataset, where each value corresponds to the average of the data points in the selected window at that particular time period. This new dataset can then be used for analysis and forecasting.

There are two main types of moving averages:

1. Simple Moving Average (SMA): This is the basic form of the moving average, where the average is calculated by summing up the values of the data points in the window and then dividing by the window size.SMA = (Sum of Data Points in Window) / Window Size
2. Exponential Moving Average (EMA): The EMA gives more weight to recent data points, making it more sensitive to recent changes. It’s calculated using a smoothing factor (often denoted by “α” or “λ”) that determines how much weight to give to the most recent data point compared to the previous EMA value.EMA(t) = α * X(t) + (1 – α) * EMA(t-1)Here, X(t) is the current data point, EMA(t-1) is the previous EMA value, and α is the smoothing factor (usually a value between 0 and 1).

Moving averages are commonly used for various purposes, including:

• Smoothing: They can help in smoothing out short-term fluctuations in data, making it easier to identify long-term trends.
• Forecasting: Moving averages can be used as a simple forecasting technique to predict future values based on historical patterns.
• Filtering: They can be used to filter out noise from data, making it easier to focus on the underlying patterns.
• Identifying Trend Reversals: Moving average crossovers, where a short-term moving average crosses over a long-term moving average, can be used to identify potential trend reversals.

It’s important to note that the choice of window size and the type of moving average (SMA or EMA) depends on the specific characteristics of the data and the goals of the analysis or forecasting. Different window sizes and types of moving averages can yield different results, so experimentation and understanding the underlying data are key.

Non IIMs via CAT College Predictor

Enter your CAT score to find matching colleges:

Submit