Question at position 4 What is the upper bound for LARGE outliers for the "MINUTES to travel to RMIT?" variable on the TravelData worksheet? EXCEL used to calculate values from data in the ONPS2700_QuizData fileAnswerWhat is the upper bound for LARGE outliers for the "MINUTES to travel to RMIT?" variable on the TravelData worksheet? EXCEL used to calculate values from data in the ONPS2700_QuizData file[input]简答题
登录即可查看完整答案
我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

Question

Question at position 4 What is the upper bound for LARGE outliers for the "MINUTES to travel to RMIT?" variable on the TravelData worksheet? EXCEL used to calculate values from data in the ONPS2700_QuizData fileAnswerWhat is the upper bound for LARGE outliers for the "MINUTES to travel to RMIT?" variable on the TravelData worksheet? EXCEL used to calculate values from data in the ONPS2700_QuizData file[input]简答题

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

BlackTom AI · Accepted Answer

The upper bound for large (high-end) outliers is computed as Q3 + 1.5 × IQR, where IQR = Q3 − Q1. In Excel you would typically obtain Q1 and Q3 with QUARTILE.INC(range,1) and QUARTILE.INC(range,3) (or PERCENTILE.EXC/PERCENTILE.INC), compute IQR = Q3 − Q1, then compute UpperFence = Q3 + 1.5 * IQR.

Step-by-step procedure you must perform on the TravelData worksheet:
1. Extract the "MINUTES to travel to RMIT?" data vector from the TravelData sheet.
2. Calculate Q1 = first quartile (25th percentile) and Q3 = third quartile (75th percentile) using Excel functions such as =QUARTILE.INC(range,1) and =QUARTILE.INC(range,3) (or =PERCENTILE.INC(range,0.25) and =PERCENTILE.INC(range,0.75)).
3. Compute IQR = Q3 − Q1.
4. Compute Upper bound for large outliers = Q3 + 1.5 * IQR.
5. Optionally, identify any values > Upper bound as large/high outliers.

All intermediate numeric steps require the actual Q1 and Q3 values from the dataset. Because the ONPS2700_QuizData file and the TravelData worksheet are not provided here, Q1, Q3, IQR and therefore the numeric upper bound cannot be computed. Any numeric answer would be speculative without the raw data.

Why the provided answer is correct: the question requests a numeric upper bound derived from worksheet data; without access to that data, the calculation cannot be completed. There are no alternative numeric choices to evaluate here, so no other options can be validated.