HEC104: Economic Statistics Assignment: 1 Due date: Friday 26"March 2022 Marks: 60 Weighting: 6% NOTE: YOU MUST USE MICROSOFT EXCEL TO DO THIS ASSIGNMENT! 1. The National University of Samoa Student Association conducted a student survey on the costs of readers at the NUS bookstore. The wording of the survey is, "The bookstore's prices of readers are reasonable." The responses are: 1. Strongly disagree 2. Disagree 3. Neither agree nor disagree 4. Agree 5. Strongly agree The responses for a group of 115 students were recorded. Graphically summarize these data and report your findings. student response student | response student response student |response student response student |response 3 21 2 4 5 8 10 2 1 22 42 62 82 102 23 43 63 83 103 2 -- 4 24 44 64 84 104 VOU AWN 25 85 105 3 86 106 4 107 1 UI AWNUTA 88 108 5 N N W A 109 - UI A UI W N - - N 5 110 3 11 A - N A W - A UI N - CI A W A UI N 112 2 13 114 2 58 8 9 8 8 8 8 8 9 8 8 - WANWAU- 115 CA WN - - C N - - W - A UI N N - - -2. The Student Support Service of the NUS regularly surveys the graduates one year after graduation and asks for the following information. For each, determine the type of the data. a) What is your occupation? (2 marks) b) What is your income? (2 marks) c) What degree did you obtain? (2 marks) (1) What is the amount of your student loan? (2 marks) e) How would you rate the quality of instruction? (2 marks) (excellent, very good, good, fair, poor) 3. You will be analyzing the ofcial result for the SSLC Mathematics Examination Result 2021. The Excel Data is attached separately. 1) Use Sturges Formula to determine the number of class intervals; (5 marks) 2) Determine the class Width (5 marks) 3) Give a frequency table for the data (5 marks) 4) Plot a 'COLUMN GRAPH' for the data (5 marks) 5) Which class interval do most student marks lie? (5 marks) 6) Can you give one (1) reason why student marks are low and one (1) recommendation as to how to improve the result for Mathematics (answer from your experience when you took this subject) (5 marks) 7) Give a comment regarding the shape of the column graph (skewness, normal) (5 marks) 8) Briey summarize your ndings