Perform a Two Sample Proportion Test in Excel

When we want to compared the proportion of two groups (or samples), a suitable way to do this is with a two sample proportion hypothesis test. The question we're trying to answer is if there is a significant difference between the the proportion of the two groups/samples. This could be something like do the proportions of a drug effect females the same way they affect males or if the proportions of one group voting over a topic the same as another group. Too bad there is no tool to select a few cell ranges and gave an output (like t-test in the Excel Data Analysis Tookpak), but it's not too bad to manually lay out some cells and go through the formulas/functions to perform the hypothesis test. 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr... 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel ~-~~-~~~-~~-~ Please watch: "Convert Table in a PDF File to Excel"    • Convert Table in a PDF File to Excel   ~-~~-~~~-~~-~