Please answers these question with 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 all employees shorter than 2.5 years?

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. Explain your evaluation based on the critical value, p-value, and confidence interval

b. Is the average planned length of service for all employees different from 2 years?

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. Explain your evaluation based on the critical value, p-value, and confidence interval

1. Use the Retail Survey data.

a. Do more than half of the consumers prefer Slim Fit?

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. Explain your evaluation based on the critical value, p-value, and confidence interval

Data : Bank Call Center

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

Data: Retail Survey

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

Data: Traval Expenses

Travel Expenses	Crawford	Jones	Smith
	$ 221.25	$ 317.33	$ 221.32
	$ 80.22	$ 232.06	$ 171.07
	$ 232.94	$ 197.33	$ 158.22
	$ 89.14	$ 148.84	$ 183.27
	$ 110.15	$ 273.53	$ 128.01
	$ 198.18	$ 262.16	$ 87.49
	$ 208.84	$ 196.93	$ 153.68
	$ 161.70	$ 233.67	$ 112.52
	$ 192.56	$ 217.82	$ 135.70
	$ 216.11	$ 155.57	$ 110.49
	$ 151.06	$ 256.16	$ 90.50
	$ 109.53	$ 198.95	$ 125.01
	$ 188.84	$ 166.08	$ 133.72
	$ 137.71	$ 266.85	$ 124.16