If you wish to create a dynamic graph, you would have to use tables for the data. To calculate CPI in Excel, you need to use a formula like this: =[(Cumulative price of basket of commodities in ...

For a set with an even number of data points, you'd take the mean of the two middle numbers to find the median. Advantages and Disadvantages of the Mode Mode observations are most useful to ...