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…
