Note: Please do not block this question i submitted this in to support team once again. if you dont want to help me then ignore it. This is for practice to help my classmates and I know on how to learn from confidence Interval. i am new to this and I would to learn so i can understand on how to learn Confidence Interval. I need help explaining how i can learn this. Its not a violation to learn. I would like to collaborate with the tutor so i can ask questions for my notes so i can learn this properly. thank you.

it doesnt have to be in excel. i just need help explaining this so i can learn this.

Put alpha = .05 and give the values for the problem.

Confidence Interval.

Confidence Intervals for the Mean sigma known.

Put alpha = .05 and give the values for the problem.

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

Gas prices in my sate:

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

attach the excel spreadsheet

Example below:

• Locate 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 put 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 put the standard deviation

• Assume your answer is .43

• Then put this in an excel cell=confidence.norm(.05,.43,36)and hit enter. This is the E value
• So take the mean of 2.65 and we have(2.65-E, 2.65+E) for your confidence interval

Formula we 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