I'm doing my maths gcse statistics coursework where we have to investigate different shapes to find the best suface area. and why house gutters are normally semi-circular.
The shapes i have investigated so far using excel are a semi-circle,a rectangle, and a trapezium (half hexagon). I am stuck on half an octagom/decagon though.
I have split it into 2 rectangles and two right angled triangles and I have worked out (using excel and written trigonometry cos i'm unsure how to use degrees and radians in excel) the area of an half octagon/decagon with perimeter 30cm.
But i am unsure using excel which commands to use so that i can simply change a number such as a rectangle height and the whole formula will change.
Any help is appreci8d, n it'd b good 2 hear from people who have done or are doing the same or similar pieces of coursework.
Find out how you've done here