s t a t i s t i c s- john uebersax（s t a t i s t i c s - john uebersax）.docVIP

Topics to Cover Frequency tables in Excel Central tendency: mean, median, mode Quartiles Descriptive statistics in JMP Measures of Dispersion(part 1) Homework assignment 1. Frequency Tables via Excel FREQUENCY() function In the previous lecture we learned how to make a frequency table for a quantitative variable via binning using the Excel Analysis ToolPak. Alternatively, one can use the Excel Frequency() function, as follows: Place data in one range (e.g., a1:a10) Place bins in another range (e.g., b1:b4) In another column, select vertical range of blank cells, which contains on