2. Basic Descriptive statistics 2. Basic Descriptive statistics A quality characteristic of interest for a tea-bag-filling process is the weight of the tea in the individual bags. If the bags are un a. Compute the arithmetic mean and median using Excel functions or Data Analysis Descriptive Statistics. b. Compute the first quartile and third quartile using Excel function =QUARTILE.EXC (QUARTILE if your version of Excel is older t c. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation in percent format. d. Show your understanding of statistics. You are a consultant brought in by the company. Consider the mean weight per bag. e. Consider the results of part c. Should the company producing the tea bags be concerned about variation? 5.85 5.57 5.67 5.67 5.68 5.74 5.50 5.40 5.56 5.45 5.42 5.53 5.47 5.42 5.44 5.40 5.54 5.61 5.58 5.25 5.53 5.55 5.53 5.59 5.56 5.34 5.68 5.32 5.50 5.63 5.54 5.66 5.70 5.39 5.50 5.45 5.48 5.30 5.50 5.57 5.52 5.64 5.49 5.53 5.67 5.41 5.51 5.55 5.58 5.36 dual bags. If the bags are under filled, two problems arise. First, customers may not be able to brew the tea as strong as they wish. Secon your version of Excel is older then 2010). on in percent format. er the mean weight per bag. How much extra tea is bagged per hour? Why should the company producing the tea bags be concerned abou t variation? as strong as they wish. Second, the company may be in violation of the truth-in-labeling laws. In this example, the label on the package in e tea bags be concerned about the central tendency? e, the label on the package indicates that, on average, there are 5.5 grams of tea in a bag. If the average amount of tea in a bag exceeds th ount of tea in a bag exceeds the label weight, the company is giving away product. Getting an exact amount of tea in a bag is problematic b f tea in a bag is problematic because of variation in the temperature and humidity inside the factory, differences in the density of the tea, a ces in the density of the tea, and the extremely fast filling operation of the machine (approximately 170 bags a minute). The data in colum a minute). The data in column O provides the weight in grams of a sample of 50 bags produced in one hour by a single machine: by a single machine