Using Excel For Data Analysis This Assignment Is About Using Your Statistical Knowledge and Applying It To Real World Issues Home Work Excel Assignment: Using The Data Below Answer The Following Questions:

INPUT ID$ Vocab100 Vocab50 Math Type$;

CARDS;

A1 54 42 75 M

A2 92 40 70 F

A3 78 48 90 F

A4 72 46 50 M

A5 54 50 92 F

A6 44 48 70 F

A7 96 50 92 F

A8 40 48 70 M

A9 58 48 73 F

A10 90 44 0 F

A11 10 40 88 M

A12 70 48 86 M

A13 90 46 96 M

A14 78 44 92 M

A15 92 48 88 M

A16 92 44 95 M

A17 82 38 88 F

A18 100 50 86 M

A19 86 50 82 F

A20 50 82 82 F

A21 32 40 82 F

A22 86 50 95 F

A23 44 44 95 F

A24 90 42 78 M ;

RUN; 1) What Are The Means and Standard Deviations For Vocab100, Vocab50 and Math Scores? 2) Build a 95% Confidence Interval For The Variable Math? 3) Assuming The Variable Math Is Normal, What Is The Probability Of A Student Score Being Lower Than 50? 4) What is the Central Limit Theorem and Why Is It Important?