DESC 471 ONE OPEN NOTE TEST #1 120 MINUTES FALL 2011 NAME _____________________ TEST SCORE _________ CENTER: ENCINO HMWK% ________ SEM GRADE __________ w/RETEST=100 ________ USE PENCIL!! USE PENCIL!! USE PENCIL!! USE PENCIL!! USE PENCIL!! Show work for partial credit 1. (20 points) Answer the following questions: Circle the correct T/F answer. Don’t leave any questions uncircled! No penalty for guessing! (1 point each) a) T F If kurtosis is > 1, then the data must be exponential. b) T F The Interquartile Range (IQR) is Q3-Q1. c) T F There is no built-in Excel function for the range of a data set. d) T F Outliers have to be outside both the 6-sigma and Tukey limits. e) T F Pivot Tables are limited to a maximum of 10 rows and 10 columns. f) T F Frequency graphs can determine the mode, Box & Whiskers does not. g) T F The birth data from the Anaheim Ducks and Los Angeles Kings proved Outliers was correct. h) T F For the Hypergeometric distribution the value of p changes each time an object is selected. i) T F Heights of adult males is a good example of the Poisson distribution. j) T F When children give their age, it’s continuous; for adults it’s integer. k) T F If a LUMAT template cell is colored, you can enter data or labels. l) T F The Box and Whiskers template gives indicators of data being normal, uniform or exponential. m) T F Goodness of Fit templates use the Chi-square distribution to give the probability of a fit. n) LUMAT stands for: Learning to Use Managerial Analysis Templates. o) The name of our Excel Training program is ExcelEverest. p) If the pieces of a pie chart in Excel add up to only