DATA MANAGEMENT ASSIGNMENT ' 1. Do the following question on EXCEL 0 These are the following math marks in Data Management Class: 76 78 87 65 67 84 8156 49 67 69 8185 72 73 64 54 63 69 57 83 74 79 77 6192 88 72 67 A) Mean - Average B) Median C) Mode D) Create a BOX and WHISPER PLOT by hand. E) 01, 02, 03 ' F) Percentile 40'h 80"I 90" G) VARIANCE H) STANDARD DEVIATION - Square root of variance I) Frequency table - choose your intervals (5 units) and Frequency Polygon J) Cumulative Frequency table and Graph K) Histrogram of Frequency 2. Decode the following message: L53 1&3] E3 33] [23 ii] [22 13'] [12 33] using the decoding matrix L21 _3]. O -2 4 3. A-[7 o] B= 9 '3 3 .FindAB. 2 1o 8. Use EXCEL to graph a linear regression for two variable stats. Age Annual Income a) Using the graph, describe the correlation between the (Years) (thousands of variables. 33 33 25 31 19 18 44 52 b) State the equation of the line. 50 56 54 c) State the correlation coefficient R2 and what does that 60 say about the line on the graph. 38 44 29 35 d) Are there any outliers? 9. Identify the most likely type of causal relationship for each situation, assuming that the first variable is the independent variable. Choose from one of the following: COMMON-CAUSE FACTOR, REVERSE CAUSE-AND-EFFECT RELATIONSHIP, ACCIDENTAL RELATIONSHIPS, AND PRESUMED RELATIONSHIP The rate of chemical reaction increases with temperature. Leadership ability has a positive correlation with academic achievement Two waffle-producing factories close due to fire, and the availability of waffles decrease. When you eat chocolate, you get a lot of acne. Heart attack rates drop as fitness clubs bring in more revenue. You do well on the Data test because you wear a red shirt. The price of butter and the fish population The correlation between coffee and anxiety levels.4. A) Construct the matrix A for the following network. B) Find A?. 5. a) What are the degrees of each node? b) Is the network traceable? B D 6. State the Sampling Technique used in each case. Choose from the following: SIMPLE RANDOM SAMPLE, SYSTEMATIC SAMPLE, STRATIFIED SAMPLE, VOLUNTARY RESPONSE SAMPLE, CONVENIENCE SAMPLE a) To do market research, a telemarketing firm randomly selected 100 names from a store's database and contacted them. b) To get reactions about a particular new car, readers of a car magazine were asked to mail in their answers to a survey. . c) A university polled 500 of its student, randomly selecting them proportional to the number of students enrolled in each degree program. d) A random starting point is chosen, followed by every nth individual. 7. State the type of BIAS for each. SAMPLING BIAS, NON-RESPONSE BIAS, RESPONSE BIAS, OR MEASUREMENT BIAS a) When a research company polls residents about their voting intentions, new Canadians are under-represented. b) A radio station asks its listeners to call in to answer a survey question on spending by politicians. c) In an experiment, the heights of participants was measured by two different laboratory O assistants