R = 3
please answer (d) and (e) 
HEA 4 93 # DER PO Calibri 11 V AF A TIX YO Y BTU Uw A * BE EN ATT 938 DG Casual 2 E G HI K 1 T T 1 J Within 3 months How Total Product Last Week Last Month F Ohsend Bracelet Necklace Esrires Column Tata Last Week Last Month within 3 month Row Total Expected Bracelet Necklace Earrings Calumn Total Last Week Last Month within 3 months Row Total Chi-square Bracelet Necklace Earrings Column Total p-value leveof denificance D Style Case Formal Formal Casual C.al Casal Canal CH Cal Casal Casal Formal Formal Formal Casal Formal Formal Formal Formal Formal Formal Formal Formal Formal Casal C Casual Canal Casal Formal romel Formal Formal Formal Formal 1 Last Order 2 Last Week 3 Last Month 4 Within 3 months s Within 3 months Last Month 7 Within 3 months B Within 3 months Within 3 months 10 Within 3 months 11 Last Week 12 Last Week 13 Last Week 4 Last Week 1s Last Week In Within 3 months 11 Within 3 months 18 Within 3 months Within 3 months 2 Last Month 21 Last Month 2 Within 3 months 23 Last Month 24 Within 3 months 23 Last Week 2 Last Week Last Week Last Week 29 Last Week 30 Last Week 31 Within 3 months 19 Within 3 months 33 Within 3 months 14 Within 3 months 35 within 3 months 36 Within 3 months 27 Last Month Within 3 months 3. Within 3 months 40 last week 41 Last Week Qualitative Critical Value Earrings Earrires Earrings Farrings Earrings Earrings Earrires Earrings Necklace Necklace Earrings Necklace Necklace Necklace Necklace Earrings Ferrires Earrings Earrings Bracelet Bracelet Bracelet Bracelet Bracelet Bracelet Bracelet Braceler Bracelet Earrings Necklace Necklace Necklace Bracelet Earrings Earrires Bracelet Bracelet Bracelet Bracelet Payment Bank Transfer Bank Transfer Bank Transfer Bank Transter Rank Trander Bank Transfer Bank Transfer Credit Card Credit Card Bank Transfer Bank Transfer Bank Transfer Credit Card Bank Transfer Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Bank Transfer Credit Card Credit Card Bank Transfer Rank Trance Credit Card Credit Card Credit Card Credit Card Credit Card Bank Transfer Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card + Formal Formal Formal Formal Quantitative IA 0 - + 100% D A B 1 Time spend on revising SEHH1071's test (in mins) 2 i 3 562 4 413 5 501 6 505 7 446 8 476 9 566 10 562 11 536 12 414 13 1200 14 469 15 516 16 521 17 596 18 486 19 544 20 496 21 518 22 590 23 430 24 509 25 525 26 570 27 501 28 432 29 470 30 522 31 584 32 515 33 586 34 585 35 850 36 568 37 444 38 780 39 565 40 407 41 518 42 585 43 435 44 559 45 545 46 580 47 491 48 500 49 860 50 556 51 448 3 3. The time spend on revising SEHH1071's test for ALL the students in course are shown in the sheet "Quantitative" in the file "IC3.xlsx. For Cell A2, fill it in with the value of [550R15). What can we conclude on the revision time by using the skewness" in the descriptive statistics? (5 marks) b) Base on the result in (a), use appropriate method to find the range for outlier identification. List all the outliers. (10 marks) Provide the five-number summary for the distribution. (5 marks) a) Find the 42nd percentile revision time. Show your calculations. (5 marks) The mean and the variance the score of the SEHH1071's test are 76 and 36 respectively. Which distribution has a higher variability? The revision time or the score of the SEHH1071's test? Show your calculations. (10 marks) in Provide one reason why variance/standard deviation is not enough for variability comparison in e)i). (5 marks) HEA 4 93 # DER PO Calibri 11 V AF A TIX YO Y BTU Uw A * BE EN ATT 938 DG Casual 2 E G HI K 1 T T 1 J Within 3 months How Total Product Last Week Last Month F Ohsend Bracelet Necklace Esrires Column Tata Last Week Last Month within 3 month Row Total Expected Bracelet Necklace Earrings Calumn Total Last Week Last Month within 3 months Row Total Chi-square Bracelet Necklace Earrings Column Total p-value leveof denificance D Style Case Formal Formal Casual C.al Casal Canal CH Cal Casal Casal Formal Formal Formal Casal Formal Formal Formal Formal Formal Formal Formal Formal Formal Casal C Casual Canal Casal Formal romel Formal Formal Formal Formal 1 Last Order 2 Last Week 3 Last Month 4 Within 3 months s Within 3 months Last Month 7 Within 3 months B Within 3 months Within 3 months 10 Within 3 months 11 Last Week 12 Last Week 13 Last Week 4 Last Week 1s Last Week In Within 3 months 11 Within 3 months 18 Within 3 months Within 3 months 2 Last Month 21 Last Month 2 Within 3 months 23 Last Month 24 Within 3 months 23 Last Week 2 Last Week Last Week Last Week 29 Last Week 30 Last Week 31 Within 3 months 19 Within 3 months 33 Within 3 months 14 Within 3 months 35 within 3 months 36 Within 3 months 27 Last Month Within 3 months 3. Within 3 months 40 last week 41 Last Week Qualitative Critical Value Earrings Earrires Earrings Farrings Earrings Earrings Earrires Earrings Necklace Necklace Earrings Necklace Necklace Necklace Necklace Earrings Ferrires Earrings Earrings Bracelet Bracelet Bracelet Bracelet Bracelet Bracelet Bracelet Braceler Bracelet Earrings Necklace Necklace Necklace Bracelet Earrings Earrires Bracelet Bracelet Bracelet Bracelet Payment Bank Transfer Bank Transfer Bank Transfer Bank Transter Rank Trander Bank Transfer Bank Transfer Credit Card Credit Card Bank Transfer Bank Transfer Bank Transfer Credit Card Bank Transfer Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card Bank Transfer Credit Card Credit Card Bank Transfer Rank Trance Credit Card Credit Card Credit Card Credit Card Credit Card Bank Transfer Credit Card Credit Card Credit Card Credit Card Credit Card Credit Card + Formal Formal Formal Formal Quantitative IA 0 - + 100% D A B 1 Time spend on revising SEHH1071's test (in mins) 2 i 3 562 4 413 5 501 6 505 7 446 8 476 9 566 10 562 11 536 12 414 13 1200 14 469 15 516 16 521 17 596 18 486 19 544 20 496 21 518 22 590 23 430 24 509 25 525 26 570 27 501 28 432 29 470 30 522 31 584 32 515 33 586 34 585 35 850 36 568 37 444 38 780 39 565 40 407 41 518 42 585 43 435 44 559 45 545 46 580 47 491 48 500 49 860 50 556 51 448 3 3. The time spend on revising SEHH1071's test for ALL the students in course are shown in the sheet "Quantitative" in the file "IC3.xlsx. For Cell A2, fill it in with the value of [550R15). What can we conclude on the revision time by using the skewness" in the descriptive statistics? (5 marks) b) Base on the result in (a), use appropriate method to find the range for outlier identification. List all the outliers. (10 marks) Provide the five-number summary for the distribution. (5 marks) a) Find the 42nd percentile revision time. Show your calculations. (5 marks) The mean and the variance the score of the SEHH1071's test are 76 and 36 respectively. Which distribution has a higher variability? The revision time or the score of the SEHH1071's test? Show your calculations. (10 marks) in Provide one reason why variance/standard deviation is not enough for variability comparison in e)i)
