Publication number: ELQ-44603-1
View all versions & Certificate
A/B Testing Significance Excel Spreadsheet Calculator
Calculate statistical significance for any kind of split testing being done.
The spreadsheet is set to automatically calculate significance for you- p-value, z-value and other applicable metrics for whichever kind of split testing (including Adwords) being done.
The spreadsheet serves to detail how it is that significance is calculated. All that needs to be provided is the number of visitors and conversion for control and variations. These can be inserted in the red cells.
Certainly, you will see the relevant formulas in the spreadsheet.
Feel free to share the file with your friends or colleagues, or on your social media platforms.
Special thanks to Jai, where we realized a small error existed in the conversion rate range calculations (though significance results were unaffected). However, the error has been fixed on the spreadsheet.
- Paras Chopra
This business tool includes
1 Excel sheet
Paras Chopra offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Sales Efficiency Metrics: How to Calculate the SaaS Magic NumberThis model will show you how to calculate the SaaS Magic Number to measure sales efficiency.modelcalculatorsaasmetricscacexcelspreadsheetsales efficiencysaas magic numbersales and marketing522 remove_red_eye
Social Media Metrics Excel DashboardAn excel template for employees to understand the performance of social media channels for their organisation.salesmarketingsocial mediametricsdashboardkpitemplateexcelfree4,535 remove_red_eye
How to Create a Real Estate Marketing Report with Sample TemplateMeasure the following 8 metrics to track the success of your marketing performance and learn to build a marketing reportsalesreportmarketingkpismetricstemplateexcelreal statesampledownload1,798 remove_red_eyefreeby Bob Samii
Personnel Forecast Excel Model TemplateHow to create detailed headcount forecasts using excelmodelexpensesforecasttemplateexceloperating expensesemployeesstaffwagespersonnel902 remove_red_eye
Cash Flow Statement Template in ExcelCash Flow Statement Template in Excel containing a suggested list of profit and expenses items your business may have.businessfinancecash flowaccountingcashcash flow statementtemplateexcelcalculations537 remove_red_eye
Mobile App / Website - 5 Year Recurring Revenue Excel Model TemplateA financial forecasting excel model template for apps or websites that have recurring paid subscribers.dcfsensitivity analysissaasrecurring revenuetemplateexcelspreadsheetfinancial forecastwebsite startupstartup business modelmobile app572 remove_red_eye$95.00by Jason Varner
Sample Investor Monthly Report TemplateReport on your progress to investors using the monthly report template.performancereportinvestormonthlytemplateexcelsampleangel investor840 remove_red_eye
Cash Sweep Concepts Excel TemplateUnderstand the four concepts of cash sweeping.financemodeltemplateexceldownloadcash sweepconcepts891 remove_red_eyefreeby Michael Shane
Scoring Model Excel TemplateThis tool can be used to define the priority of action regarding products, employees, customers, etc.probabilitytemplateexcellinear regressionregressionprioritiespurchasescoring modellogistic regression316 remove_red_eye
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise845 remove_red_eye$400.00by Alexander Jarvis
Any questions on A/B Testing Significance Excel Spreadsheet Calculator?
The user community and author are here to help. Go ahead!