I have 2 questions that I need help with and I am attached. part of the excel I added with the word as well.

thanks  ATTACHMENT PREVIEW Download attachmentColumn1Drive36Mean49.5680Standard Error5.65009734476Median5488Mode3654Standard DeviaTon28.2506Sample Variance798.094Kurtosis-1.15641060255Skewness-0.2359570836Range9071Minimum425Maximum9428Sum123973Count2563Confdence Level(95.0%)11.66122778789436257680546455361239We are now going to calculate the probabilities of ranges for theDRIVEvariable andcompare them to the actual incidence of ranges in our data set.•UsingData Analysis, Descriptive Statistics, find the mean and standard deviationfor theDRIVEvariable, in column A of your Excel data set.Enter those values intothe box below. If we assume that this variable is normally distributed, we can use thedanielsoper.com website that we used in Chapter 5 to calculate the probabilities wewant.•We want to use the values we just determined to calculate thepredictedpercentagethat would be less than 40 minutes of commuting time.•Use thedanielsoper.comwebsite,Statistics Calculators, Cumulative DistributionFunction Calculator for the Normal Distribution.Enter themeanfor Drive,

View the Answerstandard deviationfor Drive and enter40for x, clickcalculate.Record theprobability below.•Now determine theactualpercentage of data points in the dataset that fall within thisrange.To find the actual percentage in the dataset, sort theDRIVEvariable andcount how many of the data points are less than 40 out of the total set of 25 datapoints.Divide by the total of 25.That is the actual percentage.How does thiscompare with your prediction?(10 points)Mean: ___49.56_____Standard deviation: __28.250______Predicted percentage less than 40 minutes: ________Actual percentage: ________Comparison: _________________________________________________________________________________________________________________________________•Now we want to calculate the predicted percent of students who would commutebetween 40 and 70 minutes per day to class (DRIVEvariable).We already have theprobability for less than 40.Repeat the procedure above with the values for the meanand standard deviation you calculated andsubstituting 70 for 40in the x space todetermine the probability that the commute time isless than 70 minutes.Subtractthe little probability from the big probability andenterthe value below.•Find the actual percent by counting and dividing the data points between 40 and 70 inthe sortedDRIVEcolumn.•Finally, take1 – P(x<70)that you calculated above to determine thepredictedpercent of students who will spend more than 70 minutes commuting andenterthevalue below.•Find theactualpercent by counting and dividing the data points greater than 70 in thesortedDRIVEcolumn.•Compare the actual to predicted percents and discuss the differences you see.Whyare these differences to be expected?(11 points)Predicted percentage between 40 and 70:________Actual percentage between 40 and 70:________Predicted percentage for more than 70 minutes:________Actual percentage for more than 70 minutes:_________Comparison ___________________________________________________________________________________________________________________

Show 

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