Question

Assuming .05 as your alpha value, make up a problem similar to this one. Make up 36 gas prices for your example. Use price values in your list that some you made up and be sure they are similar to the prices you have had in your area. List the values in your post.

data:

3.39, 3.49, 3.55, 3.25, 3.38, 3.48, 3.19,3.27, 3.29, 3.20, 3.23, 3.22, 3.25, 3.33, 3.27, 3.21, 3.34, 3.24, 3.29. 3.23, 3.07, 3.24, 3.23, 3.47, 3.29 3.53, 3.33, 3.15, 3.66, 3.41, 3.37, 3.32, 3.41, 3.24, 3.28, 3.36

Example below:

First find the mean. List all 36 gas prices in cells A1 to A36 in your excel spreadsheet.

On a different cell type in =average(A1:A36) and the hit enter to find the average

Assume your answer is 2.65

On a different cell type in =stdev.s(A1:A36) or =stdevA(A1:A36) and enter to find the standard deviation

Assume your answer is .43

Then type this in an excel cell =confidence(.05,.43,36) and hit enter. This is the E value

So take the mean of 2.65 and you have (2.65-E, 2.65+E) for your confidence interval

Formula you used above for the confidence interval:

The formula is E= zsubc * sigma / sqrt n

Where the left hand endpoint is xbar - E and the right hand endpoint is xbar + E

Answer 1

on the basis cample to find meem SO1226 tynknown population rterndomd deviation(r 2-03 en 33183 03 , С. ) 220 teft endpoint e 3:3183-0 041 3:276 Rİht endpoint ー3,3183千0: OLİ 15 3:359