SECTION A You are given a data set about a batch of students who…
Question SECTION A You are given a data set about a batch of students who… SECTION A You are given a data set about a batch of students who registered for the subject, Business Mathematics (STA117). Use the data set to answer all the questions in this section. Note: You can download the excel file of the data set from Moodle, name of the file: “STA117 assignment data file”. You may use MS Excel or Google Sheets to do analysis required. Question 1 (20 Marks): (a) List all the variables presented in the data set given in appendix-1. By giving reasons, identify the type of data (qualitative or quantitative) and levels of measurement (nominal, ordinal, interval or ratio) for each variable listed. You may use a table form, as below, to answer this question. [18 marks] Image transcription text# Name of the Type of data Levels ofReason variables measurement 2… Show more (b) If you want to represent one of the variables from the data set as a pie chart, state one of the most suitable variables for this type of chart? Justify your reason. [2 marks] Question 2 (15 Marks): One of the variables given in the data set is “Tutorial Marks” for the 60 students registered for the subject STA117. Answer the following questions considering this variable: (a) Construct a frequency distribution for the data. (Use your own judgment as to the number of classes and class size.) [8 marks] (b) Construct any one of the following graphs for the frequency distribution in part (a):• Histogram • Frequency polygon • Ogive [4 marks] (c) Give an interpretation for your graph in part (b). [3 marks] Question 3 (15 Marks): For this question, you are required to perform correlation analysis for any two suitable variables of your choice from the data set, by answering the following questions: (a) State the two variables of your choice. Justify your reason for the choice of variables. [3 marks] (b) Compute the Pearson Product-Moment Correlation Coefficient (r) to determine the strength of the correlation between these two variables. Note: You are requested to use MS Excel or Google Sheets to calculate the Sum values used in correlation calculation. [8 marks] (c) Identify type of correlation and interpret the correlation coefficient to your answer to part (b) [4 mark] Question 4 (20 Marks): For this question, you are required to analyze and compare the Final Aggregate Marks of students belonging to different courses (BAF and BMKT). The following table is derived from the data set attached in appendix-1. (a) Find the quartiles for each group of students. [6 marks] (b) Construct boxplots for these data. [8 marks] (c) Using boxplots and any other relevant information, compare the performance of these two groups of students and determine which group of students performed better. (Hint: use interpretation for quartiles, center, variation and the distribution). [6 marks] Image transcription textAppendix -1 FINAL Tutorial AttendanceAssignment Final Exam CourseSection Gender Age Mark… Show more… Show moreImage transcription text24 BAF HUT Male 15 23 BAF HO1 Male 25-30 100 24 BAF H01 Male 20-24 FF 25 BAF H01 Female 20-24Achieved between 45-49% from Final exam (unaided assessment component), thus an 26 BAF H01 Male25-30 12 8 8 8 88 27 BAF H01 Male 20-24 Achieved less than 45% from Final exam (unaided… Show more… Show moreImage transcription text48 BMKT H02 Male 25-30 FC Did notget 50% from Final Examination(unaided assessment co… Show more… Show more Math Statistics and Probability Share QuestionEmailCopy link Comments (0)
