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.

Variables

id - Auction ID assigned by Ebay.

duration - Auction length, in days.

n_bids - Number of bids.

cond - Game condition, either new or used.

start_pr - Start price of the auction.

ship_pr - Shipping price.

total_pr - Total price, which equals the auction price plus the shipping price.

ship_sp - Shipping speed or method.

seller_rate - The seller's rating on Ebay. This is the number of positive ratings minus the number of negative ratings for the seller.

stock_photo - Whether the auction feature photo was a stock photo or not. If the picture was used in many auctions, then it was called a stock photo.

wheels - Number of Wii wheels included in the auction. These are steering wheel attachments to make it seem as though you are actually driving in the game. When used with the controller, turning the wheel actually causes the character on screen to turn.

title - The title of the auctions.

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	~~ Wii MARIO KART & WHEEL ~ NINTENDO Wii ~ BRAND NEW ~~	new	yes	standard
2.6E+11	7	13	1	365	37.04	Mariokart Wii Nintendo with wheel - Mario Kart Nintendo	used	yes	firstClass
3.2E+11	3	16	1	998	45.5	Mario Kart Wii (Wii)					new	no	firstClass
2.8E+11	3	18	1	7	44	Brand New Mario Kart Wii Comes with Wheel. Free Ship	new	yes	standard
1.7E+11	1	20	2	820	71	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
3.6E+11	3	19	0	270144	45	Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Game	new	yes	standard
1.2E+11	1	13	0	7284	37.02	Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOME	used	yes	standard
3E+11	1	15	2	4858	53.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
2E+11	3	29	1	27	47	Wii game Mario Kart in box with 1 wheel Fast Shipping	used	yes	priority
3.3E+11	7	8	1	201	50	Nintendo Wii : Mario Kart Wii w/ Wii Wheel (2008, MINT)	used	no	firstClass
2.9E+11	1	15	2	4858	54.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.8E+11	1	15	2	820	56.01	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
3E+11	1	13	2	4858	48	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.8E+11	1	16	2	820	56	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
2.51E+11	7	6	1	154	43.33	Mario Kart Wii (Wii) w/ Wii Wheel			used	yes	standard
1.2E+11	7	22	0	309	46	Mario Kart Wii (Wii) - GAME ONLY			used	yes	media
1.4E+11	3	14	1	251	46.71	Wii Mario Kart game + wheel: NIB, factory sealed		new	yes	priority
2.8E+11	3	23	1	7	46	Brand New Mario Kart Wii Comes with Wheel. Free Ship	new	yes	standard
2.9E+11	1	10	2	4858	55.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.1E+11	7	22	2	115	326.51	Nintedo Wii Console Bundle Guitar Hero 5 Mario Kart	used	no	parcel
2.6E+11	1	7	0	4982	31	Super Mario Kart Nintendo Wii Video Game Driving SMK	used	yes	standard
2.9E+11	1	16	2	4858	53.98	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
3.5E+11	1	1	2	118345	64.95	MARIO KART WITH WII OFFICIAL WHEEL+1 COBALT BLUE WHEEL	new	yes	standard
1.1E+11	1	18	2	4858	50.5	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.1E+11	3	12	1	172	46.5	Mario Kart Wii (Wii) Includes Steering Wheel!		used	yes	firstClass
1.8E+11	1	19	2	820	55	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
1.4E+11	3	5	0	37	34.5	Mario Kart Wii (Wii)					used	yes	firstClass
3E+11	3	5	0	15	36	Mario Kart Wii (Wii)					used	yes	upsGround
1.4E+11	1	13	0	4200	40	MARIO KART for Nintendo Wii				used	no	standard
3.2E+11	7	15	1	62	47	Mario Kart Wii (Wii) - Brand New & Sealed!!		new	yes	parcel
1.7E+11	1	11	0	18	43	Mario Kart Wii (Wii)					used	yes	priority
3.2E+11	7	14	0	166	31	Mario Kart Wii (Wii)					used	yes	media
3.9E+11	5	13	1	16041	41.99	Mario Kart Wii (Wii)					used	yes	standard
1.7E+11	5	24	2	27	49.49	NA						used	yes	upsGround
1.9E+11	3	10	1	42241	41	Mario Kart & Wheel Nintendo Wii Game Free Priority Mail	used	yes	priority
1.5E+11	3	15	1	88	44.78	MarioKart Wii					used	yes	priority
1.1E+11	3	16	0	1270	47	Mario Kart Wii (Wii) COMPLETE			used	no	firstClass
1.4E+11	7	17	1	2131	44	Mario Kart Wii Complete				used	no	priority
2.9E+11	1	9	2	4858	63.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
2.9E+11	1	14	2	4858	53.76	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
2.6E+11	7	5	1	555	46.03	New Nintendo Super Mario Kart Wii with Steering Wheel	new	no	firstClass
3.6E+11	3	13	1	42241	42.25	Mario Kart & Wheel Nintendo Wii Game Free Priority Mail	used	no	priority
3.2E+11	1	14	2	34	46	Mario Kart with 2 wheels by Wii			used	no	priority
1.1E+11	1	29	2	4858	51.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.1E+11	1	17	2	4858	55.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.8E+11	3	8	1	69	41.99	Mario Kart Wii with Wii Wheel for Nintendo Wii FASTSHIP	used	yes	firstClass
2.9E+11	1	12	2	4858	53.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.9E+11	7	20	0	422	39	Mario Kart Wii (Wii) Used Ships Free!			used	yes	firstClass
3.8E+11	7	21	0	8625	38.06	MARIO KART - NINTENDO WII =============================	used	yes	firstClass
1.6E+11	7	16	1	90	46	Mario Kart Wii (Wii) USED ONLY ONCE! MINT CONDITION!	used	no	priority
1.1E+11	1	10	2	4858	59.88	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
2.6E+11	1	17	0	4982	28.98	Super Mario Kart Nintendo Wii Video Game Driving SMK	used	yes	standard
1.8E+11	3	16	1	2046	36	Mario Kart Wii Nintendo Wii Game & Wheel		used	no	standard
3.3E+11	3	2	0	223861	51.99	NINTENDO WII SUPER Mario Kart GAME ONLY NO Wheel NEW *	new	yes	other
3E+11	7	16	0	943	43.95	Wii Mario Kart Great Condition!			used	yes	firstClass
2.51E+11	1	14	0	206	32	Mario Kart Wii (Wii) game				used	yes	standard
2.3E+11	7	10	1	4473	40.06	Mario Kart Wii (Wii) - Comes with Wheel - Used		used	no	firstClass
2.9E+11	5	7	1	239	48	Mario Kart Wii + Wheel				used	no	priority
2.3E+11	7	16	0	355	36	Mario Kart Wii (Wii)					used	no	parcel
1.8E+11	10	3	0	19	31	Mario Kart Wii Good Condition (No Wii Wheel)		used	no	priority
2.9E+11	1	23	2	4858	53.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.2E+11	1	12	0	7284	30	Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOME	used	yes	standard
3E+11	1	9	2	4858	58	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.3E+11	5	18	0	861	38.1	MarioKart Mario Kart Nintendo Wii Rare great game race	used	no	firstClass
1.3E+11	3	27	0	41	118.5	10 Nintendo Wii Games - MarioKart Wii, SpiderMan 3, etc	used	no	parcel
1.1E+11	7	12	2	27	61.76	Mario Kart Wii (Wii) game and 2 wheels!			used	yes	standard
1.1E+11	1	13	2	4858	53.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.6E+11	7	14	1	88	40	Mario Kart Wii (Wii)					used	yes	media
3.6E+11	7	12	3	991	64.5	Wii MARIO KART GAME PLUS 3 STEERING WHEELS! Wii	used	no	standard
1.2E+11	7	16	2	285	49.01	Mario Kart For Wii with 2-steering wheels NO RESERVE	used	no	upsGround
1.1E+11	3	9	1	627	47	Mario Kart Wii with Wii Wheel for Wii (New)		new	yes	ups3Day
1.6E+11	3	17	1	2046	40.1	Mario Kart Wii Nintendo Wii Game & Wheel		used	no	standard
3.2E+11	7	16	1	998	41.5	Mario Kart Wii (Wii)					new	no	firstClass
1.8E+11	1	20	2	820	56	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
4E+11	1	1	2	118345	64.95	NEW MARIO KART GAME+OFFICIAL WHITE+CRIMSON RED WHEELS!!	new	yes	standard
1.1E+11	1	13	2	350	49	NINTENDO Wii Mario Kart 2 wheels 1 reg & 1 sport NR E	used	no	parcel
1.4E+11	3	4	1	85	48	Mario Kart Wii (Wii) In Original Box With Wheel		used	yes	standard
1.7E+11	5	21	0	14504	38	Nintendo Wii Mario Kart GAME ONLY			used	no	firstClass
2.7E+11	3	14	0	270144	45	Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Game	used	yes	standard
2E+11	5	18	0	194	41.95	Mario Kart Wii (Wii)					used	yes	parcel
3.2E+11	10	15	1	2399	43.36	Mario Kart Wii (Nintendo Wii) Complete, Mint!!		used	yes	parcel
1.1E+11	1	8	2	4858	54.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
2.8E+11	3	19	1	64	45.21	Mario Kart Wii Nintendo Super			used	yes	standard
1.6E+11	7	2	4	25	65.02	Mario Kart Wii (Wii) + 4 nerf wheels			used	no	parcel
1.1E+11	7	14	1	0	45.75	Nintendo Wii MarioKart and Steering Wheel		used	yes	upsGround
1.6E+11	3	14	2	127	64	Mario Kart Wii (Wii) w/ TWO OFFICIAL STEERING WHEELS	new	yes	standard
2.7E+11	7	7	0	0	36	Mario Kart Wii (Wii)					used	yes	priority
2.8E+11	7	7	1	208	54.7	Mario Kart Wii Game with 1 Wheel - (Wii)		new	yes	priority
1.2E+11	5	5	1	127	49.91	Mario Kart Wii (Wii) - NIB - Factory Sealed - NR		new	yes	parcel
2.2E+11	3	16	0	231	47	Mario Kart Wii (Wii)					used	yes	parcel
2.51E+11	7	13	1	21	43	Mario Kart Wii (Wii)					used	no	standard
1.4E+11	5	10	0	19	35.99	Mario Kart Wii (Wii)					used	yes	upsGround
1.8E+11	1	11	2	69	54.49	MARIO KART FOR NINTENDO Wii WITH 2 WHEELS + GAME	used	yes	firstClass
2.3E+11	7	15	1	15	46	Mario Kart Wii WITH BONUS WHEEL!!!!!			used	yes	priority
1.1E+11	1	16	0	7284	31.06	Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOME	used	yes	standard
2.6E+11	3	15	2	54	55.6	Mario Kart Wii (Wii) w/2 Nintendo Wheels Excellent Cond	used	yes	upsGround
1.1E+11	3	23	0	270144	40.1	Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Game	new	yes	standard
1.1E+11	1	20	2	4858	52.59	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
1.8E+11	7	9	2	103	44	Mario Kart Wii (Wii)					used	no	other
2.51E+11	5	14	1	35	38.26	Mario Kart (Wii) with Wii Wheel			used	no	upsGround
1.1E+11	5	11	2	36	51	NINTENDO WII MARIO KART GAME DISK WITH TWO (2) WHEELS	used	no	priority
2.9E+11	1	13	2	4858	48.99	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
4E+11	1	1	2	118345	66.44	MARIO KART WITH WII WHEEL+1 GT PRO PINK WII WHEEL BUNDL	new	yes	upsGround
1.7E+11	1	22	2	820	63.5	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
3.5E+11	5	7	0	14503	42	Nintendo Wii Mario Kart GAME ONLY			used	no	firstClass
2.3E+11	7	18	1	389	47	Mario Kart Wii (Wii)					new	yes	standard
2.3E+11	5	17	2	261	55	Nintendo Wii Mario Kart With 2 Racing Wheels		used	no	standard
2.9E+11	7	9	1	381	33.01	MarioKart (Wii) w/ wheel				used	yes	media
3E+11	1	16	2	4858	53.76	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
3.2E+11	5	20	1	8224	46	BRAND NEW! FACTORY SEALED! MARIO KART WITH Wii WHEEL	new	yes	media
3.6E+11	3	16	0	270143	43	Mario Kart Wii (GAME ONLY/NO WHEEL) - Nintendo Wii Game	used	yes	standard
1.7E+11	3	5	1	10	42.55	Mario Kart Wii (Wii) with 1 Wheel			used	yes	priority
1.9E+11	7	5	2	116	52.5	Mario Kart Wii with Bonus Wheel!!! (2 Wheels Included)	used	yes	standard
1.1E+11	1	25	2	4858	57.5	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
3.5E+11	1	3	3	118345	75	NEW MARIO KART WITH WII WHEEL+2 GT PRO WHITE WII WHEEL	new	yes	standard
1.5E+11	7	7	1	11	48.92	Mario Kart Wii (Wii)					used	yes	parcel
1.6E+11	7	18	1	1154	45.99	MARIO KART WII WITH STEERING WHEEL NEW NINTENDO WII	new	yes	firstClass
3.5E+11	7	10	1	877	40.05	Mario Kart Wii (Wii) W/RACING WHEEL!			used	yes	standard
1.7E+11	1	13	1	556	45	Mario Kart Wii, Game and Wheel, Brand New Sealed	new	yes	other
1.4E+11	3	8	2	63	50	Mario Kart Wii (Wii)					used	yes	parcel
2.51E+11	7	16	0	94	49.75	Mario Kart Wii (Wii) *SEALED*				new	yes	priority
3.7E+11	7	3	1	508	47	Mario Kart Wii (Wii) - Complete! Perfect!		used	no	parcel
1.1E+11	1	17	2	4858	56	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
3.2E+11	1	11	1	30	41	Mario Kart Wii with Wii Wheel				used	no	priority
1.2E+11	3	9	1	1144	46	NEW Mario Kart Nintendo Wii Racing Game w/Wheel Online	new	no	firstClass
2.3E+11	7	10	1	462	34.99	Mario Kart Wii (Wii) Game and Steering Wheel		used	yes	firstClass
3.2E+11	1	23	2	280	49	Mario Kart Wii (Nintendo Wii) comes with 2 Wheels NEW!!	used	yes	parcel
1.7E+11	1	19	2	820	61	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
1.8E+11	1	14	2	820	62.89	BRAND NEW NINTENDO 1 WII MARIO KART WITH 2 WHEELS +GAME	new	yes	media
2.7E+11	3	11	1	299	46	NINTENDO ~ MARIO KART Wii ~ NEW IN BOX ~ FACTORY SEALED	new	yes	firstClass
3.9E+11	1	1	2	118345	64.95	MARIO KART WITH WII OFFICIAL WHEEL+1 COBALT BLUE WHEEL	new	yes	standard
3.9E+11	7	14	0	2290	36.99	Mario Kart Nintendo Wii Game Complete & MINT !	used	no	media
2.8E+11	7	14	1	37	44	Mario Kart Wii w/ wheel				used	yes	priority
3.5E+11	5	17	1	14503	41.35	Wii Mario Kart Game & Wheel In Original Box Tested WKIN	used	yes	priority
2.3E+11	7	11	0	297	37	MarioKart Wii					used	no	priority
3E+11	1	18	2	4858	58.98	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround
3.5E+11	5	20	0	14503	39	Nintendo Wii Mario Kart GAME ONLY			used	yes	firstClass
1.2E+11	7	6	1	3085	40.7	NINTENDO WII MARIOKART (WHEEL AND GAME)		used	no	priority
1.1E+11	1	20	0	7284	39.51	Mario Kart Wii (Wii) Nintendo Wii game *--WOW --AWESOME	used	yes	standard
1.5E+11	7	9	2	121	52	Mario Kart Wii (Wii)					used	no	parcel
1.4E+11	3	14	1	251	47.7	Wii Mario Kart game + wheel: NIB, factory sealed		new	yes	priority
3E+11	7	13	0	41	38.76	Mario Kart Wii					used	no	parcel
1.1E+11	1	13	2	4858	54.51	BRAND NEW NINTENDO MARIO KART WITH 2 WHEELS	new	yes	upsGround

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 R², 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.

Residual Plots are used to visually assess the homogeneity of variance assumption of linear regression. The distribution of residuals shown wheels Residual Plot in the wheels Residual Plot has a pattern. This pattern indicates ______ ? Reslduals ._. o o H O H\" on. w s. U1 wheels 0 The plot shows constant variance so the HOV assumption is met. 0 The model overpredicts for lots with O or 1 wheel and underpredicts for lots with 3 or 4 wheels. 0 The model underpredicts for lots with 0 or 1 wheel and overpredicts for lots with 3 or 4 wheels