EXCEL OPERATION. The formula entered should be able to autofill to the rest of the records displayed in this assignment and built in function must be included.

R=2

Q4a(Nominal, Ordinal, Interval, Ratio)

Q4c(descriptive statistics or inferential statistics)

Question 1 The table below shows the records of different students for University applications. A 1 2 Mary, MKT, 3.48 PU 3 Tim, IT, 3.58 Star 4 Alex, NS, 3.90 Staru 5 Karen, ENG, 3.56 Smart 6 Tracy, HM, 3.78 SmartU 7 Ryan, TM, 3.89 PU 8 Crystal, NS, 3.44 Bright 9 Kit, ACC. 3.89 PU 10 Howard, CHEM, 3.67 Bright! 11 David, BIO, 3.78 Smart B Name Mary Tim Alex Karen Tracy Ryan Crystal Kit Howard David C GPA 3.48 3.58 3.90 3.56 3.78 3.89 3.44 3.89 3.67 3.78 D Target PU Staru Start Smart Smart PU Bright PU Bright Smart E Major MKT IT NS ENG HM TM NS ACC CHEM BIO The labels (in Column A) of the students are standardized in this format: 4 Name(comma)(space)Major(comma)(space)GPA(space)Target Note: The length of the Name, Major and Target vary from student to student while the GPA decimal places. - at 2 In each part of this question, the underlined letter R represents the corresponding number in the following table according to the 5th digit of your student ID. 4 5th digit of Student ID 02 22 32 52 6 7 82 94 R 2 32 52 6 7 8 94 104 112 44 7 &] 7 Write down what should be entered exactly in Row R of Column B for displaying the Name" of the student; (5 marks) b) Row R of Column C for displaying the GPA of the student; (10 marks) Page 1 of 4k c) Row R of Column D for displaying the Target" of the student; and (10 marks) d) Row R of Column E for displaying the Major of the student; (15 marks) Question 4 a) Determine the levels of measurement for the following variables. (20 marks) i) GPA of the students ii) iii) Major of the students Satisfaction level towards the online application system (Satisfied, Neutral, Unsatisfied)- Time for interview (e.g. 8:30am...) iv) i) ii) iii) iv) b) Which of the following is the population of a study about the view of the users over the quality of the network connection during the admission interview in Smart University? (5 marks i) All the students in Smart University ii) All the selected students in the admission interview iii) Applicants of the Smart University iv) All the applicants attending the admission interview in the Smart University 4 Ans: c) Determine whether each of the following statements is a descriptive statistics or an inferential statistics.- (10 marks i) The admission tutor of the Smart University predicts that the number of applications will increase by 10% in the coming year. ii) A student said that the lowest GPA of his friend being admitted to Smart University was 3.58. 4 i) ii) Question 1 The table below shows the records of different students for University applications. A 1 2 Mary, MKT, 3.48 PU 3 Tim, IT, 3.58 Star 4 Alex, NS, 3.90 Staru 5 Karen, ENG, 3.56 Smart 6 Tracy, HM, 3.78 SmartU 7 Ryan, TM, 3.89 PU 8 Crystal, NS, 3.44 Bright 9 Kit, ACC. 3.89 PU 10 Howard, CHEM, 3.67 Bright! 11 David, BIO, 3.78 Smart B Name Mary Tim Alex Karen Tracy Ryan Crystal Kit Howard David C GPA 3.48 3.58 3.90 3.56 3.78 3.89 3.44 3.89 3.67 3.78 D Target PU Staru Start Smart Smart PU Bright PU Bright Smart E Major MKT IT NS ENG HM TM NS ACC CHEM BIO The labels (in Column A) of the students are standardized in this format: 4 Name(comma)(space)Major(comma)(space)GPA(space)Target Note: The length of the Name, Major and Target vary from student to student while the GPA decimal places. - at 2 In each part of this question, the underlined letter R represents the corresponding number in the following table according to the 5th digit of your student ID. 4 5th digit of Student ID 02 22 32 52 6 7 82 94 R 2 32 52 6 7 8 94 104 112 44 7 &] 7 Write down what should be entered exactly in Row R of Column B for displaying the Name" of the student; (5 marks) b) Row R of Column C for displaying the GPA of the student; (10 marks) Page 1 of 4k c) Row R of Column D for displaying the Target" of the student; and (10 marks) d) Row R of Column E for displaying the Major of the student; (15 marks) Question 4 a) Determine the levels of measurement for the following variables. (20 marks) i) GPA of the students ii) iii) Major of the students Satisfaction level towards the online application system (Satisfied, Neutral, Unsatisfied)- Time for interview (e.g. 8:30am...) iv) i) ii) iii) iv) b) Which of the following is the population of a study about the view of the users over the quality of the network connection during the admission interview in Smart University? (5 marks i) All the students in Smart University ii) All the selected students in the admission interview iii) Applicants of the Smart University iv) All the applicants attending the admission interview in the Smart University 4 Ans: c) Determine whether each of the following statements is a descriptive statistics or an inferential statistics.- (10 marks i) The admission tutor of the Smart University predicts that the number of applications will increase by 10% in the coming year. ii) A student said that the lowest GPA of his friend being admitted to Smart University was 3.58. 4 i) ii)