As is typical with many CAD type programs, a feature in Onshape known as revolve may be your solution. As you have a clear formula for the cross-section, half of the work is complete.
You would generate a sketch representing the curve, then use the Revolve feature with the axis oriented to vertical. According to the Onshape video, you can generate a solid or a surface from the options that appear when selecting that feature.
As you can see in the images above, the axis selected in the tutorial video is horizontal. Other features of revolve are covered in the video. Your post suggests it will also be necessary to perform a subtraction action on the assembly in order to get the scoop/concave result.