Assume the distribution of commute times to a major city follows the normal probability distribution and the standard deviation is 4.5 minutes. a random sample of 38 commute times is given below in minutes. use excel to find the 98% confidence interval for the mean travel time in minutes. round your answers to one decimal place and use ascending order. time 21 15 35 40 40 34 32 11 18 35 9 31 15 29 41 37 40 10 31 14 39 14 11 33 38 21 35 33 34 27 31 26 35 27 32 18 40 17

The 98% confidence interval would be given by (25.904;29.306)

Step-by-step explanation:

1) Previous concepts

A confidence interval is "a range of values that’s likely to include a population value with a certain degree of confidence. It is often expressed a % whereby a population means lies between an upper and lower interval".

The margin of error is the range of values below and above the sample statistic in a confidence interval.

Normal distribution, is a "probability distribution that is symmetric about the mean, showing that data near the mean are more frequent in occurrence than data far from the mean".

The data is:

21, 15, 35, 40 ,40 ,34, 32, 11, 18, 35, 9, 31, 15, 29, 41, 37, 40, 10, 31, 14, 39, 14, 11, 33, 38, 21, 35, 33, 34, 27, 31, 26, 35, 27, 32, 18, 40, 17

2) Compute the sample mean and sample standard deviation.  

In order to calculate the mean and the sample deviation we need to have on mind the following formulas:  

=AVERAGE(21, 15, 35, 40 ,40 ,34, 32, 11, 18, 35, 9, 31, 15, 29, 41, 37, 40, 10, 31, 14, 39, 14, 11, 33, 38, 21, 35, 33, 34, 27, 31, 26, 35, 27, 32, 18, 40, 17)

On this case the average is

=STDEV.S(21, 15, 35, 40 ,40 ,34, 32, 11, 18, 35, 9, 31, 15, 29, 41, 37, 40, 10, 31, 14, 39, 14, 11, 33, 38, 21, 35, 33, 34, 27, 31, 26, 35, 27, 32, 18, 40, 17)

The sample standard deviation obtained was s=10.184

represent the population standard deviation

3) Find the critical value t* Use the formula for a CI to find upper and lower endpoints

In order to find the critical value we need to take in count that our sample size n =38 >30 and on this case we know about the population standard deviation, so on this case we need to use the z distribution. Since our interval is at 98% of confidence, our significance level would be given by and .

We can find the critical values in excel using the following formulas:

"=NORM.INV(0.01,0,1)" for

"=T.INV(1-0.01,0,1)" for

The confidence interval for the mean is given by the following formula:

And we can use Excel to calculate the limits for the interval

Lower interval : "=27.605 -2.33*(4.5/SQRT(38))" =25.904

Upper interval :  "=27.605 +2.33*(4.5/SQRT(38))" =29.306

So the 98% confidence interval would be given by (25.904;29.306)

  y= -3x is the required function.

step-by-step explanation:

we have been given a table:

x             y

0             0

1             -3

3             -9

-2             6

we can see that the values of y is -3 times the value of x

hence, the function would be: y= -3x.

put the values of x will give the same y as in the table that means function is satisfying the given table.