I'm looking for how to evaluate & answer the question. Please provide the steps for how I can replicate it on Excel.

Part B BBT Managers are concerned that morale is suffering after the CEO created a number of new restrictive policies. One of the main complaints is lack of transparency. Employees believe that the CEO is making life harder on them out of spite rather than for sound business reasons. Managers believe that improving communication will help. They are conducting an experiment to see if sending a summary report that contains aggregate performance metrics and customer complaint statistics will improve employee understanding of the problems the CEO is facing. To test this hypothesis, employees in two similarly-sized departments were selected for the experiment. Department 1 is the control group. They did not receive the report. Department 2 is the Treatment group. They did receive the report. Survey Question Employee morale is excellent at BBT. (strongly disagree) 1 2 3 4 5 6 7 (strongly disagree) 4. Does the report significantly improve morale? Use ANOVA to ascertain whether or not the treatment worked. In your answer, please interpret the results and comment on the overall impact of the plan. 2 9 9 S S IN OOOWN 9 9 6 4 Respondent Control Treatment G 1 4 7 2 4 3 5 4 5 5 5 7 5 4 7 4 6 8 4 4 5 5 10 5 4 e 11 6 6 3 12 3 6 . 13 4 4 5 14 4 3 5 15 4 4 7 16 4 4 B 17 5 18 5 7 19 4 20 4 3 21 4 7 3 22 6 23 4 5 5 24 5 4 5 25 4 7 26 3 4 B 27 4 5 28 4 4 29 3 4 30 4 4 31 4 32 4 4 . 33 5 6 5 34 35 4 9 9 9 1 7 st m st 2. 4 4 I 5 9 9 9 5 36 37 5 3 4 4 5 4 5 5 4 Lo on 4 6 4 mLO 5 5 3 4 wn 4 3 5 4 5 3 3 5 L0mm 3 5 4 4 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 4 10 Lo 5 5 3 4 4 3 4 4 10 Lo 4 4 4 4 4 6 3 4 www 4 Aw 61 62 5 5 0000 won 3 5 5 3 3 4 4 5 3 6 6 5 3 4 5 5 3 m 10 88899903 4 5 63 64 65 66 67 68 69 70 4 3 4 6 4 6 4 4 +00m + 3 4 AN 4 3 4 4 5 5 9 01 s 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 5 4 4 5 2 5 3 5 S I S 0 00 N Nm 5 5 5 4 5 4 3 5 5 4 4 3 4 4 3 3 Fm mm + 68 4 5 4 3 3 3 6 4 5 5 4 LO 9 JI 3 6 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 6 5 4 5 4 5 4 5 5 4 4 5 5 - . m m + S 3 3 4 5 0 0 4 4 7 4 4 5 5 4 3 4 5 5 mm 3 UT st 3 5 5 in 6 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 3 5 6 4 4 3 4 3 6 5 4 5 5 6 4 4 4 4 3 3 5 5 5 4 4 5 3 3 6 7 3 3 5 4 5 5 5 mo st mmnnnn mm 4 3 3 6 4 3 6 5 6 3 5 2 4 3 6 7 3 4 5 7 6 3 NOU 9 mm 5 3 3 5 5 mm 141 142 143 144 145 146 147 148 149 vuuuu 3 4 6 4 4 3 3 6 5 w w 5 Part B BBT Managers are concerned that morale is suffering after the CEO created a number of new restrictive policies. One of the main complaints is lack of transparency. Employees believe that the CEO is making life harder on them out of spite rather than for sound business reasons. Managers believe that improving communication will help. They are conducting an experiment to see if sending a summary report that contains aggregate performance metrics and customer complaint statistics will improve employee understanding of the problems the CEO is facing. To test this hypothesis, employees in two similarly-sized departments were selected for the experiment. Department 1 is the control group. They did not receive the report. Department 2 is the Treatment group. They did receive the report. Survey Question Employee morale is excellent at BBT. (strongly disagree) 1 2 3 4 5 6 7 (strongly disagree) 4. Does the report significantly improve morale? Use ANOVA to ascertain whether or not the treatment worked. In your answer, please interpret the results and comment on the overall impact of the plan. 2 9 9 S S IN OOOWN 9 9 6 4 Respondent Control Treatment G 1 4 7 2 4 3 5 4 5 5 5 7 5 4 7 4 6 8 4 4 5 5 10 5 4 e 11 6 6 3 12 3 6 . 13 4 4 5 14 4 3 5 15 4 4 7 16 4 4 B 17 5 18 5 7 19 4 20 4 3 21 4 7 3 22 6 23 4 5 5 24 5 4 5 25 4 7 26 3 4 B 27 4 5 28 4 4 29 3 4 30 4 4 31 4 32 4 4 . 33 5 6 5 34 35 4 9 9 9 1 7 st m st 2. 4 4 I 5 9 9 9 5 36 37 5 3 4 4 5 4 5 5 4 Lo on 4 6 4 mLO 5 5 3 4 wn 4 3 5 4 5 3 3 5 L0mm 3 5 4 4 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 4 10 Lo 5 5 3 4 4 3 4 4 10 Lo 4 4 4 4 4 6 3 4 www 4 Aw 61 62 5 5 0000 won 3 5 5 3 3 4 4 5 3 6 6 5 3 4 5 5 3 m 10 88899903 4 5 63 64 65 66 67 68 69 70 4 3 4 6 4 6 4 4 +00m + 3 4 AN 4 3 4 4 5 5 9 01 s 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 5 4 4 5 2 5 3 5 S I S 0 00 N Nm 5 5 5 4 5 4 3 5 5 4 4 3 4 4 3 3 Fm mm + 68 4 5 4 3 3 3 6 4 5 5 4 LO 9 JI 3 6 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 6 5 4 5 4 5 4 5 5 4 4 5 5 - . m m + S 3 3 4 5 0 0 4 4 7 4 4 5 5 4 3 4 5 5 mm 3 UT st 3 5 5 in 6 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 3 5 6 4 4 3 4 3 6 5 4 5 5 6 4 4 4 4 3 3 5 5 5 4 4 5 3 3 6 7 3 3 5 4 5 5 5 mo st mmnnnn mm 4 3 3 6 4 3 6 5 6 3 5 2 4 3 6 7 3 4 5 7 6 3 NOU 9 mm 5 3 3 5 5 mm 141 142 143 144 145 146 147 148 149 vuuuu 3 4 6 4 4 3 3 6 5 w w 5