Question: how to calculate standard precipitation index in excel?
Answer: To calculate the SPI (Standard Precipitation Index), a long-term precipitation record at the desired station is first fitted to a probability distribution (e.g. gamma distribution), which is then transformed into a normal distribution so that the mean SPI is zero (McKee et al., 1993, 1995).