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, copy the original problem, describe what you did and give the mean, standard deviation and confidence interval. Then attach the excel spreadsheet below so students and the professor can check your work.
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your paper.
Write My Essay For MeExample 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.norm(.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 copying the problem, explaining all work and giving the solutions to 2 classmates problems. On each you will attach your excel spreadsheet showing your work. Pick 2 students who do not have responses if possible.
Do you find yourself approaching a tight assignment deadline? We have a simple solution for you! Just complete our order form, providing your specific instructions. Rest assured that our team consists of professional writers who excel in their respective fields of study. They utilize extensive databases, top-notch online libraries, and up-to-date periodicals and journals to ensure the delivery of papers of the utmost quality, tailored to your requirements. Trust us when we say that thorough research is conducted for every essay, and our expertise in various topics is unparalleled. Furthermore, we have a diverse team of writers to cover a wide range of disciplines. Be assured that all our papers are created from scratch, guaranteeing originality and uniqueness.
Write my essays. We write papers from scratch and within your selected deadline. Just give clear instructions and your work is done
