How to add average min. and max. line?

Question

excel

How to add, as in the example, the average line according to the data and max and min. Are they calculated and are about as in the example?

Answer 1

Build 3 extra. columns: mod , minimum and maximum .

=МОДА(данные)
=МИН(Данные)
=МАКС(Данные)

At the same time, in the rest of the range of values ​​x y=0 , and in these values ​​y=height_of_construction_area