The Student Room Group

Bell Curve Graph

Hey there, me again,

New maths question,

A colleague, who is a Fuels engineer, is testing the effects of an experimental fuel additive for petrol engines which your company is developing. She adds the same sample amount of additive to 100 full petrol tanks for the same model of car and records the number of miles per gallon (mpg) for each car after being driven around a test track at a constant speed, until the fuel runs out. She knows that such testing undertaken without the additive produces a mean mpg figure of 44. Collecting results with the additive, she notices that the mean mpg figure is 48 with a sample standard deviation of 13 mpg.
By interpreting the results of the testing, show whether you agree, or not, with her hypothesis that the fuel additive has influenced the number of miles per gallon for the cars.
Draw by hand, or use suitable software, to produce a graphic, suitable for a non-technical company executive, which represents the results of your analysis.

Pretty sure I have the answer but no idea how to go about creating a graphic for this? Any help or resources I can check out?
Reply 1
Hi,
I have the same question, I also think I have an answer but not sure how to go about doing the graph.
Did you find an info that helped?
I've spent hours online but can't find anything that helps.
Below are 2 videos that show how can you produce a normal distribution curve using excel:




Or Using google sheets:



https://digitalmaestro.org/articles/normal-distribution-curve-with-google-sheets

Quick Reply