You are Here: Home >< Maths

1. hi

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.

Luke.

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: August 25, 2003
Today on TSR

### Cambridge interviews

Find out who is getting invitations

### University open days

• University of Roehampton
Sat, 17 Nov '18
• Edge Hill University
Faculty of Health and Social Care Undergraduate
Sat, 17 Nov '18
• Bournemouth University
Sat, 17 Nov '18
Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams