Business Applications of Hypothesis Testing and Confidence Interval Estimation
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Business Applications of Hypothesis Testing and Confidence Interval Estimation
This course is part of Business Statistics and Analysis Specialization
Instructor: Sharad Borle
39,582 already enrolled
Included with
Learn more
Ask Coursera
1,335 reviews
1,335 reviews
Skills you'll gain
Tools you'll learn
Details to know
27 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 4 modules in this course
Confidence intervals and Hypothesis tests are very important tools in the Business Statistics toolbox. A mastery over these topics will help enhance your business decision making and allow you to understand and measure the extent of βriskβ or βuncertaintyβ in various business processes.
This is the third course in the specialization "Business Statistics and Analysis" and the course advances your knowledge about Business Statistics by introducing you to Confidence Intervals and Hypothesis Testing. We first conceptually understand these tools and their business application. We then introduce various calculations to constructing confidence intervals and to conduct different kinds of Hypothesis Tests. These are done by easy to understand applications. To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later. Please note that earlier versions of Microsoft Excel (2007 and earlier) will not be compatible to some Excel functions covered in this course. WEEK 1 Module 1: Confidence Interval - Introduction In this module you will get to conceptually understand what a confidence interval is and how is its constructed. We will introduce the various building blocks for the confidence interval such as the t-distribution, the t-statistic, the z-statistic and their various excel formulas. We will then use these building blocks to construct confidence intervals. Topics covered include: β’ Introducing the t-distribution, the T.DIST and T.INV excel functions β’ Conceptual understanding of a Confidence Interval β’ The z-statistic and the t-statistic β’ Constructing a Confidence Interval using z-statistic and t-statistic WEEK 2 Module 2: Confidence Interval - Applications This module presents various business applications of the confidence interval including an application where we use the confidence interval to calculate an appropriate sample size. We also introduce with an application, the confidence interval for a population proportion. Towards the close of module we start introducing the concept of Hypothesis Testing. Topics covered include: β’ Applications of Confidence Interval β’ Confidence Interval for a Population Proportion β’ Sample Size Calculation β’ Hypothesis Testing, An Introduction WEEK 3 Module 3: Hypothesis Testing This module introduces Hypothesis Testing. You get to understand the logic behind hypothesis tests. The four steps for conducting a hypothesis test are introduced and you get to apply them for hypothesis tests for a population mean as well as population proportion. You will understand the difference between single tail hypothesis tests and two tail hypothesis tests and also the Type I and Type II errors associated with hypothesis tests and ways to reduce such errors. Topics covered include: β’ The Logic of Hypothesis Testing β’ The Four Steps for conducting a Hypothesis Test β’ Single Tail and Two Tail Hypothesis Tests β’ Guidelines, Formulas and an Application of Hypothesis Test β’ Hypothesis Test for a Population Proportion β’ Type I and Type II Errors in a Hypothesis WEEK 4 Module 4: Hypothesis Test - Differences in Mean In this module, you'll apply Hypothesis Tests to test the difference between two different data, such hypothesis tests are called difference in means tests. We will introduce the three kinds of difference in means test and apply them to various business applications. We will also introduce the Excel dialog box to conduct such hypothesis tests. Topics covered include: β’ Introducing the Difference-In-Means Hypothesis Test β’ Applications of the Difference-In-Means Hypothesis Test β’ The Equal & Unequal Variance Assumption and the Paired t-test for difference in means. β’ Some more applications
What's included
8 videos8 readings7 assignments
8 videosβ’Total 48 minutes
- Meet the Professorβ’2 minutes
- Introducing the t-distribution, the T.DIST Functionβ’9 minutes
- t-distribution Continued, the T.INV Functionβ’6 minutes
- Introducing Confidence Intervalβ’9 minutes
- Introducing Confidence Interval (Continued)β’6 minutes
- The z-statistic and the t-statisticβ’6 minutes
- Using z- and t- statistics to Construct Confidence Intervalβ’9 minutes
- Week 1 Recapβ’1 minute
8 readingsβ’Total 80 minutes
- Course FAQsβ’10 minutes
- Pre-Course Surveyβ’10 minutes
- Slides, Lesson 1β’10 minutes
- Slides, Lesson 2β’10 minutes
- Slides, Lesson 3β’10 minutes
- Slides, Lesson 4β’10 minutes
- Slides, Lesson 5β’10 minutes
- Slides, Lesson 6β’10 minutes
7 assignmentsβ’Total 240 minutes
- Confidence Interval - Introductionβ’60 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
What's included
6 videos6 readings6 assignments
6 videosβ’Total 43 minutes
- Application of Confidence Intervalβ’13 minutes
- Confidence Interval for a Population Proportionβ’10 minutes
- Sample Size Calculationβ’8 minutes
- Sample Size Calculation (Continued)β’4 minutes
- Hypothesis Testing, An Introductionβ’7 minutes
- Week 2 Recapβ’1 minute
6 readingsβ’Total 60 minutes
- Home_Sizes.xlsxβ’10 minutes
- Slides, Lesson 1β’10 minutes
- Slides, Lesson 2β’10 minutes
- Slides, Lesson 3β’10 minutes
- Slides, Lesson 4β’10 minutes
- Slides, Lesson 5β’10 minutes
6 assignmentsβ’Total 184 minutes
- Confidence Interval - Applicationsβ’60 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’4 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
What's included
7 videos7 readings7 assignments
7 videosβ’Total 57 minutes
- The Logic of Hypothesis Testingβ’7 minutes
- Conducting a Hypothesis Test, the Four Stepsβ’7 minutes
- Single Tail and Two Tail Hypothesis Testsβ’12 minutes
- Guidelines, Formulas and an Application of Hypothesis Testβ’13 minutes
- Hypothesis Test for a Population Proportionβ’10 minutes
- Type I and Type II Errors in a Hypothesis Testβ’7 minutes
- Week 3 Recapβ’1 minute
7 readingsβ’Total 70 minutes
- Slides, Lesson 1β’10 minutes
- Slides, Lesson 2β’10 minutes
- Slides, Lesson 3β’10 minutes
- Average Age.xlsxβ’10 minutes
- Slides, Lesson 4β’10 minutes
- Slides, Lesson 5β’10 minutes
- Slides, Lesson 6β’10 minutes
7 assignmentsβ’Total 240 minutes
- Hypothesis Testingβ’60 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
What's included
7 videos12 readings7 assignments
7 videosβ’Total 86 minutes
- Introducing the Difference-In-Means Hypothesis Testβ’17 minutes
- Application of the Difference-In-Means Hypothesis Testβ’7 minutes
- Application (Continued) - Equal & Unequal Variance Assumptionβ’14 minutes
- The Paired t-Test for Meansβ’18 minutes
- Some More Applicationsβ’20 minutes
- Some More Applications (Continued)β’9 minutes
- Week 4 Recapβ’1 minute
12 readingsβ’Total 120 minutes
- Athletes.xlsxβ’10 minutes
- Slides, Lesson 1β’10 minutes
- Slides, Lesson 2β’10 minutes
- Athletes.xlsxβ’10 minutes
- Slides, Lesson 3β’10 minutes
- Training.xlsxβ’10 minutes
- Slides, Lesson 4β’10 minutes
- Store Salesβ’10 minutes
- Slides, Lesson 5β’10 minutes
- Age Dataβ’10 minutes
- Slides, Lesson 6β’10 minutes
- End-of-Course Surveyβ’10 minutes
7 assignmentsβ’Total 240 minutes
- Hypothesis Test - Differences in Meanβ’60 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
- Practice Quizβ’30 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Data Analysis
- R
Rice University
Course
- R
Rice University
Course
- R
Rice University
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
85.84%
- 4 stars
12.05%
- 3 stars
1.49%
- 2 stars
0.37%
- 1 star
0.22%
Showing 3 of 1335
Reviewed on Nov 25, 2018
I am from Applied Statistics background, and I used to do these tests by hands. I really have enjoyed doing them on Excel as well. Thanks for this amazing course! :)
Reviewed on Nov 26, 2020
I am very thankful for taking this course. Thank you for the Dr. teaching this Course. I have learnt a lot new things that I didn't know how to do in Excel, I loved hypothesis Testing !
Reviewed on Jan 5, 2021
Wonderful insight into the excel applications of statistics and increased my confidence. Looking forward to attending all the courses.
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you canβt afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, youβll find a link to apply on the description page.
More questions
Financial aid available,
