stat analysis homework and excel lab

lab_3_template.xls

Home >Mathematics homework help >stat analysis homework and excel lab

Lab 3 Template

Your name
DS 123 Lab #3
Due: 09/21/2016
Question 1.	Problem 9.14, p. 355
Notice the data for this problem are located on the second spreadsheet, tab below. Use the
Data Analysis Toolkit to develop the descriptive statistics for the data on that spreadsheet, then
copy the output and paste it below. By doing so, you won't have to print the data with your lab.
		WaitTime
		Mean
		Standard Error
		Median
		Mode
		Standard Deviation
		Sample Variance
		Kurtosis
		Skewness
		Range
		Minimum
		Maximum
		Sum
		Count
			z-Statistic	p-value
		Hypotheses:
		Rejection Region:	a = 0.02	a = 0.02
			z-coeff =	Rej H0 if p-value < 0.02
Don't forget:			Rej H0 if z <??
The problem
tells us		Test Statistic:	z =	p-value =
SIGMA = 2.47
		Conclusion:
		Since the test statistic of z = ?? falls		Since the test statistic of p-value = ?? falls
		{above/below/between} the critical value		{above/below/between} the critical value
		of z = ??, we {reject/do not reject} H0		of a = ??, we {reject/do not reject} H0
		with at least 98% confidence.		with at least 98% confidence.
		Implication:
		There {is/is not} enough evidence to		There {is/is not} enough evidence to
		conclude that the new system has		conclude that the new system has
		reduced mean waiting time to		reduced mean waiting time to
		less than 6 minutes.		less than 6 minutes.
Question 2.	Problem 9.42, pp. 365-6
Population proportion = 0.95
Sample x = 316			Sample proportion =
Sample n = 400
			z-Statistic	p-value
		Hypotheses:
		Rejection Region:	a = 0.01	a = 0.01
			z-coeff =	Rej H0 if p-value < 0.01
			Rej H0 if z < ??
		Test Statistic:	z =	p-value =
		Conclusion:
		Since the test statistic of z =?? falls		Since the test statistic of p-value =?? falls
		{above/below/between} the critical		{above/below/between} the critical
		value of z = ??, we {reject/do not reject}		value of a = ??, we {reject/do not reject}
		H0 at least 99% confidence.		H0 at least 99% confidence.
		Implication:
		There {is/is not} enough evidence to		There {is/is not} enough evidence to
		conclude that the manufacturer's claim		conclude that the manufacturer's claim
		is false.		is false.

Data 9.14

WaitTime
1.6	WaitTime
6.6
5.6	Mean	5.46
5.1	Standard Error	0.2475455269
3.9	Median	5.25
4.6	Mode	5.8
6.5	Standard Deviation	2.4754552688
6.4	Sample Variance	6.1278787879
8.6	Kurtosis	-0.4049603971
4.2	Skewness	0.2504148026
5.8	Range	11.2
3.4	Minimum	0.4
9.3	Maximum	11.6
7.4	Sum	546
1.8	Count	100
6.2
5.4
4.9
5.4
0.8
2.5
8.3
6.1
6.3
6.8
9.8
2.9
10.9
4.7
3.9
3.2
6.5
2.3
8.7
4.7
3.6
2.7
3.7
0.4
10.2
2.8
11.6
4.3
3.1
5.8
5.6
4.4
4.5
6.7
8.1
4.3
2.2
5.8
8.6
2
8
9.5
1.3
4.8
9.9
7.9
1.1
7.2
2.9
9.1
7.7
4
1.4
7.8
5.2
8.4
6.3
4.4
5.2
7.4
6.1
3.8
10.7
7.5
7
5.3
4.5
4.5
1.8
3.7
4
5.7
2.4
9.2
5
7.2
7.3
4.1
6.7
3.5
6.3
4.3
3.8
5.1
5.5