Split Plot Excel Tool with One Main Plot and Two Sub Plot Factor

𝐒𝐩𝐥𝐢𝐭 𝐏𝐥𝐨𝐭 𝐝𝐞𝐬𝐢𝐠𝐧𝐬 𝐰𝐢𝐭𝐡 𝐨𝐧𝐞 𝐦𝐚𝐢𝐧 𝐩𝐥𝐨𝐭 𝐟𝐚𝐜𝐭𝐨𝐫𝐬 𝐚𝐧𝐝 𝐭𝐰𝐨 𝐬𝐮𝐛 𝐩𝐥𝐨𝐭 𝐟𝐚𝐜𝐭𝐨𝐫 are among the most complex field trial layouts to analyze manually. This video walks you through Agri Analyze's free Excel Tool that auto-generates a fully customized, publication-ready analysis sheet — tailored to your exact number of replications and factor levels.

✅ 𝐖𝐡𝐚𝐭 𝐭𝐡𝐢𝐬 𝐭𝐨𝐨𝐥 𝐝𝐨𝐞𝐬:
→ Generates a dynamic output sheet based on your replications and levels of Main Plot Factor, Sub Plot Factor A, and Sub Plot Factor B
→ Computes a complete ANOVA table with correct error terms for main plots and sub plot (SS, DF, MS, F value, significance)
→ Calculates SEm, SEd, CD at 5% and 1%, and CV% for all sources of variation
→ Provides factor-wise means with SE and SD
→ Supports None, SQRT, LOG, and ARCSIN transformation — switch with a single click

📥 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐃𝐞𝐦𝐨 𝐅𝐢𝐥𝐞:
https://drive.google.com/file/d/1bGQXDlrx-2E9cRDbP2yxFhd8NtEg_qwO/view?usp=sharing

🔗 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐞 𝐲𝐨𝐮𝐫 𝐨𝐰𝐧 𝐒𝐩𝐥𝐢𝐭 𝐏𝐥𝐨𝐭 (1 𝐌𝐚𝐢𝐧 + 2 𝐒𝐮𝐛) 𝐄𝐱𝐜𝐞𝐥 𝐓𝐨𝐨𝐥:
https://www.agrianalyze.com/SplitPlotOneTwoExcelTool

Split Plot designs are widely used in agronomy, irrigation studies, plant breeding, and variety trials where some factors are harder to randomize than others. This tool ensures your error terms and degrees of freedom are always correct — no manual checking required.

𝐕𝐢𝐝𝐞𝐨 𝐂𝐫𝐞𝐝𝐢𝐭: Abhishek Lakhani
𝐅𝐞𝐚𝐭𝐮𝐫𝐞 𝐂𝐫𝐞𝐝𝐢𝐭: Priyansi Modi

🌐 Explore more statistical tools for agriculture:
https://www.agrianalyze.com

📌 Chapters:
0:00 — Introduction
0:17 — Understanding Split Plot design excel tool
2:56 — Getting excel tool from agri analyze
4:16 — Getting sqrt transformation excel tool
5:30 — Tour of sqrt transformed Split 12 Excel Tool
8:24 — Useful links

👍 Found this useful? Like and share with your fellow researchers!
💬 Have questions? Drop them in the comments — we read every one.
🔔 Subscribe for more agricultural statistics tools and tutorials.

#AgriAnalyze #SplitPlotDesign #SplitPlot #AgriculturalStatistics #ANOVA #ExcelTool #FieldTrials #DOE #CropResearch #AgriResearch #StatisticsForAgriculture

Видео Split Plot Excel Tool with One Main Plot and Two Sub Plot Factor канала Agri Analyze