Hello, can someone please help me with this business statistics question?

I am struggling to understand please help ASAP!

Many innovative and inclusive teaching practices require taking risks. However, not all academics are in the privileged position to take any risks, especially if they are sessional or early in their careers, and student ratings can negatively impact their career prospects. An educational researcher is interested in whether an educational inclusive teaching lorum could improve risk taking by junior academics. The forum includes knowledge and activities about the benefits of inclusive learning and teaching at Ma cquari e University. The researcher randomly samples 35junior academics and asks them to fill a survey before the inclusive teaching forum. Each academic is asked to give a risktaking score from 1 [extremely consenmtive) to 'ID (risk-seeker) beforethe teaching forum. Three months after the inclu 've teaching forum, the same group of junior academics is asked to reflect on their teaching practices and and answer the survey questions by using the same risk-taking questions which they answered before they attended the forum. All data were recorded in Incl TeachingFommxlsx. Download and open this file in Excel. Use Excel to undertake a hypothesis test to address the research question below. Research Question: "Does attending an inclusive teaching fomm make a difference to average risk-ta king scores of junior academics at Macquarie university?" Figure 1: Before the forum Figure 2: After the forum 2 , 2 , E o _ E o _ 2 V 3 f 5 3 u. u. In _ m _ l_ii c , o , lllI llll A 5 s 7 B A 5 6 r 6 Risk scores Risk scores Figure 3: Before - Alter Fi ure 4: Box lots 0 m cu l g . - , ~ - E 3 8 l g 9 A g a A 4'7 4ti it E i i l o , q , t l l l l l l l l l l 4.5 4.0 72.5 72.0 .15 .1,\" a 5 no Before the forum Afterthe forum Dierences Risk scores Use your Excel output, and any appropriate plots provided to answer the following questions. For each question, either choose the most correct option, or type in the answer to the number of decimal places specified. 1 . (1 mark) The most appropriate test for these data is 9 2. (1 mark) Which graphical display would be useful to check nomiality assumption for this hypothesis? 0 A. Figure 'I B. Figure 2 C. Figure 3 D. Figure 4 E. Figure 'I & 2 F. Figure 3 8r 4 G. No need to check normality assumption H. All four figures are needed 3. (1 mark) How can you check the assumption of equal variances? 0 A. Comparative boxplots could be used [e.g. if the sizes of boxes are similar or not) B. Descriptive statistics such as variance, standard deviation and range could be used C. Descriptive statistics such as mean and median could be used D. The histogram of differences could be used E. Both A & 3 could be used F. No need to check the assumption of equal variances For the remaining questions you may assume that any relewrnt assumptions have been met. 4. (2 marks) The absolute value of the test statistic is equal to (Slip) 5. (1 mark) The degrees of freedom is equal to (Integer) o 6. (1 mark) The p-value is larger than 0.05 7. (2 marks) The test shows that the risk scores were 0 A. significantly different before and after attending the inclusive learning and teaching forum, possibly er before atten dinI the forum. B. significantly different before and after attendinI the inclusive Ieaming and teaching forum, possibly higher after attending the forum. C. not significantly different before and alter attending the inclusive learning and teaching forum AutoSave . OFF InclusiveTeachingForum (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ab Wrap Text v General Insert v O Ex Delete v Paste BIUV MVAv E = FE Merge & Centre v $ ~ % 9 Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Q v Filter Select Data x Office Update To keep up to date with security updates, fixes and improvements, choose Check for Updates. Check for Updates 05 X fx C D E F G H K L M N O P Q R S U V Before_forum_RiskScores After_forum_RiskScores 6 7.2 4.1 6.7 5.2 7.3 6 6.9 5.1 49 6.2 4.9 6.8 4 6.9 6 6.1 5.3 7.1 4.8 6.7 5 7.4 5 8.5 5.2 6.9 5.8 6.8 6 7.5 4.6 7.8 5.2 6.5 4.5 6.3 5.2 7.2 5 .1 7.4 5.5 6.8 4.8 5.1 7.1 5.7 6.5 5 7.7 5.7 6.8 5.4 7.2 5 7.8 5.3 8.5 4.1 6.9 4.2 7.2 5.2 5.9 4.8 6.7 5 7.9