Find the mean and standard deviation of the DRIVE variable by using (A2:A36) and (A2:A36).  Assuming that this

variable is normally distributed, what percentage of data would you predict would be less than 40 miles?  This would be based on the calculated probability.  Use the formula .DIST(40, mean, stdev,TRUE).  Now determine the percentage of data points in the dataset that fall within this range.  To find the actual percentage in the dataset, sort the DRIVE variable and count how many of the data points are less than 40 out of the total 35 data points.  That is the actual percentage.  How does this compare with your prediction

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"