BA 1605 – Midterm Recap: Statistical Analysis and Probability Calculations BA 1605 – Midterm Recap a) The variables “Gender” and “Partcipation in online auction?” are categorical variables in the given data collection. b) The annual amount spent online for the second participant will be $50. c) The above data collection is based on cross - sectional data. d) The type of data collection method used here was most probably “the mailed questionnaire” method. Since data collected related to online shopping this data might be collected from the filled in feedback form reverted by the respondents at the time of online shopping. a) The required Excel formula to fin d the frequency of “Poor” is, “=COUNTIF (A:A, “Poor”) ” . b) The required Excel formula in F4 is “= E 4/ E $7” . c) The proper method to analyze this data set in Excel is “Insert Pivot Table” to construct contingency tables since both the variables “Quality rating” and “Location” of the hotel are categorical . a) There are no quantitative variables in the table . The categorical variables in the table are Gender and Brand . b) The probability that a randomly selected respondent is a female preferring Canon is, 60 0.1111 540 = . c) The marginal probability of brands “ Can o n ” is, 140 0.2593 540 = . d) The probability that the male person responses prefer Canon is, 80 0.2963 270 = . e) Since the marginal probability of brands “Canon” is not same as the probability that the male person responses prefer Canon, this data does not indicate that brand prefernce is independent of gender. a) Median = 7 Q1 = 5.5 Q3 = 10 b) Central locations: Calculation Value