AutoSave OFF AH ? CE ... 2 HW-2 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) AA D Wrap Text General Paste BIU v A Merge & Center v v % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data M4 X V fx B C D E F G H M N 0 P Q R S For the variables IQ and Sodium: 1) Find the mean, median and Standard deviation (Round off to one decimal) (3 pts.) 1Q Sodium Mean Median 10 SD 11 12 13 2) Find the percent difference. Compare mean and median. (2 pts.) % diff Compare 16 17 3) Construct a Frequency Distribution using 9 classes . (6 pts.) 1Q Class Boundaries Sodium Class Boundaries 18 4) Find Relative frequency Distributuon (%f) (2 pts.) 19 5) Find Class Boundaries (3 pts. 20 5) Construct a frequency histogram (hand draw - Lable all axes and send as pdf) (6 pts.) 21 7) Describe the shape of histogram. (2 pts.) 22 23 3) Find Q1, Q3, LB, and UB (6 pts.) 24 ) Are there any outliers? Explain. (2 pts.) 25 10) Construct a Box-Plot. Label all axes. ( Use excel or hand draw) (6 pts.) 26 11) Describe the shape of Box Plot. (2 pts.) 27 28 12) Construct a QQ plot .. Show all work on QQ Sheet . Excel only. (8 pts.) 9 13) Describe the shape of QQ Plot. (2 pts.) Histogram Shape IQ Sodium 30 IQ Sodium Q1 Q3 LB UB Outliers? Box Plot Shape IQ Sodium QQ Plot Shape 1Q Sodium HW2-Data HW2-Questions-Answers QQ + Ready 100%