Calculate the missing values in yellow boxes of Tables 2 and 3 below and the annual cost avoidance of the building from the lighting retrofitting project based on the information provided in these tables. The cost avoidance must be reported with relative precision at a 95% confidence level (t = 1.96). Please show all related calculations.

Table 2. Baseline fluorescent lighting No. of Lamps Room No. of Fixtures Power (Watts) Operating Non-operating Mean difference Watt per operating lamp (Actual Watt per (Watt/lamp) lamp - Mean Watt per lamp Mean difference Squared 22 33 20 1 3 3.8521 -1.3384 1.1002 1 22 A B C D E F G H 1 Total 15 24 40 40 21 30 19 20 15 24 38 35 8 210 2 0 0 2 5 1320 1730 1142 1030 890 1450 2230 2130 477 12,399.00 62.86 57.67 60.11 51.50 59.33 60.42 58.68 60.86 59.63 0.3283 1.4116 -0.3208 1.8521 0.6200 14.84 1.79 1.21 56.33 0.11 1.99 0.10 3.43 0.38 10 226 2 16 Mean Wattage per lamp (Watt/lamp) Burnout Fraction Sample size, n.1 No. of lighting units (Total population) Estimated total burnout Estimated no of operating units Variance Standard deviations 59.01 7.62% 210 209 500 38 462 0.38366 Table 3. Post-Retrofit LED lighting No. of LED units Room No. of Fixtures Power (Watt) Operating Non-operating Watts per operating lamp (Watt/lamp) Mean difference (Actual Watt per lamp - Mean Watt per lamp) Mean differe Squared B 0 0 14.00 14.30 14.01 0.02 0.02 0.02 C D 0 O E F 22 33 20 22 15 24 40 40 10 226 22 33 20 22 15 24 40 40 10 226 0 0 308.00 471.90 280.20 330,00 210.30 324.00 520.00 SRR.00 148,90 3,181.30 -0.1578 0.1422 -0.1478 0.8422 -0.1378 -0.6578 1.1578 0.5422 0.7222 0 O 14.02 13.50 13.00 14.20 14.99 G H . Total 0.02 0.43 1.4 0.29 0.54 3.3986 O 0 Mean Wattage per lamp (Watt/lamp) Burnout Fraction Sample size, n n-1 No. of lighting units Total population) Estimated total burnout Estimated no of operating units Variance Standard deviation, 14.16 0.00% 226 2091 500 O 500 0.12752