I have an excel sheet with the number of instances for a particular problem in a day and the total time taken to solve all of the problems in the day. I have data for the previous 2 year. Is it possible to find the average individual contribution of all the problems?.
Note: Time taken for a problem to be solved might slightly vary on a daily basis.