Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

I forgot to post the charts to question 13 and 16, here they are. I don't know question 13 and 16

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modeling the Dynamics of Life Calculus and Probability for Life Scientists

Authors: Frederick R. Adler

3rd edition

840064187, 978-1285225975, 128522597X, 978-0840064189

More Books

Students also viewed these Mathematics questions

Question

=+ d. What is the slope between 1 and 2 units?

Answered: 1 week ago