引導式測驗 · 中等 等級

提示 AI 進行資料分析測驗

測試資料集上下文、方法檢查點、文件工具變更、計算驗證、連接和缺失資料檢查以及隱私。

問題 1 的 8

What information helps an assistant interpret dataset values correctly?

預覽每個問題8 問題

當您參加測驗時,就會出現答案和解釋。

  1. What information helps an assistant interpret dataset values correctly?
    • Column names and units, without describing how or when values were collected
    • Column meanings, units, time range, collection context, and limitations
    • A summary of the desired chart, without clarifying what each field represents
    • An instruction to infer undocumented definitions from correlations
  2. Why ask the assistant to state its proposed analysis method before interpreting results?
    • It lets the assistant select an analysis method before seeing any data
    • It proves the selected method will produce an unbiased estimate
    • It automatically resolves ambiguous field definitions from the dataset
    • It creates a checkpoint where a mistaken assumption can be corrected
  3. What does OpenAI’s data-analysis documentation describe for ChatGPT?
    • File upload, interactive table views, natural-language questions, comparisons, and charts or analyses
    • File upload and natural-language questions, with all workspaces sharing identical capabilities
    • Interactive tables and charts that require no review of source data
    • Comparisons and analyses that are guaranteed to use the correct statistical method
  4. A conversion rate is defined as completed purchases divided by eligible checkout sessions. Which denominator should the calculation use?
    • The count of distinct products viewed during the period
    • The number of completed purchases, which is the numerator
    • The count of eligible checkout sessions in the same analysis period
    • All site visits, including visitors who never entered checkout
  5. An order-lines table has many rows per order, while a product table should have one row per SKU. What check helps prevent a join from multiplying rows?
    • Aggregate order lines to one row per order before joining to products
    • Join on product name and remove repeated output rows afterward
    • Check that the tables have the same number of rows before joining
    • Verify the product table has one matching row per SKU and inspect the join cardinality
  6. A model reports monthly revenue. Which method provides the strongest independent check of the total?
    • Re-run the same assistant-generated code without checking its inputs or filters
    • Recalculate revenue from source rows with a separate reviewed formula or script and the same documented filters
    • Ask the same model to repeat its total from the same computed table
    • Compare only the total with a rounded chart label from the same analysis
  7. Before calculating a monthly mean with blank measurements, what should the analyst do?
    • Inspect why values are missing and choose an appropriate treatment for that field
    • Carry the previous value forward for all fields without checking their meaning
    • Drop every row with any blank, regardless of how much data that removes
    • Replace every blank with zero so each month has the same row count
  8. What privacy practice does the guide recommend before uploading data?
    • Use an approved tool while including every available personal field
    • Assume a private workspace waives the organization’s data-handling rules
    • Use only approved tools and workspaces and remove unnecessary identifiers
    • Remove direct identifiers but upload through an unapproved public service