I have several datasets that feature savings accounts stratified by outstanding balance, e.g.:\r\n\r\n$0-500: X accts, Y total balance\r\n$500-$1000: A accts, B total balance\r\netc.\r\n\r\nBased on implied distributions in these stratifications, I need to develop code that can estimate the number of zero-balance accounts. \r\n\r\nDetailed description in excel file (attached - see first tab). The file contains VB code that uses Solver to estimate a best-fit function, but it only functions on a fully continuous basis, i.e. it cannot estimate a non-continuous number of accounts at the zero-balance, which is the ultimate goal of the exercise. You are free to use the existing code, or write your own.