Please help me respond to 2 of my classmates discussion post . I will put a couple classmates posts I just need to respond to 2. I will post the assignment and then post what they put. The teacher wants us to not just agree but ask questions or add to it. Thank you

For this forum we will discuss confidence intervals and what they mean.

Initial Post Instructions:

1. Choose a data set of fuel prices from the attached Excel file.
2. Find the mean and standard deviation for the data set. Please do not try to do this by hand, but use the functions in Excel.
3. Find the 95% Confidence Interval for your data.

Classmate 1:

Hi class, I hope you all are doing well. This week we are asked to pick a data set from the fuel prices provided in the excel file. I chose data set number 40. The mean is $7.48, the standard deviation is 1.3 with it being rounded to 1.30, and the 95% confidence interval is 0.49 or 0.

Mean= $7.48

Standard Deviation= 1.394567498

95% Confidence Interval= 0.4909155

Classmate 2

Good evening, class!

For this week's discussion, I chose data set #8.

Mean: $5.05 Std Dev: 0.47953342 E Value: 0.17176264 Confidence Interval: $4.89 - $5.22

I hope everyone's having a great week!

Rachel

Classmate 3

Good afternoon Class,

I chose Data Set 11 for this discussion post. See attachment for a visual.

I calculated theMean by using the function=average(a2:a31) giving $5.72

I calculated my Standard Deviation by using the function=stdev.s(a2:a31) giving 0.81

I calculated my E value by using the function=confidence.norm(0.05,0.81,30) giving 0.29

TheConfidence Interval is between 5.43 and 6.01 from calculating (5.72-0.29, 5.72+0.29).This is ourE value substracted and added from ourMean value.

-Sabra

Classmate 4:

Hello class,

I chose data set 17. Mean= 4.77333333

Standard Deviation= 1.496790436

Upper confidence interval(95%)= 5.332244068

Lower confidence interval(95%)=4.214422599

-Donna

Classmate 5:

Hello Everyone, For this weeks discussion I chose Data Set # 24. For this weeks assignment I had to go back and change my initial post due to errors in my process. The following is the revised explanation for this weeks discussion.

The first step for solving this problem is finding the average price for Fuel. I found the mean by calculated the Mean by using the following formula in excel =average(A2:A31). Using this formula I found that the average fuel price for my specific data was $3.26.

The second step to was to find my Standard Deviation. I found my standard deviation by using the following formula in excel =STDEV.S(A2:A31) which gave me the answer 1.148 which I rounded to 1.15.

The third step I had to find E value for my data chart. To find the E value I had to use the following formula in excel = Confidence. Norm(0.05,STDEV.S, # of data Values), =CONFIDENCE.NORM(0.05,1.15,30) which gave me the answer of .41. For the final step for finding my 95% Confidence Interval I had to subtract and add my standard deviation from the average fuel price. I used the following formula to find my Confidence Interval (average +/- STDEV.S) = (3.26 - .41), (3.25 + .41) = (2.85 and 3.67). Special Thank You to Sabra Waggoner and Dr. Z for helping me with realize the error I made this week. I appreciate your advice.

- Percy