Hi,
I am after some help on how to plot a normal distribution curve for some data entries using excel. The numbers attached are some of the counts of cars over an hour period, from 8:00am til 9:00am, on numerous Wednesdays over the period of a year over a stretch of road. I do not know how to do this as I have not been exposed to normal distribution in excel. Would you be able to please show me how you did it and the steps you took to achieve this.
My numbers for the counts of cars are: 2329, 2207, 2731, 2720, 2595, 2825, 2810, 2851, 2806, 2564, 2802, 2710, 2679, 2825, 2852, 2915, 2968, 2808, 3023, 2907, 1939, 12842, 2855, 2828, 2715, 2775, 2925, 2875, 2753, 2880, 2828, 3042, 2941, 2898, 2873, 2963, 2909, 2746, 1654
Sorry, I would have put them in a excel doc but am unable to..
Thanks for the help! Really appreciate it.
Travis
I am after some help on how to plot a normal distribution curve for some data entries using excel. The numbers attached are some of the counts of cars over an hour period, from 8:00am til 9:00am, on numerous Wednesdays over the period of a year over a stretch of road. I do not know how to do this as I have not been exposed to normal distribution in excel. Would you be able to please show me how you did it and the steps you took to achieve this.
My numbers for the counts of cars are: 2329, 2207, 2731, 2720, 2595, 2825, 2810, 2851, 2806, 2564, 2802, 2710, 2679, 2825, 2852, 2915, 2968, 2808, 3023, 2907, 1939, 12842, 2855, 2828, 2715, 2775, 2925, 2875, 2753, 2880, 2828, 3042, 2941, 2898, 2873, 2963, 2909, 2746, 1654
Sorry, I would have put them in a excel doc but am unable to..
Thanks for the help! Really appreciate it.
Travis
