For each of the problems unless stated otherwise. First state what is given in the problem and the formula needed to calculate the problem. Then calculate the problem both by hand and in excel. Copy and past the formula used in excel. Make sure the answers are easy to identify in both sections. By completing the questions by hand and in excel it provides a double check on your work.

1. The amount of tea leaves in a can from a production line is normally distributed withm= 110 grams ands= 25 grams. A sample of 25 cans is to be selected. What is the probability that the sample mean will be less than 105 grams? (4 pts)

Given

Formula to solve problem

Excel

Hand calculation