Suppose you are interested in buying or selling products through online auctions. What circumstances are good for buying? What circumstances are good for selling? Several years ago, 488 eBay auctions of a popular model of Dell Latitude were recorded over a three-month period. The data (in the worksheet labeled "Data") include: (1)winning bid:the winning bid for a particular auction, (2)day: the day of the week that the auction closed, (3)# bids: the number of bids in the auction, (4)# auctions: the number of auctions that closed that day for the same laptop, and (5)rank-in-day: the rank of the auction within a day (i.e., the order that it end among laptop auctions on that day). The day of the week is coded using dummy variables;sun= 1 if the auction closed on a Sunday (0 otherwise),mon= 1 if it closed on a Monday (0 otherwise), etc. a. Do the variables included in the model collectively explain a significant amount of the variation in winning bids? Cite the appropriate test, test statistic,p-value, and your conclusion at thea= .05level. b. Is there a relationship between the winning bid price and the rank of the auction (in this model)? Cite an appropriate test, your test statistic,p-value, and your conclusion at thea=.05 level. c. What is the price difference between a Dell laptop auctioned on Saturday and one auctioned on Sunday (all other things remaining equal)? Is this difference  $0? Cite the relevant test statistic, thep-value, and your conclusion at thea= .05level. winning bid ($) sun mon tue wed thu fri # bids rank-in-day # auctions 535.00 0 0 0 1 0 0 8 1 13 536.00 0 0 0 1 0 0 7 2 13 586.00 0 0 0 1 0 0 11 3 13 585.00 0 0 0 1 0 0 7 4 13 535.00 0 0 0 1 0 0 4 5 13 535.00 0 0 0 1 0 0 7 6 13 535.00 0 0 0 1 0 0 5 7 13 535.00 0 0 0 1 0 0 6 8 13 535.00 0 0 0 1 0 0 6 9 13 540.00 0 0 0 1 0 0 16 10 13 535.00 0 0 0 1 0 0 15 11 13 525.00 0 0 0 1 0 0 2 12 13 528.00 0 0 0 1 0 0 7 13 13 535.00 0 0 0 0 1 0 4 1 12 550.00 0 0 0 0 1 0 19 2 12 525.00 0 0 0 0 1 0 7 3 12 525.01 0 0 0 0 1 0 8 4 12 525.00 0 0 0 0 1 0 6 5 12 525.00 0 0 0 0 1 0 12 6 12 525.00 0 0 0 0 1 0 9 7 12 525.00 0 0 0 0 1 0 10 8 12 525.00 0 0 0 0 1 0 7 9 12 525.00 0 0 0 0 1 0 6 10 12 525.00 0 0 0 0 1 0 7 11 12 525.00 0 0 0 0 1 0 5 12 12 575.00 0 0 0 0 0 1 10 1 10 530.00 0 0 0 0 0 1 12 2 10 535.00 0 0 0 0 0 1 5 3 10 535.00 0 0 0 0 0 1 7 4 10 525.00 0 0 0 0 0 1 12 5 10 525.00 0 0 0 0 0 1 8 6 10 536.00 0 0 0 0 0 1 10 7 10 535.00 0 0 0 0 0 1 7 8 10 525.00 0 0 0 0 0 1 3 9 10 555.00 0 0 0 0 0 1 4 10 10 535.00 0 0 0 0 0 0 4 1 5 525.00 0 0 0 0 0 0 12 2 5 535.00 0 0 0 0 0 0 9 3 5 525.00 0 0 0 0 0 0 8 4 5 525.00 0 0 0 0 0 0 11 5 5 565.00 1 0 0 0 0 0 8 1 5 545.00 1 0 0 0 0 0 9 2 5 600.00 1 0 0 0 0 0 16 3 5 610.00 1 0 0 0 0 0 10 4 5 551.00 1 0 0 0 0 0 14 5 5 660.00 0 1 0 0 0 0 16 1 6 525.00 0 1 0 0 0 0 22 2 6 525.00 0 1 0 0 0 0 14 3 6 575.00 0 1 0 0 0 0 6 4 6 611.01 0 1 0 0 0 0 6 5 6 575.00 0 1 0 0 0 0 7 6 6 610.00 0 0 1 0 0 0 16 1 7 636.99 0 0 1 0 0 0 15 2 7 570.00 0 0 1 0 0 0 15 3 7 585.00 0 0 1 0 0 0 14 4 7 562.50 0 0 1 0 0 0 17 5 7 575.05 0 0 1 0 0 0 15 6 7 585.00 0 0 1 0 0 0 15 7 7 570.00 0 0 0 1 0 0 14 1 8 603.00 0 0 0 1 0 0 12 2 8 615.00 0 0 0 1 0 0 12 3 8 610.01 0 0 0 1 0 0 13 4 8 620.01 0 0 0 1 0 0 11 5 8 591.00 0 0 0 1 0 0 10 6 8 585.00 0 0 0 1 0 0 11 7 8 626.00 0 0 0 1 0 0 21 8 8 565.88 0 0 0 0 1 0 9 1 6 580.00 0 0 0 0 1 0 19 2 6 571.00 0 0 0 0 1 0 10 3 6 549.94 0 0 0 0 1 0 7 4 6 550.00 0 0 0 0 1 0 13 5 6 553.00 0 0 0 0 1 0 10 6 6 660.00 0 0 0 0 0 1 15 1 5 661.00 0 0 0 0 0 1 8 2 5 650.00 0 0 0 0 0 1 13 3 5 580.00 0 0 0 0 0 1 12 4 5 610.00 0 0 0 0 0 1 14 5 5 590.00 0 0 0 0 0 0 13 1 6 585.00 0 0 0 0 0 0 11 2 6 570.00 0 0 0 0 0 0 9 3 6 535.25 0 0 0 0 0 0 6 4 6 545.00 0 0 0 0 0 0 11 5 6 531.15 0 0 0 0 0 0 9 6 6 525.00 1 0 0 0 0 0 8 1 20 551.13 1 0 0 0 0 0 15 2 20 525.00 1 0 0 0 0 0 18 3 20 610.00 1 0 0 0 0 0 17 4 20 549.00 1 0 0 0 0 0 14 5 20 525.00 1 0 0 0 0 0 9 6 20 525.00 1 0 0 0 0 0 17 7 20 545.03 1 0 0 0 0 0 10 8 20 525.00 1 0 0 0 0 0 9 9 20 525.00 1 0 0 0 0 0 7 10 20 540.00 1 0 0 0 0 0 15 11 20 525.00 1 0 0 0 0 0 18 12 20 550.00 1 0 0 0 0 0 13 13 20 545.00 1 0 0 0 0 0 4 14 20 545.00 1 0 0 0 0 0 8 15 20 555.00 1 0 0 0 0 0 15 16 20 565.01 1 0 0 0 0 0 10 17 20 546.00 1 0 0 0 0 0 12 18 20 545.00 1 0 0 0 0 0 7 19 20 545.00 1 0 0 0 0 0 10 20 20 620.99 0 1 0 0 0 0 8 1 13 610.00 0 1 0 0 0 0 5 2 13 610.50 0 1 0 0 0 0 6 3 13 590.00 0 1 0 0 0 0 8 4 13 560.00 0 1 0 0 0 0 6 5 13 571.00 0 1 0 0 0 0 8 6 13 595.00 0 1 0 0 0 0 10 7 13 560.00 0 1 0 0 0 0 9 8 13 555.00 0 1 0 0 0 0 7 9 13 550.00 0 1 0 0 0 0 4 10 13 560.00 0 1 0 0 0 0 17 11 13 560.00 0 1 0 0 0 0 14 12 13 555.00 0 1 0 0 0 0 4 13 13 641.32 0 0 1 0 0 0 8 1 15 560.00 0 0 1 0 0 0 5 2 15 560.00 0 0 1 0 0 0 3 3 15 560.00 0 0 1 0 0 0 2 4 15 560.00 0 0 1 0 0 0 3 5 15 550.00 0 0 1 0 0 0 3 6 15 560.00 0 0 1 0 0 0 5 7 15 570.00 0 0 1 0 0 0 4 8 15 560.00 0 0 1 0 0 0 3 9 15 525.00 0 0 1 0 0 0 1 10 15 550.00 0 0 1 0 0 0 2 11 15 560.00 0 0 1 0 0 0 2 12 15 525.00 0 0 1 0 0 0 2 13 15 545.00 0 0 1 0 0 0 2 14 15 545.00 0 0 1 0 0 0 4 15 15 560.00 0 0 0 1 0 0 6 1 14 550.00 0 0 0 1 0 0 4 2 14 550.00 0 0 0 1 0 0 5 3 14 551.96 0 0 0 1 0 0 10 4 14 560.00 0 0 0 1 0 0 14 5 14 595.00 0 0 0 1 0 0 8 6 14 560.00 0 0 0 1 0 0 5 7 14 555.00 0 0 0 1 0 0 16 8 14 561.37 0 0 0 1 0 0 6 9 14 551.35 0 0 0 1 0 0 7 10 14 571.01 0 0 0 1 0 0 8 11 14 550.00 0 0 0 1 0 0 5 12 14 610.00 0 0 0 1 0 0 5 13 14 535.00 0 0 0 1 0 0 13 14 14 535.00 0 0 0 0 1 0 6 1 13 560.00 0 0 0 0 1 0 5 2 13 550.00 0 0 0 0 1 0 5 3 13 560.00 0 0 0 0 1 0 4 4 13 545.00 0 0 0 0 1 0 3 5 13 555.00 0 0 0 0 1 0 4 6 13 560.00 0 0 0 0 1 0 6 7 13 550.00 0 0 0 0 1 0 3 8 13 550.00 0 0 0 0 1 0 4 9 13 550.00 0 0 0 0 1 0 3 10 13 560.00 0 0 0 0 1 0 5 11 13 555.00 0 0 0 0 1 0 6 12 13 560.00 0 0 0 0 1 0 8 13 13 555.00 0 0 0 0 0 1 8 1 14 601.00 0 0 0 0 0 1 10 2 14 560.00 0 0 0 0 0 1 5 3 14 545.00 0 0 0 0 0 1 8 4 14 535.00 0 0 0 0 0 1 7 5 14 555.00 0 0 0 0 0 1 6 6 14 535.00 0 0 0 0 0 1 7 7 14 535.00 0 0 0 0 0 1 5 8 14 545.00 0 0 0 0 0 1 4 9 14 535.00 0 0 0 0 0 1 5 10 14 535.00 0 0 0 0 0 1 5 11 14 535.00 0 0 0 0 0 1 8 12 14 535.00 0 0 0 0 0 1 4 13 14 535.00 0 0 0 0 0 1 5 14 14 575.00 0 0 0 0 0 0 6 1 22 585.00 0 0 0 0 0 0 8 2 22 555.00 0 0 0 0 0 0 6 3 22 545.00 0 0 0 0 0 0 4 4 22 535.00 0 0 0 0 0 0 4 5 22 595.00 0 0 0 0 0 0 8 6 22 535.00 0 0 0 0 0 0 4 7 22 535.00 0 0 0 0 0 0 4 8 22 525.00 0 0 0 0 0 0 3 9 22 545.00 0 0 0 0 0 0 4 10 22 535.00 0 0 0 0 0 0 5 11 22 525.00 0 0 0 0 0 0 4 12 22 605.88 0 0 0 0 0 0 15 13 22 535.00 0 0 0 0 0 0 5 14 22 535.00 0 0 0 0 0 0 3 15 22 525.00 0 0 0 0 0 0 2 16 22 525.00 0 0 0 0 0 0 2 17 22 535.00 0 0 0 0 0 0 8 18 22 555.51 0 0 0 0 0 0 4 19 22 545.00 0 0 0 0 0 0 5 20 22 525.00 0 0 0 0 0 0 2 21 22 525.00 0 0 0 0 0 0 3 22 22 545.00 1 0 0 0 0 0 5 1 12 535.00 1 0 0 0 0 0 3 2 12 613.98 1 0 0 0 0 0 5 3 12 525.00 1 0 0 0 0 0 1 4 12 525.00 1 0 0 0 0 0 3 5 12 525.00 1 0 0 0 0 0 4 6 12 555.00 1 0 0 0 0 0 3 7 12 555.00 1 0 0 0 0 0 3 8 12 525.00 1 0 0 0 0 0 3 9 12 545.00 1 0 0 0 0 0 4 10 12 525.00 1 0 0 0 0 0 2 11 12 525.00 1 0 0 0 0 0 2 12 12 570.00 0 1 0 0 0 0 18 1 9 610.00 0 1 0 0 0 0 22 2 9 610.00 0 1 0 0 0 0 18 3 9 650.00 0 1 0 0 0 0 13 4 9 600.88 0 1 0 0 0 0 7 5 9 610.00 0 1 0 0 0 0 5 6 9 565.00 0 1 0 0 0 0 7 7 9 565.00 0 1 0 0 0 0 5 8 9 535.00 0 1 0 0 0 0 6 9 9 610.00 0 0 1 0 0 0 9 1 12 600.00 0 0 1 0 0 0 15 2 12 595.00 0 0 1 0 0 0 5 3 12 582.00 0 0 1 0 0 0 6 4 12 635.00 0 0 1 0 0 0 9 5 12 610.00 0 0 1 0 0 0 8 6 12 560.01 0 0 1 0 0 0 25 7 12 570.01 0 0 1 0 0 0 22 8 12 560.00 0 0 1 0 0 0 6 9 12 560.00 0 0 1 0 0 0 12 10 12 555.15 0 0 1 0 0 0 8 11 12 550.00 0 0 1 0 0 0 13 12 12 639.00 0 0 0 1 0 0 9 1 4 635.00 0 0 0 1 0 0 8 2 4 550.00 0 0 0 1 0 0 6 3 4 590.00 0 0 0 1 0 0 9 4 4 600.00 0 0 0 0 1 0 9 1 8 595.00 0 0 0 0 1 0 9 2 8 595.00 0 0 0 0 1 0 7 3 8 609.00 0 0 0 0 1 0 7 4 8 611.00 0 0 0 0 1 0 11 5 8 590.00 0 0 0 0 1 0 14 6 8 605.00 0 0 0 0 1 0 11 7 8 600.00 0 0 0 0 1 0 12 8 8 560.00 0 0 0 0 0 1 18 1 12 580.00 0 0 0 0 0 1 17 2 12 570.01 0 0 0 0 0 1 12 3 12 575.00 0 0 0 0 0 1 12 4 12 585.01 0 0 0 0 0 1 10 5 12 580.00 0 0 0 0 0 1 10 6 12 557.03 0 0 0 0 0 1 11 7 12 535.00 0 0 0 0 0 1 9 8 12 535.09 0 0 0 0 0 1 5 9 12 560.00 0 0 0 0 0 1 10 10 12 557.37 0 0 0 0 0 1 11 11 12 535.00 0 0 0 0 0 1 3 12 12 560.00 0 0 0 0 0 0 9 1 12 605.00 0 0 0 0 0 0 6 2 12 535.01 0 0 0 0 0 0 7 3 12 535.01 0 0 0 0 0 0 5 4 12 525.00 0 0 0 0 0 0 3 5 12 525.00 0 0 0 0 0 0 4 6 12 535.01 0 0 0 0 0 0 3 7 12 535.01 0 0 0 0 0 0 3 8 12 525.00 0 0 0 0 0 0 2 9 12 525.00 0 0 0 0 0 0 5 10 12 536.79 0 0 0 0 0 0 15 11 12 525.00 0 0 0 0 0 0 15 12 12 525.00 1 0 0 0 0 0 3 1 9 525.00 1 0 0 0 0 0 9 2 9 525.00 1 0 0 0 0 0 11 3 9 525.00 1 0 0 0 0 0 3 4 9 525.00 1 0 0 0 0 0 5 5 9 535.00 1 0 0 0 0 0 10 6 9 555.00 1 0 0 0 0 0 2 7 9 535.00 1 0 0 0 0 0 3 8 9 535.00 1 0 0 0 0 0 17 9 9 601.87 0 1 0 0 0 0 8 1 15 540.00 0 1 0 0 0 0 3 2 15 535.00 0 1 0 0 0 0 4 3 15 535.00 0 1 0 0 0 0 23 4 15 525.00 0 1 0 0 0 0 9 5 15 610.00 0 1 0 0 0 0 15 6 15 525.00 0 1 0 0 0 0 18 7 15 525.00 0 1 0 0 0 0 12 8 15 525.00 0 1 0 0 0 0 1 9 15 535.00 0 1 0 0 0 0 13 10 15 525.00 0 1 0 0 0 0 1 11 15 525.00 0 1 0 0 0 0 20 12 15 535.00 0 1 0 0 0 0 12 13 15 530.01 0 1 0 0 0 0 11 14 15 553.00 0 1 0 0 0 0 2 15 15 545.00 0 0 1 0 0 0 8 1 20 540.00 0 0 1 0 0 0 10 2 20 535.00 0 0 1 0 0 0 18 3 20 540.00 0 0 1 0 0 0 10 4 20 545.00 0 0 1 0 0 0 12 5 20 535.00 0 0 1 0 0 0 14 6 20 535.00 0 0 1 0 0 0 19 7 20 535.00 0 0 1 0 0 0 6 8 20 535.00 0 0 1 0 0 0 7 9 20 555.00 0 0 1 0 0 0 9 10 20 555.00 0 0 1 0 0 0 8 11 20 561.00 0 0 1 0 0 0 18 12 20 555.00 0 0 1 0 0 0 9 13 20 540.01 0 0 1 0 0 0 10 14 20 545.01 0 0 1 0 0 0 16 15 20 529.99 0 0 1 0 0 0 8 16 20 537.00 0 0 1 0 0 0 6 17 20 529.99 0 0 1 0 0 0 8 18 20 560.01 0 0 1 0 0 0 8 19 20 525.00 0 0 1 0 0 0 6 20 20 555.00 0 0 0 0 1 0 9 1 8 640.00 0 0 0 0 1 0 8 2 8 701.55 0 0 0 0 1 0 5 3 8 535.00 0 0 0 0 1 0 7 4 8 545.00 0 0 0 0 1 0 24 5 8 545.00 0 0 0 0 1 0 12 6 8 560.00 0 0 0 0 1 0 14 7 8 600.00 0 0 0 0 1 0 19 8 8 660.00 0 0 0 0 0 1 11 1 13 641.99 0 0 0 0 0 1 6 2 13 611.99 0 0 0 0 0 1 9 3 13 666.99 0 0 0 0 0 1 23 4 13 575.00 0 0 0 0 0 1 13 5 13 590.00 0 0 0 0 0 1 20 6 13 525.00 0 0 0 0 0 1 10 7 13 555.00 0 0 0 0 0 1 7 8 13 525.00 0 0 0 0 0 1 9 9 13 536.00 0 0 0 0 0 1 28 10 13 536.00 0 0 0 0 0 1 4 11 13 525.00 0 0 0 0 0 1 4 12 13 536.00 0 0 0 0 0 1 7 13 13 570.00 0 0 0 0 0 0 13 1 14 535.00 0 0 0 0 0 0 5 2 14 529.05 0 0 0 0 0 0 3 3 14 545.00 0 0 0 0 0 0 4 4 14 535.00 0 0 0 0 0 0 2 5 14 536.00 0 0 0 0 0 0 3 6 14 525.00 0 0 0 0 0 0 3 7 14 535.05 0 0 0 0 0 0 3 8 14 525.00 0 0 0 0 0 0 2 9 14 525.00 0 0 0 0 0 0 2 10 14 525.00 0 0 0 0 0 0 3 11 14 525.00 0 0 0 0 0 0 18 12 14 525.00 0 0 0 0 0 0 3 13 14 525.00 0 0 0 0 0 0 8 14 14 526.00 1 0 0 0 0 0 3 1 4 525.00 1 0 0 0 0 0 7 2 4 526.00 1 0 0 0 0 0 7 3 4 524.00 1 0 0 0 0 0 20 4 4 710.00 0 0 1 0 0 0 17 1 4 700.00 0 0 1 0 0 0 9 2 4 535.01 0 0 1 0 0 0 8 3 4 570.00 0 0 1 0 0 0 9 4 4 600.00 0 0 0 1 0 0 9 1 4 572.00 0 0 0 1 0 0 12 2 4 590.00 0 0 0 1 0 0 8 3 4 627.27 0 0 0 1 0 0 8 4 4 570.00 0 0 0 0 1 0 5 1 5 535.00 0 0 0 0 1 0 2 2 5 525.00 0 0 0 0 1 0 1 3 5 575.00 0 0 0 0 1 0 4 4 5 640.00 0 0 0 0 1 0 7 5 5 566.00 0 0 0 0 0 1 5 1 7 546.00 0 0 0 0 0 1 3 2 7 545.00 0 0 0 0 0 1 3 3 7 620.00 0 0 0 0 0 1 8 4 7 635.05 0 0 0 0 0 1 7 5 7 560.00 0 0 0 0 0 1 3 6 7 575.00 0 0 0 0 0 1 4 7 7 572.55 0 0 0 0 0 0 4 1 6 585.00 0 0 0 0 0 0 4 2 6 535.00 0 0 0 0 0 0 6 3 6 570.00 0 0 0 0 0 0 5 4 6 565.00 0 0 0 0 0 0 9 5 6 555.00 0 0 0 0 0 0 6 6 6 561.79 0 1 0 0 0 0 4 1 3 585.00 0 1 0 0 0 0 11 2 3 626.00 0 1 0 0 0 0 9 3 3 581.00 0 0 1 0 0 0 6 1 1 600.00 0 0 0 1 0 0 19 1 3 616.00 0 0 0 1 0 0 5 2 3 567.00 0 0 0 1 0 0 11 3 3 545.01 0 0 0 0 1 0 4 1 1 571.00 0 0 0 0 0 1 5 1 4 568.79 0 0 0 0 0 1 4 2 4 545.01 0 0 0 0 0 1 2 3 4 575.00 0 0 0 0 0 1 5 4 4 580.00 0 0 0 0 0 0 32 1 2 565.00 0 0 0 0 0 0 6 2 2 582.50 1 0 0 0 0 0 9 1 3 560.00 1 0 0 0 0 0 19 2 3 535.00 1 0 0 0 0 0 7 3 3 558.55 0 0 0 1 0 0 5 1 2 558.55 0 0 0 1 0 0 3 2 2 536.00 1 0 0 0 0 0 11 1 6 536.00 1 0 0 0 0 0 7 2 6 580.00 1 0 0 0 0 0 12 3 6 566.00 1 0 0 0 0 0 8 4 6 542.00 1 0 0 0 0 0 7 5 6 555.00 1 0 0 0 0 0 5 6 6 542.00 0 0 1 0 0 0 4 1 4 532.00 0 0 1 0 0 0 2 2 4 532.00 0 0 1 0 0 0 3 3 4 550.75 0 0 1 0 0 0 7 4 4 565.00 0 0 0 1 0 0 8 1 10 550.00 0 0 0 1 0 0 6 2 10 570.00 0 0 0 1 0 0 10 3 10 560.00 0 0 0 1 0 0 5 4 10 571.11 0 0 0 1 0 0 8 5 10 561.00 0 0 0 1 0