espin086 / espin086/Experiments

Create Confidence Interval

Open
#3 0 comments 0 reactions 1 assignee Claimed by @espin086 View on GitHub
Dominant language
Python
Stars
0
Forks
0
PR merge metrics
No merged PRs in 30d

Description


  |   |   |  
-- | -- | -- | --
  |   |   |  
Situation 1: Create A Confidence Interval
  |   |   |  
You have completed a test mailing and obtained a response rate. |   |   |  
What is the confidence interval? |   |   |  
  |   |   |  
  |   |   |  
Test Mailing |   | Enter Data |  
  |   |   |  
Proportion Response: |   | 0.5 |  
Confidence Level: (80%,85%,90%,95%) |   | 0.9 |  
Sample Size: |   | 223000 |  
  |   |   |  
This is a Two Sided Test |   |   |  
  |   |   |  
The Expected Response Rate is Between: | =+E39 | And | =+E38
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
Work Area
  |   |   |  
Percent Response | P= | =+E13 |  
Sample Size | N= | =+E15 |  
  |   |   |  
Standard Error = se = sqrt{P*(1-P)/N} | SE | =SQRT(E13*(1-E13)/E15) |  
  |   |   |  
Critical Point | a= | =ABS(NORMSINV((1-E14)/2)) |  
Confidence Interval =P +/-a*SE | a*SE | =+E36*E34 |  
  | P+a*SE | =+E31+E37 |  
  | P-a*SE | =+E31-E37 |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  
  |   |   |  

 


USAA Classification: Internal

Disclaimer: This email and any attachments are the property of USAA and may contain confidential and/or privileged material. If you are not the intended recipient, any use, disclosure or copying of this email or any attachments is unauthorized. If you received this email in error, please immediately notify the sender and delete the email and any attachments from your computer.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.