Nike data.xls In a pretest, data on Nike were obtained from 45 respondents. These data are given in the following 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, formulate the null and the alternative hypotheses and conduct the appropriate statistical test(s). (a) Obtain a frequency distribution for each of the following variables and calculate the relevant statistics: awareness, attitude, preference, intention, and loyalty toward Nike. (b) Conduct a cross-tabulation of the usage with sex. Interpret the results. (c) Does the awareness for Nike exceed 3.0?