Essential Statistics

In your textbook, Essential Statistics, review: Chapter 8, Section 1: “Basics of Hypothesis Testing” Chapter 8, Section 2: “Testing a Claim about a Proportion” Chapter 8, Section 3: “Testing a Claim about a Mean” Watch the video “Hypothesis Testing” explaining the Excel skills that you will need to complete the problems. Note that the version of Excel presented in the videos may be different than the one you are using. Complete the 10 problems in the file WS4Homework (Excel). There is a separate tab (worksheet) for each problem. Be sure to state your conclusions (interpretations) using business terms. Save your exercises as a single Excel file with one worksheet for each completed exercise. Name the file WS4Homework.xlsx and title your submission WS4 Homework. When you’ve completed your assignment, save a copy for yourself and submit a copy to your instructor using the Assignment submission page by the end of the workshop