Please answer in details with explanation and interpretation and you can use Excel if required but plz share formula for the understanding.

For your reference:

below problem is from Anderson, Sweeney, and Williams, "Statistics for Decision Making", 2nd ed. (customized version), South-Western Pub. Co., 2008.

Each month the U. S. Bureau of Labor Statistics publishes a variety of unemployment statistics, including the number of individuals who are unemployed and the mean length of time the individuals have been unemployed. For November 1998, the Bureau of Labor Statistics reported that the national mean length of time of unemployment was 14.6 weeks.

The mayor of Philadelphia requested a study on the status of unemployment in the Philadelphia area. A sample of 50 unemployed residents of Philadelphia included data on the age and number of weeks without a job.Data are below question

(a)Use descriptive statistics to summarize the data.

(b)Develop a 95% confidence interval estimate of the mean age of unemployed individuals in Philadelphia.

(c)Conduct a hypothesis test to determine whether the mean duration of unemployment in Philadelphia is greater than the national average of 14.6 weeks. Use a 0.01 level of significance. What is your conclusion?

(d)Is there a relationship between age of an unemployed individual and the number of weeks of unemployment?

Age Weeks

56 22

35 19

22 7

57 37

40 18

22 11

48 6

48 22

25 5

40 20

25 12

25 1

59 33

49 26

33 13

56 15

20 17

31 11

27 17

23 3

45 17

29 14

31 4

59 39

39 7

35 12

44 38

27 14

24 6

27 7

45 25

42 33

45 16

44 12

21 13

31 16

42 4

23 14

51 31

27 7

30 10

33 23

32 8

22 7

51 12

50 16

21 9

38 5

26 8

55 35