Gini Index in Excel

[Anonymousg]

Hello,


How should I create Gini index in excel for this table?
no. outcome venue A B C
1 W H y y y
2 L A y n y
3
4
.
.

 

[shg]

Pardon? What does any of that data mean?

 

[Anonymousg]

[TABLE="width: 500"]
<tbody>[TR]
[TD]no[/TD]
[TD]outcome[/TD]
[TD]venue[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Won[/TD]
[TD]Home[/TD]
[TD]yes[/TD]
[TD]no[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Lost[/TD]
[TD]abroad[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Lost[/TD]
[TD]abroad[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[/TR]
</tbody>[/TABLE]


This is related to building a decision tree model for predicting the outcome of a cricket match using the information provided in the sample data and I need to identify a split for Gini index.

 

[shg]

See the formula on p 2 of https://support.sas.com/resources/papers/proceedings12/136-2012.pdf

I still have no idea what your data means.

 

[shg]

Here's an example of the calculation described in the paper:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][/tr][tr][td]

6​

[/td][td]

Innings, N​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

7​

[/td][td]

10​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

8​

[/td][td]

Inning​

[/td][td]

Runs​

[/td][td][/td][td]

Avg​

[/td][td]

15.7​

[/td][td]E8: =AVERAGE(B9:B18)[/td][/tr]
[tr][td]

9​

[/td][td]

1​

[/td][td]

20​

[/td][td][/td][td]

G​

[/td][td]

0.155​

[/td][td]E9: {=1/(2*N^2 * Avg) * SUM(ABS(B9:B18 - TRANSPOSE(B9:B18)))}[/td][/tr]
[tr][td]

10​

[/td][td]

2​

[/td][td]

14​

[/td][td][/td][td]

CAA​

[/td][td]

13.3​

[/td][td]E10: =Avg*(1-G)[/td][/tr]
[tr][td]

11​

[/td][td]

3​

[/td][td]

8​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

12​

[/td][td]

4​

[/td][td]

19​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

13​

[/td][td]

5​

[/td][td]

18​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

14​

[/td][td]

6​

[/td][td]

10​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

15​

[/td][td]

7​

[/td][td]

19​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

16​

[/td][td]

8​

[/td][td]

17​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

17​

[/td][td]

9​

[/td][td]

21​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

18​

[/td][td]

10​

[/td][td]

11​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]