I forgot to post the charts to question 13 and 16, here they are. I don't know question 13 and 16
Harris_Describing_Data_A_Frequency_Distributions_Start - Excel ZH X AutoSave O Off) Zante Harris Comments File Home Insert Page Layout Formulas Data Review View Help Search Share G68 X V H K 4 A B C D E F G 52 12 53 More ON 54 12. Move the histogram and resize it to fit in the range B55:D67. Delete the x-axis title and the legend. 55 56 Histogram 57 12 58 59 10 60 61 62 63 Frequency 4 64 N 66 0 67 0 1 2 3 5 6 7 9 10 11 12 More 68 13. What can the shape of the distribution tell us about the sales data? Choose your answer from the dropdown menu in cell G68. 14. Construct a cumulative frequency distribution (Ogive). Go to the Data tab and click on Data Analysis. Double-click on Histogram. Fo The shape is symmetrical. The shape is slightly right-skewed Data sheet and highlight the data range Al:A61. Click on the Bin Range and from the Questions sheet, highlight the range B6:B19. Cl The shape is slightly left-skewed. 69 Output Range, type B70. Check the Chart Output and check the Cumulative Percentage boxes. 70 Bin Frequency Cumulative % 71 72 WNHO O LO L W N 3.39% 8.47% 73 16.95% 74 32.20% AC 780/ Instructions Sales Data Questions + + 100% Ready Circular References: B23 Type here to search O Ei X W 10:28 PM 9/13/2020Harris_Describing_Data_A_Frequency_Distributions_Start - Excel Zante Harris ZH X AutoSave O Off) Share Comments Home Insert Page Layout Formulas Data Review View Help Search File G99 X V G K 4 E F H A B C D 84.75% 78 88.14% 79 ONH W HNU 89.83% 80 81 10 94.92% 82 11 96.61% 83 12 100.00% 84 100.00% More 15. Move the histogram and resize it to fit in the range B86:D98. Delete the x-axis title and the legend. Change the chart title to "Cumulative Frequency". 85 86 87 Cumulative Frequency 88 120.00% 12 89 100.00% 10 90 80.00% 91 92 Frequency 60.00% 6 93 40.00% 94 N 20.00% 95 0.00% 96 97 More 98 16. Do we need to remove the gaps between the histograms columns? Choose your answer from the dropdown menu in cell G99. 99 100 101 102 103 Instructions Sales Data Questions + + 100% Edit Circular References: B23 10:28 PM X W Type here to search O Eli 9/13/2020