I have a table that has a lot of data as shown in table a. what if I want to change the data from table a to table b? I want to change my data which has many frequencies to only 5 frequencies, like table b. What formula can I use if I use MS Excel to convert data from table a to table b? by the way, I've tried it by extrapolating data using the linear equation, but the results are not the same as table b. please give me the correct formula! Table B