A manufacturer is interested in determining whether it can claim that the boxes of detergent it sells contain, on average, more than 500 grams of detergent. From past experience the manufacturer knows that the amount of detergent in the boxes is approximately normally distributed. The firm selects a random sample of 100 boxes and records the amount of detergent (in
grams) in each box. These data are provided in the file P10_02.xlsx. Formulate an appropriate hypothesis test and report a p-value. Do you find statistical support for the manufacturer's claim? Explain.
Step by step method for testing the hypothesis under 5 step approach is discussed here. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems.