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 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 it is 25.38 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 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: 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. 6. Choose the correct histogram for the data. Frequency 25 20 15 B. 10 5 Fresuency Cell Upper Limit Cell Upper Limit 25 20 15. D. 10 5 0 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 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 it is 25.38 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 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: 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. 6. Choose the correct histogram for the data. Frequency 25 20 15 B. 10 5 Fresuency Cell Upper Limit Cell Upper Limit 25 20 15. D. 10 5 0
