1. In the Excel file New Account Processing, test the null hypothesis that the variance in the Close Ratio for the sample of employees is at most 1.5%. 2. In the Excel file Gasoline Prices, determine if there is evidence to conclude that the variance of weekly prices during 2009 is less than 10%. 3. Using the data in the Excel file Consumer Transportation Survey, test the following null hypotheses: a. Individuals spend at least 10 hours per week in their vehicles. b. Individuals drive an average of 450 miles per week. c. The average age of SUV drivers is no greater than 35. d. At least 75% of individuals are satisfied with their vehicles.