o) 10:22 AM Sun Dec 1 II CI} 40% E} ASSIGNMENTS t to help you with calculations for the following questions/statements Step 4: Now use the W at Give
View the step-by-step solution to:

Question

PLEASE READ: The values selected are - 60,68,66,65,65,67,63,65,68,61

alt="F1667557-3B75-4D99-9714-93EA02EF004C.png" />F1667557-3B75-4D99-9714-93EA02EF004C.png




F1667557-3B75-4D99-9714-93EA02EF004C.png28AD25B8-68C4-4285-BD92-85A31A091FBE.pngPLEASE USE MY VALUES NOT THE ONES IN THE EXAMPLE-The values selected are - 60,68,66,65,65,67,63,65,68,61F1667557-3B75-4D99-9714-93EA02EF004C.pngF1667557-3B75-4D99-9714-93EA02EF004C.png

28AD25B8-68C4-4285-BD92-85A31A091FBE.png

o) 10:22 AM Sun Dec 1 II CI} 40% E} ASSIGNMENTS t to help you with calculations for the following questions/statements Step 4: Now use the W at Give a point estimate for the average height of all people at the place where you work. Start by putting the ten
heights you are working with into the blue Data column of the spreadsheet. What is your point estimate, and what does this mean? Put values In blue cells; output or answers in YELLOW cells
Enter values starting from BS cell _E Mean \
1 Sample Standard Devlation E b. Find a 95% confidence interval for the true mean height of all the people at your place of work. What is the interval? Enter input in blue cells ; Look for answers in yellow cells t or 2 Confidence Interval for [1 Confidence Level“ Enter decimal
n -1-
Mean
swam
pop stow“ Enter yes if population stdev known — Enter No if population stdev is unknown SE 0.924365
tn

F1667557-3B75-4D99-9714-93EA02EF004C.png

10:23 AM Sun Dec 1 4) Cl} 40% E} ASSIGNMENTS b. Find a 95% confidence interval for the true mean height of all the people at your place of work. What is the interval? Enter input in blue cells ; Look for answers in yellow cells C or 2 Confidence Interval for u
Confidence Level Enter decimal Enter yes if population stdev known
Enter No if population stdev is unknown 0.924365
2.262
2.090914
64.309086
68.490914 c. Give a practical interpretation of the interval you found in part b, and explain carefully what the output means. (For example, you might say, "I am 95% confident that the true mean height of all of the people in my company is
between 64 inches and 68 inches"). d. Post a screenshot ofyour work from the t value Confidence Interval for u from the Confidence Interval tab on the
Week 6 Excel spreadsheet Step 5: Now, find a 99% confidence interval for the same data. Would the margin of error be larger or smaller for the
99% Cl? Explain your reasoning. Step 6: Save the Week 7 Lab document with your answers and include your name in the title. Step 7: Submit the document. Grading

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes