Excel Online Activity: Statistical Analysis

The La Ventana Window Company manufactures original equipment and replacement windows for residential building and remodeling applications. In a cutting pro a certain window model, specifications call for a dimension of $25\mathrm{.}50$ inches. If the dimension is larger than $25\mathrm{.}52$ inches, it will be too tight in assembly; and if it is inches or less, it will be too loose and will not meet customer requirements. The plant manager collected a sample of $50$ parts from this process and measured the dimensions. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions $b$