Question

Test the following hypotheses and interpret your findings.

Hypothesis	Sample Findings	Sample Size	Confidence Level	Your Test Results	Your Findings
Mean: 7.5 Std. Dev.: 1.2	Mean: 8.5	670	95%
Percent: 86%	p = 95%	1000	99%
Mean: 125 Std. Dev.: 15	135	500	95%
Percent: 33%	p = 31	120	99%

Answer 1

Ans 1 ) using excel

Z Test of Hypothesis for the Mean
Data
Null Hypothesis                    m=	7.5
Level of Significance	0.05
Population Standard Deviation	1.2
Sample Size	670
Sample Mean	8.5
Intermediate Calculations
Standard Error of the Mean	0.046360045
Z Test Statistic	21.57029851
Two-Tail Test
Lower Critical Value	-1.959963985
Upper Critical Value	1.959963985
p-Value	0
Reject the null hypothesis

we will reject Ho because p value is 0

Ans 2 ) using excel

Z Test of Hypothesis for the Proportion
Data
Null Hypothesis        p =	0.86
Level of Significance	0.01
Number of Items of Interest	950
Sample Size	1000
Intermediate Calculations
Sample Proportion	0.95
Standard Error	0.010972693
Z Test Statistic	8.202179436
Two-Tail Test
Lower Critical Value	-2.575829304
Upper Critical Value	2.575829304
p-Value	2.22045E-16
Reject the null hypothesis

we will reject Ho because p value is less than 0.01

Ans 3 ) using excel

Z Test of Hypothesis for the Mean
Data
Null Hypothesis                    m=	125
Level of Significance	0.05
Population Standard Deviation	15
Sample Size	500
Sample Mean	135
Intermediate Calculations
Standard Error of the Mean	0.670820393
Z Test Statistic	14.90711985
Two-Tail Test
Lower Critical Value	-1.959963985
Upper Critical Value	1.959963985
p-Value	0
Reject the null hypothesis

we will reject Ho because p value is less than 0.05

Ans 4 ) using excel

we have

Z Test of Hypothesis for the Proportion
Data
Null Hypothesis        p =	0.33
Level of Significance	0.01
Number of Items of Interest	31
Sample Size	120
Intermediate Calculations
Sample Proportion	0.258333333
Standard Error	0.042924352
Z Test Statistic	-1.669603925
Two-Tail Test
Lower Critical Value	-2.575829304
Upper Critical Value	2.575829304
p-Value	0.094997753
Do not reject the null hypothesis

do not reject Ho because p value 0.095 > 0.01