แบบฝึกหัด

Mean imputation

Create a stored procedure that will apply mean imputation to the YellowTripData records with an incorrect TripDistance of zero. The average trip distance variable should have a precision of 18 and 4 decimal places.

คำแนะนำ

100 XP

Create a stored procedure named cuspImputeTripDistanceMean
Create a numeric variable: @AvgTripDistance.
Compute the average TripDistance for all records where TripDistance is greater than 0.
Update the records in YellowTripData where TripDistance is 0 and set to @AvgTripDistance.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}แบบฝึกหัด

คำแนะนำ

แบบฝึกหัด