Prediction accuracy
You'll need to create multiple sets of predicted values to determine which one is more accurate.
Remember that you can forecast values with the FORECAST() function by supplying three arguments:
x, which is the value to use to predict,data_y, which is the set of outcome data to use, anddata_x, which is the set of predictor values.
本练习是课程的一部分
Google Sheets 中的误差与不确定性
练习说明
- In cells
J2:J10, forecast students' final grades based on their period 1 grades. - In cells
K2:K10, forecast students' final grades based on their period 2 grades.
