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

av
Skriv ut
Bädda in

Rankningslista

Visuell stil

Alternativ

Växla mall

Återställ sparas automatiskt: ?