Hi,



I need to create a function in VBA that produces three columns of values.
The chart below is what I have. The first two columns need to be passed as an array into this function. The values of Y, X, and the Gini Value need to be the output of this function into this table. The formula for the Y variables is as follows: E5=SUM(D5:$D$17)/$D$19 E6=SUM(D6:$D$17)/$D$19 and so on all the way down to E17. The formula for X is the same thing except with C's instead of D's. The Third Column has the formula G5=(F5-F6)*(E5+E6) G6=(F6-F7)*(E6+E7) and so on. At the bottom, Area=SUM(G5:G17), DR=Total Defaults/Total Count, and Gini=(G19-1)/(1-G20). Can someone help please?
CountDefaultsYnXnIncrement11570110.0759659891713010.9620170.1124716851759010.9057810.1154919413288410.8480350.213645479432670.9792750.7400940.272997682457580.9430050.5980760.2770381834490180.9015540.4478840.2520338164065160.808290.3004830.20466842974270.7253890.1670330.1279852791398290.5854920.06940.046845937353330.4352330.0235050.008106008290380.2642490.0119170.00315701473130.0673580.0023970.0001614230030461193Area1.710568836DR0.006335971Gini0.715099686