Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SECTION No Paperclip Paperclip 111 7.45 3.7 111 18.7 12 111 15.13 13.8 111 12.078 14.55 111 21.882 12.5 111 17.454 14.08 111 19.26 19.3

SECTION No Paperclip Paperclip
111 7.45 3.7
111 18.7 12
111 15.13 13.8
111 12.078 14.55
111 21.882 12.5
111 17.454 14.08
111 19.26 19.3
111 16.228 9.86
111 14.57 13.17
111 20.45 8.82
111 14.1 12.19
111 18.78 11.15
112 13.864 7.63
112 19.818 14.36
112 14.98 17.45
112 14.03 18.69
112 13.37 11.7
112 11.51 11.285
112 17.7 13.39
112 12.84 9.21
112 17.75 11.24
112 18.492 13.01

Create a histogram for the helicopters without a paperclip:

  1. In cell E1, type "Distance (cm)" in bold
  2. In cell E2, type "2"
  3. In cell E3, type "4"
  4. Highlight the cell range E2:E3, then fill down to E2:E19.
  5. Select Data > Data Analysis
  6. Choose Histogram, then click OK
    • Input Range = $B:$B
    • Bin Range = $E$1:$E$19
    • Check the box for "Labels"
    • Output Range = $G:$G
    • Check the box for "Chart Output"
    • Click OK

  1. In cell G2, change "2" to "0 ... 2"
  2. In cell G3, change "4" to "... 4"
  3. Repeat for cells G4:G19
  4. Right-click on one of the histogram bars and select Format Data Series...
  5. Set the gap width to 5%
  6. Chang the title of the histogram to "No Paperclip"
  7. Enlarge the histogram by dragging one of the corners

How would you describe the shape of the distribution for helicopters without a paperclip?

Group of answer choices

Uniform

Bell shaped

Skewed left

Skewed right

Create a similar histogram for the helicopters with a paperclip:

  1. Select Data > Data Analysis
  2. Choose Histogram, then click OK
    • Input Range = $C:$C
    • Bin Range = $E$1:$E$19
    • Check the box for "Labels"
    • Output Range = $J:$J
    • Check the box for "Chart Output"
    • Click OK

  1. In cell J2, change "2" to "... 2"
  2. In cell J3, change "4" to "... 4"
  3. Repeat for cells J4:J19
  4. Right-click on one of the histogram bars and select Format Data Series...
  5. Set the gap width to 5%
  6. Chang the title of the histogram to "Paperclip"
  7. Enlarge the histogram by dragging one of the corners

How would you describe the shape of the distribution for helicopters with a paperclip?

Group of answer choices

Uniform

Bell shaped

Skewed left

Skewed right

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

College Algebra

Authors: Mark Dugopolski

5th Edition

0321899822, 9780321899828

More Books

Students also viewed these Mathematics questions

Question

What made you decide on this subfield of psychology?

Answered: 1 week ago

Question

4. What means will you use to achieve these values?

Answered: 1 week ago

Question

3. What values would you say are your core values?

Answered: 1 week ago