Calculating Naive Bayes with Excel Numeric Data Attributes
Assalamualaikum, Greetings to all of you and cultural greetings.
Okay ..., in this discussion I will give you experience on how to calculate Naive Bayes using Microsoft Excel in the case of numeric or continuous data attributes.
Before you want to calculate Naive Bayes using Excel, you must understand more about the basic concept of calculating the Naive Bayes algorithm in the case of numerical data or you can read it in Calculating Naive Bayes Continuous Data Attributes.
If you already understand the basic concept of calculation, we will also be able to calculate it using excel formulas. In Microsoft Excel we will use the COUNTIF, STDEV and AVARAGE function formulas. And Immediately, we start at the earliest stage, namely data preparation.
1. Data Preparation
2. Calculate AVERAGE VALUE
3. Compute Standard Deviation.
- STDEV.S, is the condition of the argument is a sample from the population
- STDEV.P, is a condition in which the argument is to calculate the entire population