#13 and #16

Bb Chapter 2: Organizing and Visual X Do Homework - Homework Ch.2 x M Inbox (1,004) - zharris@cub.ucale x *Describing Data A Frequency Dis x + X coursehero.com/u/file/p4uoaff8/7-Created-On-07052019-1-Describing-Data-A-Frequency-Distributions-Grader/#doc/qa DGOA . . . ASK QUESTIONS questions Thanks for rating! Rate 2 more documents to earn a free unlock. 2 > Quiz Yourself What can the shape of the Page: 2 of 2 - + Automatic Zoom KHTO distribution tell us about the sales data? Choose your Grader - Instructions Excel 2016 Project answer from the dropdown Related Documents menu in cell G68. Step Instructions Points Possible 13 What can the shape of the distribution tell us about the sales data? 7 Choose your answer from the dropdown menu in cell G68. Add to Library 14 Construct a cumulative frequency distribution. Go to the Data tab and 7 click on Data Analysis. Double-click on Histogram. For the Input Minimum 10 characters are required. Range, go to the Sales Data sheet and highlight the data range .. . A1:A61. Click on the Bin Range and from the Questions sheet, Search for a subject. highlight the range B6:B19. Check the Labels box. For the Output Range, type B70. Check the Chart Output and check the Cumulative More Percentage boxes. 15 Get answer Move the histogram and resize it to fit in the range B86:098. Delete 7 the x-axis title and the legend. Change the chart title to "Cumulative Frequency". Answers in as fast as 15 minutes 16 Do we need to remove the gaps between the histograms columns? 7 Choose your answer from the dropdown menu in cell G99. By continuing, you agree to our Privacy Policy, Terms of Use, and Honor Code. 17 Save your file and submit it for grading. 0 At Ask Expert Tutors You can ask 15 questions (will expire ) Type here to search O P X W 10:23 PM 9/13/2020