Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
Reference
1. George W. Snedecor, & Cochran, William G. (1989). Statistical Methods (8th ed.): Blackwell Publishing Professional.
2. William G. Zikmund, & Babin, Barry J. (2007). Exploring Market Research 9th.
3. Graham Upton, & Cook, Ian (1996). Understanding Statistics: Oxford University Press.
Sheet1
Restaurant A Restaurant B
Range 44 46
Variance 260.79-285.64
Std 16.15-16.90
Ttest 0.72
Sheet2
Sheet3
Sheet1
Salary Mid interval salary, x x2 Employees, f f.x f. x2
5001-10000 7500.5 56257500.25-14 105007 787605003.50
10001-15000 12500.5 156262500.25-13 162506.5 2031412503.25
15001-20000 17500.5 306267500.25-18 315009 5512815004.50
20001-25000 22500.5 506272500.25-18 405009 9112905004.50
25001-30000 27500.5 756277500.25-17 467508.5 12856717504.25
Sum ?f ?fx ?fx2
80 1455040 30301455020.00
Mean 18188
Variance 47964843.75
Sheet2
Sheet3
Sheet1
Stores Cost of CD Restaurant A Restaurant B. Salary Mid interval salary, x x 2 Employees, f f.x f. x 2
1 298-120-115 5001-10000 7500.5 56257500.25-14 105007 787605003.50
2 125-123-126 10001-15000 12500.5 156262500.25-13 162506.5 2031412503.25
3 411-153-147 15001-20000 17500.5 306267500.25-18 315009 5512815004.50
4 157-128-156 20001-25000 22500.5 506272500.25-18 405009 9112905004.50
5 231-124-118 25001-30000 27500.5 756277500.25-17 467508.5 12856717504.25
6 213-118-110 Sum ?f ?fx ?fx 2
7 304-154-145 80 1455040 30301455020.00
8 272-110-137 Mean 18188
Std 90.72 Max 154-156 Variance 47964843.75
Min 110-110 Std 6925.6655817329
Range 44 46
Variance 260.79-285.64
Std 16.15-16.90
Waiting time Mid interval time, x x 2 Customers, f f.x f. x 2 Height Mid interval height, x x 2 Customers, f f.x f. x 2
0-3-1.5-2.25-13-19.5-29.25 70-71-70.5 4970.25 3 211.5 14910.75
4-7-5.5-30.25-16 88-484 72-73-72.5 5256.25 7 507.5 36793.75
8-11 9.5-90.25 8-76-722 74-75-74.5 5550.25-16...
Salary Mid interval salary, x x 2 Employees, f f.x f. x 2
1 298-120-115 5001-10000 7500.5 56257500.25-14 105007 787605003.50
2 125-123-126 10001-15000 12500.5 156262500.25-13 162506.5 2031412503.25
3 411-153-147 15001-20000 17500.5 306267500.25-18 315009 5512815004.50
4 157-128-156 20001-25000 22500.5 506272500.25-18 405009 9112905004.50
5 231-124-118 25001-30000 27500.5 756277500.25-17 467508.5 12856717504.25
6 213-118-110 Sum ?f ?fx ?fx 2
7 304-154-145 80 1455040 30301455020.00
8 272-110-137 Mean 18188
Std 90.72 Max 154-156 Variance 47964843.75
Min 110-110 Std 6925.6655817329
Range 44 46
Variance 260.79-285.64
Std 16.15-16.90
Waiting time Mid interval time, x x 2 Customers, f f.x f. x 2
0-3-1.5-2.25-13-19.5-29.25
4-7-5.5-30.25-16-88 484
8-11 9.5-90.25 8-76 722
12-15-13.5 182.25-11-148.5 2004.75
16-19-17.5 306.25 0-0 0
20-23-21.5 462.25 2-43-924.5
Sum ?f ?fx ?fx 2
50 375-4164.5
Mean 7.5
Variance…
86 34.00 additive 2 9 11.33 Total 16 Test Statisticsb gas mileage Mann-Whitney U 6.000 Wilcoxon W 34.000 Z -2.701 Asymp. Sig. (2-tailed) .007 Exact Sig. [2*(1-tailed Sig.)] .005a a. Not corrected for ties. b. Grouping Variable: fuel additives (per m) P (1) 0.004 P (2) 0.008 With the two P. values being so far apart, as well as the variance of the two groups being of significant value, around 2 whole values, it is clear that there is a significant difference to be noted between the two sample groups. Through the analysis of both