Business Athlete vs. National Average Proportion Sample Size (n) =count(range) Response of Interest (ROI) Count for Response (CFR) =COUNT IF (ange RO Sample Proportion (pbar) =CFR/n Cheated Two Tail HO: p-po Hap #po Left Tail H p po Highlight your HD and Ha Ha: p po Standard Error (StError) #DIMO! SQRT(Hypo'(1-Hypo)] Test Statistic (Z-stat) pbar-Hypo)/StdError Accept or Reject: Left Tal Accept or Reject: Right Tail|| 0.56 0.95 0.05 #DIMO! #DIV/O! #DIV/O! #DIV/01 Accept or Reject: Two Tall p-value (Lower Tall #DIVO! =NORM.S.DISTz,TRUE) p-value (Upper Tall #DIMO! =1-LowerTall p-value (Two Tal #DIMO! =2"MIN/LowerTal UpperTal #DIV/O! #DIV/O! #DIV/O! Accept or Reject p-value: Left Tal Accept or Reject p-value: Right Tall|| Accept or Reject p-value: Two Tal Epba-CONFIDENCE NORM(alpha.StError.n p-Lower Lim #DIMO! p-Upper Limit *DIVO! =pbar+CONFIDENCE.NORM(alpha.StError.n 3-6 Hypothesis Test Business Nonathlete vs. National Average Proportion Sample Size (u count(range) Response of interest (ROI) Count for Response (CFR) =COUNTIF(range ROI) Sample Proportion (pbar) =CFR/n Cheated Two TailH0 p= po Ha: ppo Highlight your H0 and Ha Left TailH0 p po Ha: p po Hypothesized Confidence Coefficient (Coe) Level of Significance (alpha) =1-Coe Right TailH0 ps po Ha: p> po 0.56 0.95 0.05 Standard Error (Stor) #DIV/O! =SQRT(Hypo'(1-Hypon) Acceptor Reject: Right Tail Test Statistic (Z-stat) Accept or Reject: Left Tail Accept or Reject: Two Tail p-value (Lower Tail ENORM.S.DIST(ZTRUE) #DIV/O! =(pbar HypoyStError #DIV/O! #DIV/0 #DIV/O! #DIV/O! p-value (Upper Taill #DIVO! =1-Lower Tail p-value (Two Tail =2*MIN(Lower Tail UpperTail) #DIVIO! Accept or Reject p-value: Left Tall #DIV/01 #DIV/01 #DIV/01 Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail p-Lower Limit Epbar-CONFIDENCENORM/alpha,StError,n) #DIV/O! p-Upper Limit #DIV/O! Epbar+CONFIDENCE NORM/alpha.StError) Business vs. National Average Proportion Sample Size (n) =count range) Response of Interest (ROI) Cheated Count for Response (CFR) =COUNTIF (range RO Sample Proportion (pbar) =CFR/ Two Tail H: p-po Hx p#po Left TailHO: p po Highlight your H0 and Ha Ha: p po Hypothesized 0.56 Confidence Coefficient (Coe) Level of Significance (alpha) =1-Coe 0.95 0.05 Standard Error (StdEmor #DIV/O! =SQRT(Hypo'(1-Hypo)/n Test Statistic (Z-stat) #DIV/O! pbar Hypoy/StError Accept or Reject: Left Tall| #DIV/O! Accept or Reject: Right Tail|| #DIV/O! Acceptor Reject: Two Tail #DIV/O! p-value (Lower Tail) #DIV/O! =NORM.S.DIST(ZTRUE) p-value (Upper Tail) #DIV/O! =1-Lower Tail p-value (Two Tail) #DIV\0! =2"MIN/Lower TailUpperTail Accept or Reject p-value: Left Tail #DIV/01 Accept or Reject p-value: Right Tail| Accept or Reject p-value: Two Tail| #DIV/O! #DIV/O! p-Lower Limit #DIV/O! Epbar-CONFIDENCE NORM/alpha.Storn p-Upper Limit #DIV/O! Epbar+CONFIDENCE NORM/alpha.StError.n Nonbusiness vs. National Average Proportion Sample Size (u) countrange) Response of Interest (ROI) Count for Response (CFR) =COUNTIF (range RO Sample Proportion (bar) =CFR/ Cheated Two Tail H: p=po Ha p=po Highlight your H0 and Ha Left Tail H: p po Ha: p po Hypothesized Confidence Coefficient (Coe) Level of Significance (alpha) =1-Coe Standard Error (StdEmor =SQRT(Hypo'(1-Hypo)/n) Test Statistic (zata) pbar Hypoy/StError 0.47 0.95 0.05 #DIV/O! #DIV/O! Accept or Reject: Left Tail| #DIV/0 Accept or Reject: Right Tail| #DIV/0! Accept or Reject: Two Tail #DIV/O! p-value (Lower Tail) #DIV/O! ENORM.S.DIST(ZTRUE) p-value (Upper Tail #DIV/O! =1-Lower Tail p-value (Two Tail) #DIV/O! =2"MIN/Lower TailUpperTail Accept or Reject p-value: Left Tail Accept or Reject p-value: Right Tail Accept or Reject p-value: Two Tail| #DIV/O! #DIV/0! #DIV/O! p-Lower Limit #DIV/O! Epbar-CONFIDENCE NORM/alpha.StError.n p-Upper Limit #DIV/O! Epbar+CONFIDENCE NORM/alpha.StError.n