Human resource department of a computer manufacturer collected data regarding gender, age, city, and salary of 308 employees from its branches in three different cities. Data can be found intheExcel file AS3.XLSX (Emp-Dat).

a. With 90% confidence level, estimate the average salary of men in city A.

b. With 5% significance level, estimate the average age of women in city B.

c. Regardless of which city they are working, suppose you want to estimate the

d. average salary of men with in 200 units with 90% confidence level. According to historical data you know the standard deviation of the salary is 5500. What sample size would be required?

d. With 90% confidence level, can we conclude that the averagemen'ssalary in

1. city C is higher than $90,000?

e. Test whether there is sufficient evidence to show that the average women'sage:

1. in city A and C are equal. Assume 95% confidence level.

f. Are youagreed with this statement; "the percentage of male employees is

1. equal to 50%"? Use 95% confidence level.

https://docs.google.com/spreadsheets/d/1ZvynmmdzKQfrJ1_nVqEIazu0icXoX5xO29cK42OjZRY/edit?usp=sharing