Please use Excel corresponding functions to complete the following questions. You just need to submit your Excel spreadsheet showing functions and answers to HW_04. 1. Suppose that the weight of a typical American female follows a normal distribution with p = 140 lb. and o' = 20 lb. Also, suppose 80.15% of all American females weigh more than I weigh. a. What fractions of American females weigh more tlian 165 pounds? b. How much do I weigh? c. If I weighed 20 pounds more than I do, what percentile would Ibe in? 2. A production process manufactures items with weights that are normallg,r distributed with mean 10 pounds and standard deviation 0.1. An item is considered to be defective if its weight is less than 9.8 pounds or greater than 10.2 pounds. Suppose that these items are currently produced in batches of 1000 units. a. Find the probability that at most 5% of the items in a given batch will be defective 1). Find the probability that at least 85% of these items in a given batch will be