The La Ventana Window Company manufactures original equipment and replacement windows for residential building and remodeling applications. In a cutting process for a certain window model, specifications call for a dimension of 25.40 inches. If the dimension is larger than 25.42 inches, it will be too tight in assembly; and if is 25.38 inches or less, it will be too loese and will net meet customer requirements. The plant manager collected a sample of 50 parts frem 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 below. Open spreadsheet Questions: 1. Calculate the mean of the data. Round your answer to three decimal places. 2. Calculate the median of the data. Round your answer to three decimal places. 3. Calculate the standard deviation of the data. Round your answer to three decimal places. 4. Find the minimum and maximum of the data. Round your answers to two decimal places. Minimum: Maximum: 5. Construct the frequency distribution for the data. For calculating the cell width assume 7 cells, the lower limit of 25.35 inches and upper limit of 25.42 inches. Round your answers for interval boundaries to three decimal places and round your answers for frequencies to the nearest whole number. Cell From To (inclusive) Frequency 0 o 1 3 2 3 4 5 6 7 8 9 6. Choose the correct histogram for the data. The correct histogram is[ w2 ). Frequency 13 A, 10 I I o _ _ 25360 25.370 25.380 25390 25.400 25410 25420 25.430 25440 25450 Cell Upper Limit =] @ Frequency 13 B. 10 | I 0 25360 25370 25.380 25.390 25.400 25.410 25420 25.430 25.440 25.450 Cell Upper Limit @ \f