#HomogenitasExcel Uji Homogenitas menggunakan excel

Homogeneity Testing Procedure
📌 The video demonstrates how to perform a homogeneity test using Excel via the Analysis ToolPak add-in.
⚙️ The purpose of the test is to determine if the data from two groups (e.g., pre-test vs. post-test, or Class A vs. Class B) have homogeneous variances.
💻 To enable the tool, one must navigate to File > Options > Add-ins, select Manage Excel Add-ins, check Analysis ToolPak, and click OK.

Executing the F-Test for Variance
📊 After activating the tool, select Data > Data Analysis and choose Two-Sample For Equal Variances (F-test).
🔢 Input the range for Variable 1 (Data A, e.g., 50 to 75) and Variable 2 (Data B, e.g., 79 to 91).
📉 Set the Alpha level ($\alpha$) to 0.05, which is standard for educational research, before running the analysis by clicking OK.

Decision Making Based on F-Test Results
🧐 The decision criterion relies on comparing the calculated F value (F hitung) with the Critical F value (F tabel).
🚫 If the F hitung > Critical F, the variances are not homogeneous (data is heterogeneous).
✅ If the F hitung < Critical F, the variances are homogeneous (data is homogeneous).
💡 The specific example analyzed showed an F value (1.84832) that was less than the Critical F value (2.41), leading to the conclusion that the two data sets are homogeneous.

Key Points & Insights
➡️ The homogeneity test is crucial for ensuring data sets being compared (like pre/post or control/experimental groups) have comparable variances before proceeding with further statistical analysis.
➡️ Utilize the Analysis ToolPak in Excel to quickly run the Two-Sample F-test by properly inputting the data ranges and setting the standard $\alpha = 0.05$.
➡️ Always compare the resulting F value against the Critical F value to make the definitive decision on whether the data variances are equal or not.

📸 Video summarized with SummaryTube.com on Nov 09, 2025, 02:44 UTC