Need help with statistics ASAP

Allow between 2-3 hours to complete the lab assignment.

1. Go to Files, Lab Files and open the lab data file.

The file I’m using for this illustration uses different data set. Please do not copy the answers from these examples. You are not going to get credit for the lab if the answers are copied form this example.

NOTE: You must use Excel 2013.

2. Open the Week 6 Lab Document

Save the file to your computer and rename it:

MATH399_W6_Lab_Excel_Your_Name_Here write your name

Problem 1: Give and interpret the 95% confidence interval

You are going to work with column E, Sleep (hours)

Follow the steps:

1. In cell E37, type =AVERAGE(E2:E36).

2. In cell E38, type =STDEV(E2:E36).

3. In cell E39, type =CONFIDENCE.NORM(0.05,E38,35). The 0.05 is based on the confidence level of 95%, the E38 is the standard deviation, and 35 is the number in our sample.

4. Confidence interval

(6.6 - 0.449, 6.6+0.449) = (6.151, 7.049)

There is a 95% probability that this interval encompasses the true average hours of sleep for the population.

Problem 2: Give and interpret the 99% confidence interval

In cell E40 type =CONFIDENCE.NORM(0.01,E38,35) to find the maximum error for a 99% confidence interval. Again, you would need to use a calculator to subtract this and add this to the mean to find the actual confidence interval.

Problem 3: Compare the 95% and 99% confidence intervals.

The ………………. confidence interval is wider to have a greater probability of it including the true mean.

Problem 4: Find the mean and standard deviation of the DRIVE variable

You are going to work with column A, Drive (miles)

Follow the steps:

1. In cell A37, type =AVERAGE(A2:A36).

2. In cell A38, type =STDEV(A2:A36).

3. In cell A39, type =NORM.DIST(40, A37, A38,TRUE)

4. Sort the date in column A (you may copy it in a different column)

5. Count how many of the data points are less than 40 out of the total 35 data points.

6. Calculate 15/35 = ….

Problem 5: Find the mean and standard deviation of the DRIVE variable

You are going to work with column A, Drive (miles)

In cell A40, type =NORM.DIST(70, A37, A38,TRUE)

1. Predicted percentage between 40 and 70: 0.774- 0.344 = 43.04%

2. Actual percentage: Count how many of the data points are between 40 and 70 out of the total 35 data points.

Calculate 7/35 =

3. Predicted percentage more than 70 miles: 1 - 0.774 = 22.56%

4. Actual percentage: Count how many of the data points are above 70 out of the total 35 data points.

Calculate 13/35 =