Resources (Read-Only)
Textbook: Essentials of Statistics (attached)
Video: Hypothesis Testing (Youtube Video Available Online)
File: WS4Homework (Excel) (Attached below)
Instructions (Follow Carefully)
(1) In your textbook, Essential Statistics, review:
(a) Chapter 8, Section 1: ?Basics of Hypothesis Testing?
(b) Chapter 8, Section 2: ?Testing a Claim about a Proportion?
(c) Chapter 8, Section 3: ?Testing a Claim about a Mean?
(2) 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. (Youtube Video Available Online)
(3) 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.
(4) 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.