Critical t value 167866041355687 b12 p value

• Homework Help
• 13
• 100% (11) 11 out of 11 people found this document helpful

This preview shows page 8 - 13 out of 13 pages.

Critical t-value1.67866041355687"=B12"p-value0.787019589150007"=1-T.DIST(\$B\$11,\$B\$5-1,TRUE)"ConclusionH0: At least 3 years"=IF(G12<B9,"Reject Null Hypothesis","DTwo-tailed testCritical t-value (+ and -)2.01289559891943"=B13"p-value0.425960821699986"=IF(B11>0,T.DIST.2T(B11,B5-1),T.DIST.ConclusionH0: At least 3 years"=IF(G17<B9,"Reject Null Hypothesis","DConclusion & Assumption:Any student in a Graduate Degree Program has at least 3 years of prior .
o Not Reject Null Hypothesis")"Do Not Reject Null Hypothesis")"T.2T(-B11,B5-1))"Do Not Reject Null Hypothesis")"job experience.
Credit Card ChargesOne Sample Test for the MeanSample Size42Sample Mean1376.54Sample Standard Deviation183.89Hypothesized value1350Level of significance0.05t-statistic0.935335571"=(B6-B8)/(B7/SQRT(B5))One tailed t-value1.682878002"=T.INV(1-B9,B5-1)"Two tailed t-value (+ and -)2.01954097"=T.INV.2T(B9,B5-1)"Hypothesis Statement is: H0: Charges DecreasedH1: Charges IncreasedUpper tailed test
Hypothesis test resultsLower one-tailed testCritical t-value-1.68287800213271p-value0.822453989317345ConclusionH0: Charges DecreasedUpper one-tailed testCritical t-value1.68287800213271p-value0.177546010682655ConclusionH1: Charges IncreasedTwo-tailed testCritical t-value (+ and -)2.01954097044138p-value0.35509202136531ConclusionH0: Charges DecreasedConclusion is:Average monthly charges increa
"=-B12""=T.DIST(\$B\$11,\$B\$5-1,TRUE)""=IF(G7<B9,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")""=B12""=1-T.DIST(\$B\$11,\$B\$5-1,TRUE)""=IF(G12<B9,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")""=B13""=T.DIST.2T(B11,B5-1)""=IF(G17<B9,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")"ased
Advertising Strategya.Hypothesis Statement is:H0 : IncreasedH1: Did not increaseb.X_bar\$ 75.86 18-25 groupS.D.\$ 50.90 Mean\$ 70.00 n300t-stat1.99 "=(C7-C10)/(C8/SQRT(C11))"Critical Value1.650 "=T.INV(0.95,C11-1)"Decision/ConclusionH0 : Increased c.X_bar\$ 68.53 35+ groupS.D.\$ 45.29 Mean\$ 70.00 n700t-stat(0.86)"=(C16-C19)/(C17/SQRT(C20))"Critical Value1.647 "=T.INV(0.95,C20-1)"Decision/ConclusionH1: Did not increase
• • • 