Can anyone help with excel and statistic?
Top of Form
Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
MATH 1342 Database.xlsx
Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
=AVERAGE(A2:A36) and =
STDEV(A2:A36).
(Round your answers to 5 decimal places)
Fill in the blank:
The
mean of the DRIVE variable is
Blank 1.
The
standard deviation of the DRIVE variable is
Blank 2.
· Blank 1
· Blank 2
Bottom of Form
2.
Top of Form
Question 2
Question 2
2 Points
Question 2
Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.
To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
=NORM.DIST(40,mean,stdev,TRUE). For the “mean” and “stdev” in the formula, you
don’t
want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.
(Keep your answer in decimal form and round your answer to 3 decimal places)
Fill in the Blank: The proportion of values that I expect to be less than 40 minutes is _____________.
Blank 1
· Blank 1
Bottom of Form
3.
Top of Form
Question 3
Question 3
2 Points
Question 3
Now, determine the
actual
proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.
(Keep your answer in decimal form and round your answer to 3 decimal places)
Fill in the Blank: The actual proportion of values less than 40 minutes is ___________.
Blank 1
· Blank 1
Bottom of Form
4.
Top of Form
Question 4
Question 4
2 Points
Question 4
How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they’re different, etc?
Option A
The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the “drive” variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.
Option B
The probability calculations are the same.
Option C
The probability calculations are different. This must mean that something is wrong with our technology.
Bottom of Form
