Please solve this. Will write you good review.

Please use sample data provided in the following table to answer questions on this assessment. Unless required otherwise, round answers to three places after the decimal point, and assume that all hypothesis tests are two-tailed and based on 0.05 level of signicance. For between-group mean comparisons, assume equal variances across groups. After entering the data into the computer, verify that there was no data entry error by computing sample mean and sample standard deviation of each variable in yourworksheet. These should be identical to statistics provided in the last two rows of the data table. Rut/mil RAIN/ll]! Wt'i'irlitl (mm/J 1 7 2 130.3 158.8 Manager 2 7 2 160.8 154.0 Supervisor 3 2 1 146.7 137.1 Employee 4 7 0 142.5 153.1 Supervisor 5 6 1 139.2 144.8 Employee 6 8 5 146.8 146.8 Supervisor 7 10 7 149.4 153.7 Supervisor 8 3 6 172.4 146.9 Manager 9 7 0 132.7 147.7 Supervisor 10 6 0 154.1 160.3 Manager 11 10 4 159.4 154.8 Employee 12 1 1 145.1 134.6 Employee 13 4 5 148.3 142.0 Manager 14 s 4 139.2 149.2 Employee 15 7 8 146.5 145.0 Manager 16 6 0 153.0 146.3 Manager 17 5 7 142.5 154.1 Supervisor 18 3 8 156.0 162.1 Employee 19 9 4 144.4 147.1 Supervisor 20 6 5 146.4 137.8 Supervisor 21 5 0 146.8 133.6 Employee 22 6 2 141.4 155.5 Manager 23 9 0 149.6 159.4 Supervisor 24 7 2 153.1 140.6 Manager 25 6 3 140.1 140.1 Manager 26 5 2 156.2 148.0 Manager 27 5 2 152.2 156.1 Employee 23 5 0 162.4 139.0 Manager 3 4 1 135.2 169.6 Manager 30 1 0 0 148.7 146.2 Suirvlsor Create a new variable called Index such that Index = Rating1 + Rating2 + Weight1 + Weight2 . The median value of Index for Employees is: 302.113 O 305.690 O 295.200 305.100