We know there are a lot of worksheet functions that use an array as an argument. How can we use an array as an argument in our costomized worksheet functions? I’d like to address this question step by step. The function declaration. In the function declaration part, you should declare an array parameter as an [...]
In Excel, there is one handy function called CHITEST. By using it, you can easily test for independence. CHITEST returns the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom. You can use Chi Square tests to determine whether hypothesized results are verified by an experiment. CHITEST returns the probability [...]
We usually use Excel to store a lot of data. To process these data, especially fit nonlinear model, is complicated. Excel provides a optimization tool called Solver that can be utilized to solve nonlinear problem numerically. In the past, we have experiences to solve neural network in Excel. If you run the Excel Solver from [...]
One time I have to generate a lot of graphs on fly and insert them to PowerPoint slides to create a nice presentation. The situation is that I have to repeat this process again and again every week or days. The graphs generated on fly are a fixed set. Nobody want to do this boring [...]
Excel Solver is a powerful tool to solve any nonlinear problem in Excel. Excel provide a interface to allow use to select options and fill target and parameters. If you only work on one set of data and explore multiple non-linear function, it is fine to use the Excel Solver interface. More often you are [...]