90.2K

Verified Solution

Link Copied!

Connect to the coasters.xlsx file in Tableau.

Construct three scatter plots. For each plot, place the Explanatory variable on the x$-$axis and the Response variable on the y$-$axis.

Variable combinations:

$$ height and speed

$$ drop and speed

$$ duration and speed

Question One: Evaluate the regression conditions for each plot. Explain why or why not it is appropriate to run a regression analysis on each plot. Please address all conditions covered in this module.

For plots that meet the regression conditions, add a linear trend line.

Question Two: Which variable$($s$)$ can you use to predict Speed?

Question Three: What is the regression equation for the trend line$($s$)?$

For the plots that you conducted linear regression, drag Track $($dimension$)$ onto Color in the Marks card.

Question Four: Are there any differences between steel and wooden coasters n your analyses? Explain.

iName Park Track Speed $($mph$)$ Height $($ft$)$ Drop $($ft$)$ Length $($ft$)$ Duration $($sec$)$ Inversions

Top Thrill Dragster Cedar Point Steel $12042040028000$

Superman The Escap Six Flags Magic Mountain Steel $100415328\mathrm{.}112350$

Millennium Force Cedar Point Steel $9331030065951650$

Goliath Six Flags Magic Mountain Steel $8523525545001800$

Titan Six Flags Over Texas Steel $8524525553122100$

Phantom's Revenge Kennywood Park Steel $8216022832000$

Xcelerator Knott's Berry Farm Steel $822051302202620$

Desperado Buffalo Bill's Resort & Casino Steel $8020922558431630$

HyperSonic XLC Paramount's Kings Dominion Steel $8016513315600$

Nitro Six Flags Great Adventure Steel $8023021553942400$

Phantom's Revenge Kennywood Park Steel $8016022530001$

Son Of Beast Paramount's Kings Island Wood $78\mathrm{.}421821470321$

Superman $-$ Ride Of Steel Six Flags New England Steel $7720822154001550$

X Six Flags Magic Mountain Steel $7617521536101$

Mamba Worlds of Fun Steel $7520520556001800$

Steel Force Dorney Park Steel $7520020556001800$

Wild Thing Valleyfair! Steel $7420719654601800$

Apollo's Chariot Busch Gardens Williamsburg Steel $7317021048821350$

Raging Bull Six Flags Great America Steel $7320220850571500$

Rattler Six Flags Fiesta Texas Wood $73179\mathrm{.}5166\mathrm{.}550801460$

Superman $-$ Ride Of Steel Six Flags Darien Lake Steel $7320820554002000$

Magnum XL$-200$ Cedar Point Steel $72205194\mathrm{.}651061200$

Viper Six Flags Magic Mountain Steel $7018817138301501$

Volcano, The Blast Coaster Paramount's Kings Dominion Steel $701558027571$

Great American Scream Machine Six Flags Great Adventure Steel $6817315538001401$

Alpengeist Busch Gardens Williamsburg Steel $6719517038281901$

Incredible Hulk Universal Studios Islands of Adventure Steel $6711010537001351$

Manhattan Express New York, New York Hotel & Casino Steel $6720314447771601$

Boss Six Flags St$.$ Louis Wood $66\mathrm{.}312215050510$

American Eagle Six Flags Great America Wood $6612714746501430$

Wildfire Silver Dollar City Steel $6612015530731361$

Deja Vu Six Flags Great America Steel $65\mathrm{.}6191\mathrm{.}51771204921$

Batman Knight Flight Six Flags Worlds of Adventure Steel $6515714842101$

Answer & Explanation Solved by verified expert

See Answer