For all answer use excel

Note. Usea = 0.05 for all tests.

1. The Bank Call Center data shows the data on 70 former employees at one of thebank's call centers.

a. Is the average length of service for individuals without a college degree the same as those with a college degree?

1. What are the null and alternative hypotheses?
2. Pick the correct test and calculate the test statistics.
3. Is the alternative hypothesis supported? Why?

b. Are employees' actual length of service shorter than their planned length of service?

1. What are the null and alternative hypotheses?

2. Pick the correct test and calculate the test statistics.

3. Is the alternative hypothesis supported? Why?

1. Use the Retail Survey data.

a. Are consumers' gender related to their color preference?

1. What are the null and alternative hypotheses?
2. Pick the correct test and calculate the test statistics.
3. Is the alternative hypothesis supported? Why?

3. Use the Travel Expenses data

a. Compare the travel expenses of the four sales representatives. Are travel expenses of the 3 sales reps different from each other? If there is a difference, how do they differ?

1. What are the null and alternative hypotheses?
2. Pick the correct test and calculate the test statistics.
3. Is the alternative hypothesis supported? Why?

Bank Call Center tap Inf:

Gender	Prior Call Center Experience	College Degree	Length of Service (years)	Planned Length of Service (years)
0	1	0	0.36	0.5
0	0	1	0.3	0.5
1	1	1	0.4	0.5
1	0	0	0.53	1
0	1	0	0.6	1
1	1	0	0.6	1
1	1	0	0.64	1
0	1	0	0.77	1
0	1	0	0.84	1
1	0	0	0.84	1
1	1	0	0.98	1
0	0	1	0.98	1
0	1	0	0.97	1
0	1	0	0.97	1
1	0	0	1.06	1
0	0	1	1.05	1
1	0	1	1.11	1
1	0	0	1.13	1
0	0	0	1.2	1
1	0	1	1.14	1
0	0	0	1.23	1
0	1	1	1.29	1
1	0	0	1.24	1
1	0	1	1.33	1
0	0	1	1.28	1
1	0	1	1.42	1
1	0	1	1.4	1
1	0	0	1.43	1
0	0	0	1.47	1
0	1	1	1.68	2
0	0	0	1.66	2
1	0	1	1.7	2
1	1	0	1.73	2
1	1	1	1.78	2
0	0	0	1.75	2
1	0	0	1.75	2
0	0	1	1.83	2
1	0	0	1.87	2
0	1	0	1.94	2
0	0	0	1.9	2
1	0	0	2	3
0	0	1	2.01	2
0	1	0	2.12	2.5
0	0	1	2.07	2.5
1	0	0	2.17	2.5
1	1	1	2.17	2.5
0	1	1	2.16	2.5
1	1	1	2.17	2.5
0	1	0	2.15	2.5
0	0	0	2.13	2.5
0	1	1	2.13	2.5
1	0	1	2.15	2.5
1	0	0	2.17	2.5
0	0	0	2.27	2.5
1	1	0	2.5	3
1	0	0	2.57	3
0	0	0	2.52	3
1	1	0	2.86	3
0	1	0	2.89	3
0	1	0	2.94	3
0	0	0	3.02	3
0	1	0	3.04	3
1	1	0	3.13	3.5
1	0	0	3.32	3.5
0	0	0	3.32	3.5
1	0	0	3.5	3.5
1	1	0	3.51	3.5
0	0	0	4.04	5
0	0	0	4.41	5
0	0	0	7.05	10

Retail Survey Tap Inf:

Gender	Age Group	Preferred Color	Preferred Style	Purchase Influence
Male	26‐30	Blue	Straight‐leg Fit	Style
Female	18 and under	Black	Slim Fit	Quality
Male	26‐30	Black	Slim Fit	Price
Male	19‐25	Black	Slim Fit	Comfort
Male	Over 30	Blue	Slim Fit	Style
Female	26‐30	Black	Classic Fit	Style
Male	18 and under	Black	Slim Fit	Brand
Male	19‐25	Blue	Slim Fit	Comfort
Male	19‐25	Black	Straight‐leg Fit	Quality
Male	Over 30	Blue	Straight‐leg Fit	Comfort
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality
Female	18 and under	Blue	Slim Fit	Style
Female	26‐30	Blue	Classic Fit	Brand
Male	Over 30	Blue	Relaxed Fit	Comfort
Male	26‐30	Blue	Slim Fit	Comfort
Female	26‐30	Blue	Slim Fit	Comfort
Female	Over 30	Black	Slim Fit	Comfort
Female	18 and under	Black	Slim Fit	Style
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality
Female	18 and under	Blue	Slim Fit	Style
Female	26‐30	Blue	Classic Fit	Brand
Male	Over 30	Blue	Relaxed Fit	Comfort
Male	26‐30	Blue	Slim Fit	Comfort
Female	26‐30	Blue	Slim Fit	Comfort
Female	Over 30	Black	Slim Fit	Comfort
Female	18 and under	Black	Slim Fit	Style
Male	19‐25	Black	Slim Fit	Comfort
Male	Over 30	Blue	Slim Fit	Style
Female	26‐30	Black	Classic Fit	Style
Male	18 and under	Black	Slim Fit	Brand
Male	19‐25	Blue	Slim Fit	Comfort
Male	19‐25	Black	Straight‐leg Fit	Quality
Male	Over 30	Blue	Straight‐leg Fit	Comfort
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality

Traval Expenses Tap Inf:

Gender	Age Group	Preferred Color	Preferred Style	Purchase Influence
Male	26‐30	Blue	Straight‐leg Fit	Style
Female	18 and under	Black	Slim Fit	Quality
Male	26‐30	Black	Slim Fit	Price
Male	19‐25	Black	Slim Fit	Comfort
Male	Over 30	Blue	Slim Fit	Style
Female	26‐30	Black	Classic Fit	Style
Male	18 and under	Black	Slim Fit	Brand
Male	19‐25	Blue	Slim Fit	Comfort
Male	19‐25	Black	Straight‐leg Fit	Quality
Male	Over 30	Blue	Straight‐leg Fit	Comfort
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality
Female	18 and under	Blue	Slim Fit	Style
Female	26‐30	Blue	Classic Fit	Brand
Male	Over 30	Blue	Relaxed Fit	Comfort
Male	26‐30	Blue	Slim Fit	Comfort
Female	26‐30	Blue	Slim Fit	Comfort
Female	Over 30	Black	Slim Fit	Comfort
Female	18 and under	Black	Slim Fit	Style
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality
Female	18 and under	Blue	Slim Fit	Style
Female	26‐30	Blue	Classic Fit	Brand
Male	Over 30	Blue	Relaxed Fit	Comfort
Male	26‐30	Blue	Slim Fit	Comfort
Female	26‐30	Blue	Slim Fit	Comfort
Female	Over 30	Black	Slim Fit	Comfort
Female	18 and under	Black	Slim Fit	Style
Male	19‐25	Black	Slim Fit	Comfort
Male	Over 30	Blue	Slim Fit	Style
Female	26‐30	Black	Classic Fit	Style
Male	18 and under	Black	Slim Fit	Brand
Male	19‐25	Blue	Slim Fit	Comfort
Male	19‐25	Black	Straight‐leg Fit	Quality
Male	Over 30	Blue	Straight‐leg Fit	Comfort
Female	18 and under	Black	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Price
Male	19‐25	Blue	Slim Fit	Quality