Find the mean and standard deviation of the drive variable


Find the mean and standard deviation of the drive variable by using=average(A2:A36) and =stdev(A2:A36). Assuming the variable is normally distributed, what percentage of data would you predict would be less than 40 miles: this would be based on the probability. Use the formula =norm.dist(40,mean,stdev,true). Determine the 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.

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Find the mean and standard deviation of the drive variable
Reference No:- TGS02857596

Now Priced at $10 (50% Discount)

Recommended (94%)

Rated (4.6/5)