confidence interval with two responses

Assignmentguruh.com boasts a team of highly skilled and experienced writers who specialize in various academic fields. The company carefully selects its writers through a rigorous screening process to ensure that they possess the necessary qualifications and expertise. Whether it’s an essay, research paper, or any other homework assignment, students can rely on Assignmentguruh.com to connect them with professionals who have an in-depth understanding of the subject matter. This ensures that the work delivered is of high quality and meets the academic standards set by educational institutions.
Confidence Intervals for the Mean sigma known
Main Post
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.
Instructions for your response. You will respond to at least 2 classmates.
In your response, describe what you did and give the mean, standard deviation and confidence interval.
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
Just a review of your instructions:

First you will make up a problem with alpha = .05 and give the values for the problem. This is your main post.
Then will make 2 responses explaining all work and giving the solutions to 2 classmates problems.

Instructions: Your initial post should be at least 250 words. Please respond to at least 2 other students. Responses should be a minimum of 100 words and include direct questions.
To earn full credit for this forum, you must respond to at least two (2) of your peers and post your initial post by Thurs.
Initial Post Due: Thursday, by 11:55pm, ETResponses Due: Sunday, by 11:55pm, ET.
*Only during the first week of class are assignments not due until 11:55 p.m., ET, Sunday. After Week 1, all initial posts will be due Thursday, by 11:55pm, ET.
Rubric for grading forums: 60% – Initial Post; 20% – Each Response up to 2 posts
Please sign ALL your Forum posts with the name that you like to be called – it makes it so much easier for the rest of us to address you by your preferred name when we respond.

 
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “GURUH” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.