![Hands-On Machine Learning with Microsoft Excel 2019](https://wfqqreader-1252317822.image.myqcloud.com/cover/668/36698668/b_36698668.jpg)
Entropy calculation
The frequency table for the combination Outlook-Train outside is as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/7.jpg?sign=1739577808-wHzyMSWVKL34IsFqaiMG1E1XiKyduQFw-0-2081e2363a5fdb8015917ba389433aa7)
Using these values, we get the entropy of two variables, as shown here in detail:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/376672c9-2d09-4c28-8fab-67e9601dc316.png?sign=1739577808-EkiRzsuOeiVliifxwQuwD2BAureYbVnX-0-8e09364e13124d49e6d246d42bf0df3f)
p(Sunny).S(Sunny)+p(Overcast).S(Overcast)+p(Rainy)*S(Rainy)=
5/14*(-3/5*log2(3/5)-2/5*log2(2/5)) +
4/14*(-4/4*log2(4/4)-0/4*log2(0/4))+
5/14*(-2/5*log2(2/5)-3/5*log2(3/5))=
0.693
Here, p(Sunny) = (#Yes+#No)/Total entries = (2+3)/14, p(Overcast) = (#Yes+#No)/Total entries = (4+0)/14, and p(Rainy) = (#Yes+#No)/Total entries = (2+3)/14. The entropy values S(v) are calculated using the corresponding probabilities, that is, #Yes or #No over the total #Yes+#No.
The frequency table for the combination Temperature-Train outside is as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/8.jpg?sign=1739577808-0KdjLDbmRFJIO2HntsTBnjjUZTL3v0OY-0-c558c98302281ae8001f971ebacae581)
Using these values and an analogous calculation, the entropy is shown in detail here:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/eff7388b-ac6d-4b8c-95fa-5d057e97fd1d.png?sign=1739577808-Zwil6eoU3KFCplHqQuIXWVQFoH86xRy7-0-73ea73f9b32bdf75af534ced3bba14a4)
p(Hot).S(Hot)+p(Mild).S(Mild)+p(Cool)*S(Cool)=
4/14*(-2/4*log2(2/4)-2/4*log2(2/4)) +
6/14*(-4/6*log2(4/6)-2/6*log2(2/6))+
4/14*(-3/4*log2(3/4)-1/4*log2(1/4)) =
0,911
The frequency table for the combination Humidity-Train outside is as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/9.jpg?sign=1739577808-VNfK19l6AW5YWzUUmEB4ltP2f32hOrom-0-77e0c7a7808619811db20fa45ad5fd27)
Using these values, we get the entropy as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/91f2ee7e-5fee-497d-8b8a-3a42b9d21d98.png?sign=1739577808-ptXhpHiEwz8AZMFvf6f2gOc8DnKN0M0F-0-a0bb8db3478115c08906385a1cc06bbf)
p(High).S(High)+p(Normal).S(Normal)=
7/14*(-3/7*log2(3/7)-4/7*log2(4/7)) +
7/14*(-6/7*log2(6/7)-1/7*log2(1/7))=
0,788
The frequency table for the combination Windy-Train outside is as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/10.jpg?sign=1739577808-2CdY7NBePnYkWVMeXCptH5P5D2ygUMXo-0-bb703d000353fa73246cff0d32affa72)
Using these values, we get the entropy as follows:
![](https://epubservercos.yuewen.com/33541B/19470379501493906/epubprivate/OEBPS/Images/ae116dfd-9968-47ba-ad17-fbd5ec08073e.png?sign=1739577808-PRbDQtBY3R9uDPQhcQS36yHBa6SieW6Y-0-81d2cd64942f8598daa150624040155f)
p(True).S(True)+p(False).S(False)=
8/14*(-6/8*log2(6/8)-2/8*log2(2/8)) +
6/14*(-3/6*log2(3/6)-3/6*log2(3/6))
=0,892