Can anyone help with excel and statistic?1.Top of Form Again, you will use the student survey from the Excel

Can anyone help with excel and statistic?

1.

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

1Title Student name Faculty name Due dateQuestion 1 Minimum: 2.71

1 Title Student name Faculty name Due date Question 1 Minimum: 2.71 Maximum: 4.25 Question 2 Quartile 1: 3.435 Quartile 2: 3.59 Quartile 3: 3.84 Question 3 Sample mean: 3.58 Median: 3.5900 Standard deviation: 0.310135 Question 4 Confidence Interval Lower Limit: 3.46653 Confidence Interval Upper Limit: 3.6981 Question 5 Null

Need help with finding correlation coefficient. COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission RequirementsThis

Need help with finding correlation coefficient.  COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission Requirements This competency assessment assesses the following Outcome(s): MM207M3: Determine the relationship between two variables. GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English. It is time to demonstrate what you have

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!!PADM 810Quantitative Analysis Report: Structure of

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!! PADM 810 Quantitative Analysis Report: Structure of Assignments 1. Use the following structure for your research article: Abstract, Introduction, Literature Review/Theory, Methods, Results, Discussion, and Conclusion. Include a robust discussion section distinct from your conclusion. 2. Give your article a