HELP! LOST! Need help on an excel assignment involving histograms.

Ch05a Histogram Assignment It is very important to accomplish, save and submit each of the chapter 05 homework assignment sets in separate workbook files and submit to the appropriate dropbox. Each homework set will have individual and separate grades. prob 5.8 (Ch05, exercise 8, p54) data file: 4462-Ch05data.txt Develop the histogram for the time readings using Sturgis rule, set up the table of cell boundaries and midpoints, use upper boundaries as the "Bin" and plot the Histogram on the same sheet with the data, making refinements to include correcting the Historgram routine output with proper values for midpoint, appropriate levels of precision and proper labeling including titles. Provide on a single worksheet: . The data (DO NOT "CREATE A TALLY SHEET") rather use the Histogram routine under Data Anaylsis. You may have to activate the Analysis ToolPak" in Add-ins . The table that includes boundries, midpoints, cumulative frequency, relative cumulative frequency . And the Histogram (Excel column chart with cumulative relative frequency as a line chart using a secondary axis). . Include meaningful titles, labels, and reasonable levels of precision. Also, comply with the 3/4 rule. Presentation is at least 10% of the sc Don't forget the text box that provides your observations, interpretations and recommendations. Exercise 5.8 Bospital time study DAY Duration of operation time (Minutes) 1.90 1.93 1.95 2.05 2.20 1.76 1.81 1.81 1.83 2.01 1.80 1.87 1.95 1.97 2.07 1.77 1.83 1.87 1.90 1.93 1.93 1.95 2.03 2.05 2.14 1.76 1.88 1.95 1.97 2.00 1.87 2.002.00 2.03 2.10 1.91 1.92 1.94 1.97 2.05 1.90 1.91 1.95 2.01 2.05 1.79 1.911.931.94 2.10 1.90 1.97 2.002.062.28 1.80 1.821.891.91 1.99 1.751.831.92 1.95 2.04 1.87 1.901.98 2.00 2.08 1.90 1.95 1.95 1.97 2.03 1.82 1.99 2.01 2.06 2.06 1.901.951.952.00 2.10 1.811.901.94 1.971.99 1.871.891.98 2.012.15 1.721.78 1.96 2.00 2.05 1.87 1.89 1.911.91 2.00 1.761.801.912.06 2.12 1.95 1.961.97 2.00 2.00 1.92 1.941.97 1.99 2.00 1.851.901.90 .921.92 2 3 2 5 6 7 9 0 10 12 12 14 14 16 16 9 18 18 19 19 20 20 21 21 23 23 24 24 25 25 Ch05a Histogram Assignment It is very important to accomplish, save and submit each of the chapter 05 homework assignment sets in separate workbook files and submit to the appropriate dropbox. Each homework set will have individual and separate grades. prob 5.8 (Ch05, exercise 8, p54) data file: 4462-Ch05data.txt Develop the histogram for the time readings using Sturgis rule, set up the table of cell boundaries and midpoints, use upper boundaries as the "Bin" and plot the Histogram on the same sheet with the data, making refinements to include correcting the Historgram routine output with proper values for midpoint, appropriate levels of precision and proper labeling including titles. Provide on a single worksheet: . The data (DO NOT "CREATE A TALLY SHEET") rather use the Histogram routine under Data Anaylsis. You may have to activate the Analysis ToolPak" in Add-ins . The table that includes boundries, midpoints, cumulative frequency, relative cumulative frequency . And the Histogram (Excel column chart with cumulative relative frequency as a line chart using a secondary axis). . Include meaningful titles, labels, and reasonable levels of precision. Also, comply with the 3/4 rule. Presentation is at least 10% of the sc Don't forget the text box that provides your observations, interpretations and recommendations. Exercise 5.8 Bospital time study DAY Duration of operation time (Minutes) 1.90 1.93 1.95 2.05 2.20 1.76 1.81 1.81 1.83 2.01 1.80 1.87 1.95 1.97 2.07 1.77 1.83 1.87 1.90 1.93 1.93 1.95 2.03 2.05 2.14 1.76 1.88 1.95 1.97 2.00 1.87 2.002.00 2.03 2.10 1.91 1.92 1.94 1.97 2.05 1.90 1.91 1.95 2.01 2.05 1.79 1.911.931.94 2.10 1.90 1.97 2.002.062.28 1.80 1.821.891.91 1.99 1.751.831.92 1.95 2.04 1.87 1.901.98 2.00 2.08 1.90 1.95 1.95 1.97 2.03 1.82 1.99 2.01 2.06 2.06 1.901.951.952.00 2.10 1.811.901.94 1.971.99 1.871.891.98 2.012.15 1.721.78 1.96 2.00 2.05 1.87 1.89 1.911.91 2.00 1.761.801.912.06 2.12 1.95 1.961.97 2.00 2.00 1.92 1.941.97 1.99 2.00 1.851.901.90 .921.92 2 3 2 5 6 7 9 0 10 12 12 14 14 16 16 9 18 18 19 19 20 20 21 21 23 23 24 24 25 25