Description
Data Management Assignment. Complete the excel chart with my teachers instructions.
1 attachmentsSlide 1 of 1attachment_1attachment_1
Unformatted Attachment Preview
SAVE THIS FILE AS lastname_firstinitial_excel in your home drive.
The data on the sheet labelled ‘Roller Coasters’ contains the drop height in metres of a sample o
Part A
Complete the Four Step Summary for single variable analysis as learned in class. Use Excel for al
graphs. Be thorough.
Part B
Calculate the grouped mean and grouped standard deviation for the data. Compare these to the
standard deviation. Comment on any similarities or differences.
SUBMIT your file to your teacher’s HAND-IN FOLDER
ight in metres of a sample of roller coasters.
ned in class. Use Excel for all calculations, tables and
data. Compare these to the ungrouped mean and
Name
Afterburner
Alpengeist
American Eagle
Apollo’s Chariot
Batman Knight Flight
Beast
Blue Streak
Boss
Cannon Ball
Canyon Blaster
Chang
Cheetah
Coaster Thrill Ride
Colossus
Comet
Corkscrew
Deja Vu
Desperado
ew Mexico Rattler
Goliath
Great American Scream Machine
Hangman
Hayabusa
Hercules
Hurricane
HyperSonic XLC
Incredible Hulk
Invertigo
Iron Wolf
Kong
Kraken
Magnum XL-200
Mamba
Manhattan Express
Mean Streak
Medusa
Millennium Force
Mind Eraser
Nitro
Oblivion
Orient Express
Phantom’s Revenge
Phantom’s Revenge
Raging Bull
Rattler
Rattler
Riddler’s Revenge
Scream!
Drop (m)
47
170
147
210
148
141
72
150
70
66
144
90
52
115
78
62
177
225
75
255
155
95
124.7
151
100
133
105
138
90
95
144
194.6
205
144
155
150
300
95
215
180
115
225
228
208
124
166.5
146
141
Screamin’ Eagle
Silver Bullet
Son Of Beast
Starliner
Steel Dragon 2000
Steel Eel
Steel Force
Stunt Fall
Superman – Ride Of Steel
Superman – Ride Of Steel
T2
Tennessee Tornado
Texas Giant
Thunder Dolphin
Thunderbolt
Timber Wolf
Titan
Titan
Top Gun
Viper
Volcano, The Blast Coaster
Whizzer
Wild One
Wild Thing
Wildfire
X
Xcelerator
92
75
214
76
306.8
150
205
177
205
221
95
128
137
218.1
95
95
178
255
93
171
80
64
88
196
155
215
130
Purchase answer to see full
attachment
Tags:
standard deviation
data management
american eagle
roller coasters
ungrouped mean
Mexico Rattler
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.
Reviews, comments, and love from our customers and community: