1. Compute the mean, median, variance, and standard deviation using the appropri

1. Compute the mean, median, variance, and standard deviation using the appropriate Excel functions for all the variables in the Excel file National Football League. Note that the data represent a population. Apply the Descriptive Statistics tool to these data, what differences do you observe? Why did this occur? 2. The Excel file Student Grades provides information about the performance of students in a midterm examination and in a final exam. a. Considering these data as a sample from the population of all students in this institution, compute the mean, variance, and standard deviation for each of these variables using the formulas (2.A2), (2.A5), and (2.A7). b. Compute the coefficient of variation for both midterm and final exam scores. Which one has the greater relative dispersion?

You may also like