Week 6 - Group Assignment

inferential_statistics_and_findings-lee.xlsx

Sheet2

1	1	49.9	2	$443		Key		Travel Code	Boundries for check cost
1	1	49.9	1	$650		Checked bages	1		0	5
1	1	49.9	3	$650		Carry on bages	2		1	10
1	1	35.9	3	$443					2	25
1	1	40.9	4	$600		Travel times	1-2 times a week	1	3	35
1	1	48.9	4	$443			3-7 times a week	2	4	45
1	1	44.9	4	$450			once a month	3	5	55
1	1	49.9	4	$735			Twice a month	4	6	60
1	1	49.9	2	$443					7	70
2	2	20.9	1	$400					8	80
2	2	21.9	1	$418					9	90
2	2	35.9	2	$335					10	100
2	2	44.9	1	$618
2	2	40.9	1	$420
2	2	30.9	4	$350
2	2	33.9	1	$455
2	2	21.9	1	$443
2	2	20.9	2	$650
2	2	20.9	3	$505
Business class traveler	Checked/Carry on	Weight of bag	Times traveled	Cost	Checked Bages	Carry on
					$443	$400
					$650	$418
					$650	$335
					$443	$618
					$600	$420
					$443	$350
					$450	$455
					$735	$443
					$443	$650
						$505
	t-Test: Two-Sample Assuming Unequal Variances
		443	400
	Mean	551.75	466
	Variance	14435.3571428571	11771
	Observations	8	9
	Hypothesized Mean Difference	0
	df	14
	t Stat	1.53706703
	P(T<=t) one-tail	0.0732830222
	t Critical one-tail	1.7613101358
	P(T<=t) two-tail	0.1465660444
	t Critical two-tail	2.1447866879
	If the t stat is larger than the critical two tail vaule we will contenue to charge for checked bags
	Column1
	Confidence Level(95.0%)	90.7712019758
	Column1
	Confidence Level(95.0%)	74.6810378317