Reference no: EM13701185

Planning to study for your statistics examination with a group of classmates, one of whom you particularly want to impress. This student has volunteered to use Microsoft Excel to get the needed summary information, tables, and charts for a data set containing several types of variables assigned by the instructors for study purposes.
This student comes over to you with the printout and exclaims: "I've got it all: the means, the medians, the standard deviations, the box-and-whisker plots, the pie charts--for all of our variables! The problem is, some of the output looks weird...like the box-and-whisker lots for gender and for major area of study....and the pie charts for grade point average and for height.
Also, I can't understand why Professor Krehbiel said we can't get the descriptive stats for some of the variables. I got them for everything! See: the mean for height is 68.23, the mean for grade point average is 2.76, the mean for gender is 1.50, and the mean for major area of study is 4.33."