Q1. What is the main purpose of comparing predicted data with actual data?, To evaluate prediction accuracy, To create a new password, Q2. A model predicts 80 students will attend an event, but 100 actually attend. What is the absolute difference?, 10 students, 20 students, Q3. A model predicts 40 units will be sold, and actual sales are 50 units. Using actual sales as the denominator, what is the percentage error?, 10%, 20%, Q4. Which Excel formula calculates the absolute difference between the predicted value in B2 and the actual value in C2?, =ABS(B2-C2), =SUM(B2:C2), Q5. In Excel, what does the IF function do?, Tests a condition and returns a result, Automatically creates a chart, Q6. What will =IF(A2>=50,"Pass","Fail") display if A2 contains 65?, Fail, Pass, Q7. A worksheet categorizes error percentages as follows:, Low Error: at most 20%, Moderate Error: above 20% and at most 40%, Which category applies to 35%?, A. Low Error, B. Moderate Error, Q8. Which actions can help refine a data model when its predictions are inaccurate? Select all correct answers., . Ignore all prediction errors, Check the input data for errors, It shows how large the prediction error is compared with the actual value, data model, Percentage Error

data model gr8

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?