1.Open the data set aids.dta. The variable year is for calendar year, hivinf is for HIV infections in millions and aidscases is for AIDS diagnoses.

data sheet link: https://docs.google.com/spreadsheets/d/1V9E5lz5K1gGjmAi0aW6PNrPOEKYTI4P7ZJsv5Te8WAI/edit?usp=sharing

Please check if my answers are correct. If you use statistical software, please show your work and please do not copy and paste from other sources. Thanks.

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

B.What is the median value for HIV infections? 8.70 million

C.What is the interquartile range for HIV infections? 17.95 million

D. Now look at AIDS cases. Provide a 99% confidence interval for the true mean of AIDS cases.

Which answer is correct? Please provide a step-by-step explanation. If both answers are wrong, please share the right answer. Thanks.

(0.549,6.227)

or

(0.884, 5.892)

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

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

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

Which answer is correct? Please provide a step-by-step explanation. If both are wrong, please share the right answer. Thanks

p- value < 0.001, p < .05

or

p = 0.334, p > .05

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

Conclusion: Because p > .05, the results would be not significant. We would fail to reject the null hypothesis and state that there is a correlation between AIDS cases and HIV infections.