1.The variable year is for calendar year, hivinf is for HIV infections in millions and aidscases is for AIDS diagnoses.

year hivinf aidscases

1980 0.2 0

1981 0.6 0

1982 1.1 0

1983 1.8 0.1

1984 2.7 0.2

1985 3.9 0.4

1986 5.3 0.7

1987 6.9 1.1

1988 8.7 1.6

1989 10.7 2.3

1990 13 3.2

1991 15.5 4.2

1992 18.5 5.5

1993 21.9 6.9

1994 25.9 8.5

1995 30.6 10.4

1996 36.2 12.5

a.Calculate the mean number of HIV infections over the entire time period (i.e. average HIV infections per year).

b.What is the median value for HIV infections?

c.What is the interquartile range for HIV infections?

d.Now look at AIDS cases. Provide a 99% confidence interval for the true mean of AIDS cases. (Please show work.)

e.What is Pearson's correlation coefficient for the relationship between AIDS cases and HIV infections?

f. What is Spearman's rank correlation coefficient for the relationship between AIDS cases and HIV infections?

g. What is the p value for Spearman's rank correlation coefficient?

h.What is the null hypothesis and conclusion for the test in part G?

Please show work for the above, even if you're going to use Excel. Thanks.