Forum-Gallery-Shop-Sponsors

« Advertise on Freel2.com

Home > Off Topic > Bell Curves in Excel - HELP
Post Reply  Down to end
Page 1 of 1
Print this entire topic · 
flylr



Member Since: 03 Apr 2010
Location: Oxfordshire
Posts: 281

2013 Freelander 2 TD4 GS Auto Santorini Black
Bell Curves in Excel - HELP

A long shot - but I thought I would ask if anyone has had to produce bell curves in excel before.
It is 30 years since I last did statistic and I don't remember a thing about it!

Basically I have a list of score achievements, and the number of people who achieved those scores.
i.e.

Score #of people
F 0
A 2
E 3
B 10
C 20
D 42

I have been asked if I could plot these results on a bell curve but I have no idea how to go about this.
I have googled, you tubed etc - and although I have found a lot of info' it assumes I know about means, deviations etc. Which I don't. And the worled examples I have found never quite relate to what I am trying to do.

Im ok on excel - and can obviously create graphs - in this case I believe an x,y scatter graph - but how I convert those scores to a bell curve so I can the graph it is the issue.

Any ideas guys? Big Cry (Coming) 2016 RR Evoque td4 180 HSE Dynamc
(Going) 2013 TD4 GS Auto - Santorini Black with black leather. Cold Climate, UK Lighting & Armrest Packs. Privacy Glass. LR Rubber Mats. Full size spare.
60 000 miles averaging 35mpg

(Gone) 2010 TD4 Manual GS - Stornoway Grey. Sold at 3yrs old & 64k miles. Final average consumption 39.2mpg.

Post #176599 21st Mar 2013 10:41 pm
View user's profile Send private message View poster's gallery Reply with quote
Stevie5tapes



Member Since: 10 Jun 2012
Location: Brighouse, YORKSHIRE
Posts: 1370

England 2013 Freelander 2 TD4_e GS Auto Sumatra Black

Sorry but you lost me on bell curves!! I'm sure someone else will be able to help, been years since I used excell too! Black MY2013 SD4 GS Auto, Wood Company Armrest, Freel2 sticker.
Gone MY2010 Freelander 2 Manual TD4.e S, Alaska White.

Post #176621 22nd Mar 2013 8:11 am
View user's profile Send private message View poster's gallery Reply with quote
chrisdeeming



Member Since: 29 Dec 2011
Location: Sutton Coldfield
Posts: 828

2007 Freelander 2 TD4 SE Manual Santorini Black

http://www.calcunation.com/calculators/mis...urve+Grade

 When I die, I want to go peacefully like my Grandfather did, in his sleep -- not screaming, like the passengers in his car


Last edited by chrisdeeming on 22nd Mar 2013 8:34 am. Edited 2 times in total

Post #176624 22nd Mar 2013 8:16 am
View user's profile Send private message View poster's gallery Reply with quote
wizking



Member Since: 18 Mar 2010
Location: Around
Posts: 1848

England 2013 Freelander 2 SD4 XS Auto Indus Silver

http://www.ehow.co.uk/how_5914187_use-exce...curve.html

Post #176625 22nd Mar 2013 8:19 am
View user's profile Send private message View poster's gallery Reply with quote
flylr



Member Since: 03 Apr 2010
Location: Oxfordshire
Posts: 281

2013 Freelander 2 TD4 GS Auto Santorini Black

Something very strange going on here. These replies never came up..... Until today - 10 momths later!! Crying or Very sad
Belated thanks for help and responses guys. Thumbs Up (Coming) 2016 RR Evoque td4 180 HSE Dynamc
(Going) 2013 TD4 GS Auto - Santorini Black with black leather. Cold Climate, UK Lighting & Armrest Packs. Privacy Glass. LR Rubber Mats. Full size spare.
60 000 miles averaging 35mpg

(Gone) 2010 TD4 Manual GS - Stornoway Grey. Sold at 3yrs old & 64k miles. Final average consumption 39.2mpg.

Post #214288 19th Jan 2014 6:37 pm
View user's profile Send private message View poster's gallery Post Reply
Post Reply  Back to top
Page 1 of 1
All times are GMT

Jump to  
Previous Topic | Next Topic >
Posting Rules
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Site Copyright © 2006-2024 Futuranet Ltd & Martin Lewis
Freel2.com RSS Feed - All Forums


Switch to Mobile site