PLEASE ONLY ANSWER THIS QUESTION:

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	fill in the blank 7	fill in the blank 8
1	fill in the blank 9	fill in the blank 10	fill in the blank 11
2	fill in the blank 12	fill in the blank 13	fill in the blank 14
3	fill in the blank 15	fill in the blank 16	fill in the blank 17
4	fill in the blank 18	fill in the blank 19	fill in the blank 20
5	fill in the blank 21	fill in the blank 22	fill in the blank 23
6	fill in the blank 24	fill in the blank 25	fill in the blank 26
7	fill in the blank 27	fill in the blank 28	fill in the blank 29
8	fill in the blank 30	fill in the blank 31	fill in the blank 32
9	fill in the blank 33	fill in the blank 34	fill in the blank 35
10	fill in the blank 36	fill in the blank 37	fill in the blank 38

plan it

Video 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. X Open spreadsheet Questions: 1. Calculate the mean of the data. Round your answer to three decimal places. 25.498 $ 2. Calculate the median of the data. Round your answer to three decimal places. 25.400 g 3. Calculate the standard deviation of the data. Round your answer to three decimal places. 0.018 g 4. Find the minimum and maximum of the data. Round your answers to two decimal places. Minimum: 25.37 g Rack Autosaved at 8:25 PM Neyt E Arial 10 B v v Av ... abe Number $ 60 .00 .00 0 N5 y fx B D E F G H I K L M N 0 P Q R Statistical Analysis Formulas DATA 50 5 GREGOVOUSWN 1 2 3 4 5 1 2 3 4 25.39 25.39 25.42 25.41 25.37 25.42 25.37 25.37 25.40 25.39 25.41 25.40 25.41 25.41 25.42 25.40 25.39 25.42 25.42 25.40 25.41 5 25.37 25.37 25.37 25.37 25.37 6 7 8 25.39 25.40 25.42 25.37 25.39 25.41 25.37 25.41 25.41 25.41 25.42 25.42 25.42 25.42 25.40 9 25.37 25.39 25 37 25.42 25 41 10 25.42 25.42 25.37 25.41 25.40 Count Mean Median Standard Deviation Minimum Maximum #N/A #N/A #N/A #N/A #N/A 11 Use the area below to construct a histogram. Frequency Distribution and Histogram Number of Cells Lower limit Upper limit 7 25.350 25.420 Cell width #N/A Cell From 0 To (inclusive) 1 1 2 3 4 Frequency 0 50 #N/A #NA #N/A #N/A #N/A #N/A #N/A #N/A #N/A 10 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Cell From 0 #N/A DAWN- #N/A #N/A #N/A #N/A #N/A #N/A #/ #N/A #N/A #N/A To (inclusive) #N/A #N/A #N/A #N/A #N/A #N/A # #N/A #N/A #N/A #N/A #N/A # Frequency {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) {=FREQUENCY(B5:K9,020:030) F 9 10 F = Sheet1 +