Answered step by step
Verified Expert Solution
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:
- In cell E1, type "Distance (cm)" in bold
- In cell E2, type "2"
- In cell E3, type "4"
- Highlight the cell range E2:E3, then fill down to E2:E19.
- Select Data > Data Analysis
- 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
- In cell G2, change "2" to "0 ... 2"
- In cell G3, change "4" to "... 4"
- Repeat for cells G4:G19
- Right-click on one of the histogram bars and select Format Data Series...
- Set the gap width to 5%
- Chang the title of the histogram to "No Paperclip"
- 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:
- Select Data > Data Analysis
- 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
- In cell J2, change "2" to "... 2"
- In cell J3, change "4" to "... 4"
- Repeat for cells J4:J19
- Right-click on one of the histogram bars and select Format Data Series...
- Set the gap width to 5%
- Chang the title of the histogram to "Paperclip"
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started