In a pretest, data on Nike were obtained from 45 respondents. These data are given in the adjacent table, which gives the usage, sex, awareness, attitude, preference, intention, and loyalty toward Nike of a sample of Nike users. Usage has been coded as 1 , 2, or 3 , representing light, medium, or heavy users. The sex has been coded as 1 for females and 2 for males. Awareness, attitude, preference, intention, and loyalty are measured on 7-point Likert-type scales (1 very unfavorable, 7 very favorable). Note that five respondents have missing values that are denoted by 9 . Analyze the Nike data to answer the following questions. In each case, state and conduct the appropriate statistical test(s). a. Briefly describe a suitable way to deal with the missing data and use it to replace the two missing values. b. Which variable has a greated inter-quartile range (IQR) between usage and loyalty? What about attitude and preference? c. Do the males and females differ in their awareness for Nike? Their attitude toward Nike? Their loyalty for Nike? Are these differences significant? d. Do the respondents in the pretest have a igficantly higher level of awareness than loyalty? Do they have significantly higher attitude or usage? e. Which of the variables has the highest median? Which of them has the highest 3rd quartile? How about the lowest value for 30 th percentile? Make sure to show your work on Excel