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.
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.
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.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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
