Question: Build and fit a multiple linear regression model: id duration n_bids wheels seller_rate total_pr title cond stock_photo ship_sp 1.5E+11 3 20 1 1580 51.55 ~~

Build and fit a multiple linear regression model:

iddurationn_bidswheelsseller_ratetotal_prtitlecondstock_photoship_sp
1.5E+113201158051.55~~ Wii MARIO KART & WHEEL ~ NINTENDO Wii ~ BRAND NEW ~~newyesstandard
2.6E+11713136537.04Mariokart Wii Nintendo with wheel - Mario Kart NintendousedyesfirstClass
3.2E+11316199845.5Mario Kart Wii (Wii)newnofirstClass
2.8E+113181744Brand New Mario Kart Wii Comes with Wheel. Free Shipnewyesstandard
1.7E+11120282071BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
3.6E+11319027014445Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Gamenewyesstandard
1.2E+111130728437.02Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOMEusedyesstandard
3E+111152485853.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
2E+1132912747Wii game Mario Kart in box with 1 wheel Fast Shippingusedyespriority
3.3E+1178120150Nintendo Wii : Mario Kart Wii w/ Wii Wheel (2008, MINT)usednofirstClass
2.9E+111152485854.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.8E+11115282056.01BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
3E+111132485848BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.8E+11116282056BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
2.51E+1176115443.33Mario Kart Wii (Wii) w/ Wii Wheelusedyesstandard
1.2E+11722030946Mario Kart Wii (Wii) - GAME ONLYusedyesmedia
1.4E+11314125146.71Wii Mario Kart game + wheel: NIB, factory sealednewyespriority
2.8E+113231746Brand New Mario Kart Wii Comes with Wheel. Free Shipnewyesstandard
2.9E+111102485855.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.1E+117222115326.51Nintedo Wii Console Bundle Guitar Hero 5 Mario Kartusednoparcel
2.6E+11170498231Super Mario Kart Nintendo Wii Video Game Driving SMKusedyesstandard
2.9E+111162485853.98BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
3.5E+1111211834564.95MARIO KART WITH WII OFFICIAL WHEEL+1 COBALT BLUE WHEELnewyesstandard
1.1E+111182485850.5BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.1E+11312117246.5Mario Kart Wii (Wii) Includes Steering Wheel!usedyesfirstClass
1.8E+11119282055BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
1.4E+113503734.5Mario Kart Wii (Wii)usedyesfirstClass
3E+113501536Mario Kart Wii (Wii)usedyesupsGround
1.4E+111130420040MARIO KART for Nintendo Wiiusednostandard
3.2E+1171516247Mario Kart Wii (Wii) - Brand New & Sealed!!newyesparcel
1.7E+1111101843Mario Kart Wii (Wii)usedyespriority
3.2E+11714016631Mario Kart Wii (Wii)usedyesmedia
3.9E+1151311604141.99Mario Kart Wii (Wii)usedyesstandard
1.7E+1152422749.49NAusedyesupsGround
1.9E+1131014224141Mario Kart & Wheel Nintendo Wii Game Free Priority Mailusedyespriority
1.5E+1131518844.78MarioKart Wiiusedyespriority
1.1E+113160127047Mario Kart Wii (Wii) COMPLETEusednofirstClass
1.4E+117171213144Mario Kart Wii Completeusednopriority
2.9E+11192485863.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
2.9E+111142485853.76BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
2.6E+1175155546.03New Nintendo Super Mario Kart Wii with Steering WheelnewnofirstClass
3.6E+1131314224142.25Mario Kart & Wheel Nintendo Wii Game Free Priority Mailusednopriority
3.2E+1111423446Mario Kart with 2 wheels by Wiiusednopriority
1.1E+111292485851.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.1E+111172485855.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.8E+113816941.99Mario Kart Wii with Wii Wheel for Nintendo Wii FASTSHIPusedyesfirstClass
2.9E+111122485853.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.9E+11720042239Mario Kart Wii (Wii) Used Ships Free!usedyesfirstClass
3.8E+117210862538.06MARIO KART - NINTENDO WII =============================usedyesfirstClass
1.6E+1171619046Mario Kart Wii (Wii) USED ONLY ONCE! MINT CONDITION!usednopriority
1.1E+111102485859.88BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
2.6E+111170498228.98Super Mario Kart Nintendo Wii Video Game Driving SMKusedyesstandard
1.8E+113161204636Mario Kart Wii Nintendo Wii Game & Wheelusednostandard
3.3E+1132022386151.99NINTENDO WII SUPER Mario Kart GAME ONLY NO Wheel NEW *newyesother
3E+11716094343.95Wii Mario Kart Great Condition!usedyesfirstClass
2.51E+11114020632Mario Kart Wii (Wii) gameusedyesstandard
2.3E+117101447340.06Mario Kart Wii (Wii) - Comes with Wheel - UsedusednofirstClass
2.9E+1157123948Mario Kart Wii + Wheelusednopriority
2.3E+11716035536Mario Kart Wii (Wii)usednoparcel
1.8E+1110301931Mario Kart Wii Good Condition (No Wii Wheel)usednopriority
2.9E+111232485853.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.2E+111120728430Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOMEusedyesstandard
3E+11192485858BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.3E+11518086138.1MarioKart Mario Kart Nintendo Wii Rare great game raceusednofirstClass
1.3E+11327041118.510 Nintendo Wii Games - MarioKart Wii, SpiderMan 3, etcusednoparcel
1.1E+1171222761.76Mario Kart Wii (Wii) game and 2 wheels!usedyesstandard
1.1E+111132485853.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.6E+1171418840Mario Kart Wii (Wii)usedyesmedia
3.6E+11712399164.5Wii MARIO KART GAME PLUS 3 STEERING WHEELS! Wiiusednostandard
1.2E+11716228549.01Mario Kart For Wii with 2-steering wheels NO RESERVEusednoupsGround
1.1E+1139162747Mario Kart Wii with Wii Wheel for Wii (New)newyesups3Day
1.6E+113171204640.1Mario Kart Wii Nintendo Wii Game & Wheelusednostandard
3.2E+11716199841.5Mario Kart Wii (Wii)newnofirstClass
1.8E+11120282056BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
4E+1111211834564.95NEW MARIO KART GAME+OFFICIAL WHITE+CRIMSON RED WHEELS!!newyesstandard
1.1E+11113235049NINTENDO Wii Mario Kart 2 wheels 1 reg & 1 sport NR Eusednoparcel
1.4E+113418548Mario Kart Wii (Wii) In Original Box With Wheelusedyesstandard
1.7E+1152101450438Nintendo Wii Mario Kart GAME ONLYusednofirstClass
2.7E+11314027014445Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Gameusedyesstandard
2E+11518019441.95Mario Kart Wii (Wii)usedyesparcel
3.2E+1110151239943.36Mario Kart Wii (Nintendo Wii) Complete, Mint!!usedyesparcel
1.1E+11182485854.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
2.8E+1131916445.21Mario Kart Wii Nintendo Superusedyesstandard
1.6E+117242565.02Mario Kart Wii (Wii) + 4 nerf wheelsusednoparcel
1.1E+117141045.75Nintendo Wii MarioKart and Steering WheelusedyesupsGround
1.6E+11314212764Mario Kart Wii (Wii) w/ TWO OFFICIAL STEERING WHEELSnewyesstandard
2.7E+11770036Mario Kart Wii (Wii)usedyespriority
2.8E+1177120854.7Mario Kart Wii Game with 1 Wheel - (Wii)newyespriority
1.2E+1155112749.91Mario Kart Wii (Wii) - NIB - Factory Sealed - NRnewyesparcel
2.2E+11316023147Mario Kart Wii (Wii)usedyesparcel
2.51E+1171312143Mario Kart Wii (Wii)usednostandard
1.4E+1151001935.99Mario Kart Wii (Wii)usedyesupsGround
1.8E+1111126954.49MARIO KART FOR NINTENDO Wii WITH 2 WHEELS + GAMEusedyesfirstClass
2.3E+1171511546Mario Kart Wii WITH BONUS WHEEL!!!!!usedyespriority
1.1E+111160728431.06Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOMEusedyesstandard
2.6E+1131525455.6Mario Kart Wii (Wii) w/2 Nintendo Wheels Excellent CondusedyesupsGround
1.1E+11323027014440.1Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Gamenewyesstandard
1.1E+111202485852.59BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
1.8E+1179210344Mario Kart Wii (Wii)usednoother
2.51E+1151413538.26Mario Kart (Wii) with Wii WheelusednoupsGround
1.1E+1151123651NINTENDO WII MARIO KART GAME DISK WITH TWO (2) WHEELSusednopriority
2.9E+111132485848.99BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
4E+1111211834566.44MARIO KART WITH WII WHEEL+1 GT PRO PINK WII WHEEL BUNDLnewyesupsGround
1.7E+11122282063.5BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
3.5E+115701450342Nintendo Wii Mario Kart GAME ONLYusednofirstClass
2.3E+11718138947Mario Kart Wii (Wii)newyesstandard
2.3E+11517226155Nintendo Wii Mario Kart With 2 Racing Wheelsusednostandard
2.9E+1179138133.01MarioKart (Wii) w/ wheelusedyesmedia
3E+111162485853.76BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
3.2E+115201822446BRAND NEW! FACTORY SEALED! MARIO KART WITH Wii WHEELnewyesmedia
3.6E+11316027014343Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Gameusedyesstandard
1.7E+113511042.55Mario Kart Wii (Wii) with 1 Wheelusedyespriority
1.9E+1175211652.5Mario Kart Wii with Bonus Wheel!!! (2 Wheels Included)usedyesstandard
1.1E+111252485857.5BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
3.5E+1113311834575NEW MARIO KART WITH WII WHEEL+2 GT PRO WHITE WII WHEELnewyesstandard
1.5E+117711148.92Mario Kart Wii (Wii)usedyesparcel
1.6E+117181115445.99MARIO KART WII WITH STEERING WHEEL NEW NINTENDO WIInewyesfirstClass
3.5E+11710187740.05Mario Kart Wii (Wii) W/RACING WHEEL!usedyesstandard
1.7E+11113155645Mario Kart Wii, Game and Wheel, Brand New Sealednewyesother
1.4E+113826350Mario Kart Wii (Wii)usedyesparcel
2.51E+1171609449.75Mario Kart Wii (Wii) *SEALED*newyespriority
3.7E+1173150847Mario Kart Wii (Wii) - Complete! Perfect!usednoparcel
1.1E+111172485856BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
3.2E+1111113041Mario Kart Wii with Wii Wheelusednopriority
1.2E+11391114446NEW Mario Kart Nintendo Wii Racing Game w/Wheel OnlinenewnofirstClass
2.3E+11710146234.99Mario Kart Wii (Wii) Game and Steering WheelusedyesfirstClass
3.2E+11123228049Mario Kart Wii (Nintendo Wii) comes with 2 Wheels NEW!!usedyesparcel
1.7E+11119282061BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
1.8E+11114282062.89BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAMEnewyesmedia
2.7E+11311129946NINTENDO ~ MARIO KART Wii ~ NEW IN BOX ~ FACTORY SEALEDnewyesfirstClass
3.9E+1111211834564.95MARIO KART WITH WII OFFICIAL WHEEL+1 COBALT BLUE WHEELnewyesstandard
3.9E+117140229036.99Mario Kart Nintendo Wii Game Complete & MINT !usednomedia
2.8E+1171413744Mario Kart Wii w/ wheelusedyespriority
3.5E+1151711450341.35Wii Mario Kart Game & Wheel In Original Box Tested WKINusedyespriority
2.3E+11711029737MarioKart Wiiusednopriority
3E+111182485858.98BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround
3.5E+1152001450339Nintendo Wii Mario Kart GAME ONLYusedyesfirstClass
1.2E+11761308540.7NINTENDO WII MARIOKART (WHEEL AND GAME)usednopriority
1.1E+111200728439.51Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOMEusedyesstandard
1.5E+1179212152Mario Kart Wii (Wii)usednoparcel
1.4E+11314125147.7Wii Mario Kart game + wheel: NIB, factory sealednewyespriority
3E+1171304138.76Mario Kart Wiiusednoparcel
1.1E+111132485854.51BRAND NEW NINTENDO MARIO KART WITH 2 WHEELSnewyesupsGround

1. Did you find an outlier in the total_pr variable? What did you do with it? Explain your decision.

2. For the final model, adjusted R2, is _____? Enter your answer as a decimal, rounded to 2 decimals.

3.The final regression model is:

= + * + * + *

Round numerical answers to 2 decimals and spell the variable names as they are spelled in the data set.

4.Using a rule of |Z| > 2, how many multivariate outliers are there in the final model?

5.

Build and fit a multiple linear regression model:iddurationn_bidswheelsseller_ratetotal_prtitlecondstock_photoship_sp1.5E+113201158051.55~~ Wii MARIO KART &

Residual Plots are used to visually assess the homogeneity of variance assumption of linear regression. The distribution of residuals shown wheels Residual Plot I'N DO in the wheels Residual Plot has a pattern. This pattern indicates _________ ? Resuduals D H\" {-0 w a .5 a m _ Rafs 00 wheels O The plot shows constant variance so the HOV assumption is met. 0 The model overpredicts for lots with 0 or 1 wheel and underpredicts for lots with 3 or 4 wheels. 0 The model underpredicts for lots with O or 1 wheel and overpredicts for lots with 3 or 4 wheels

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Wii Mario Kart auctions from Ebay Auction data from Ebay for the game Mario Kart for the Nintendo Wii. This data was collected in early October, 2009. duration - Auction length, in days. n_bids -...

Q:

1. Open the Excel worksheet containing your Team Project Data. 2. As you learned in Module 2 , you will be using the set of potentially meaningful numerical independent variables and the one selected...

Q:

Lease data 1/Sq Feet Parking/Sq Ft e Lease Cost ($ per Sq Ft) $3,263 $2,908 $28,159 $8,929 $3,501 $7,673 $7,749 $11,479 $387 $514 $1,905 $19,085 $4,437 $674 $888 $451 $929 $16,009 $1,503 $4,912...

Q:

EXCEL DATA BELOW: ANSWER ALL PARTS: R SOFTWARE 5.11 This problem is inspired by an example in Cook and Weisberg (1999). UBS AG Wealth Management Research conducts a regular survey of international...

Q:

5-Year Return 5.0 5.3 5.0 5.4 4.8 5.9 5.0 5.6 5.0 5.1 5.6 4.7 5.1 4.8 5.2 5.4 4.9 4.7 5.2 4.7 4.9 4.7 6.1 4.2 6.3 4.5 4.6 4.3 4.7 4.4 5.6 4.6 5.0 6.2 4.6 4.2 5.2 5.2 4.5 4.6 5.7 4.2 4.6 6.5 4.7 4.0...

Q:

Report Write-up Structure : provides the title of the study along with the names of the team members. Introduction: is a section introducing the study with a one paragraph scenario that mentions what...

Q:

SEI 69.7 78.0 39.0 83.7 78.0 63.5 31.5 33.3 64.2 67.0 69.2 33.6 68.1 36.5 76.4 61.9 76.3 50.7 63.5 87.9 31.4 83.7 63.5 37.9 27.5 63.5 73.2 67.0 60.5 30.8 28.4 36.7 67.0 74.9 63.5 63.5 56.5 62.5 38.0...

Q:

This data table gives annual costs of 223 commercial leases. All of these leases provide office space in a Midwestern city in the United States. The cost of the lease is measured in dollars per...

Q:

Open the Excel worksheet containing your Team Project Data. **Y = Salary*** As you learned in Modules 3 and 4, you will be using the set of potentially meaningful numerical independent variables and...

Q:

Question: Describe the five stages of the translanguage instructional design cycle. Provide examples provided in Chapter 5. \ CHAPTER 5 Translanguaging Design in Instruction LEARNING OBJECTIVES...

Q:

Color-Dyne printed patterns on carpets. After reviewing the companys audited financial statements, the plaintiff s provided materials to Color-Dyne on credit. These financial statements showed that...

Q:

Tickets for a concert are sold at three prices: full, concessional and children. Four full plus two concessional tickets cost $760, while two full, three concessional and five children tickets cost...

Q:

Question 4 ( 1 . 2 5 points ) Would you invest in a project that has a net investment of $ 1 4 , 0 0 0 and a single net cash flow of $ 2 4 , 0 0 0 in 5 years, if your required rate of return was 1 0...

Q:

Tammy Jackson purchased 1 0 9 shares of All - American Manufacturing Company stock at $ 3 3 . 6 0 a share. One year later, she sold the stock for $ 4 1 a share. She paid her broker a $ 3 5 commission...