BA 1605 � Midterm Recap: Statistical Analysis and Probability Calculations
Midterm recap covering statistical analysis and probability calculations.
Caleb Patterson
Contributor
4.2
56
about 1 month ago
Preview (4 of 11)
Sign in to access the full document!
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.
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 find the frequency of “Poor” is,
“=COUNTIF (A:A, “Poor”)”.
b) The required Excel formula in F4 is “=E4/E$7”.
c) The proper method to analyze this dataset 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.
“=COUNTIF (A:A, “Poor”)”.
b) The required Excel formula in F4 is “=E4/E$7”.
c) The proper method to analyze this dataset 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.
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
University of New Brunswick
Subject
Statistics