Question

1 Approved Answer

Posted on Oct 07, 2024

winning bid ( $ ) sun mon tue wed thu fri # bids rank- in -day # auctions 535.00 0 0 0 1 0 0

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 SUMMARY OUTPUT 525.00 0 0 0 0 0 1 8 6 10 536.00 0 0 0 0 0 1 10 7 10 Regression Statistics 535.00 0 0 0 0 0 1 7 8 10 Multiple R 0.461131 525.00 0 0 0 0 0 1 3 9 10 R Square 0.212642 555.00 0 0 0 0 0 1 4 10 10 Adjusted R Square 0.201159 535.00 0 0 0 0 0 0 4 1 5 Standard Error 31.67757 525.00 0 0 0 0 0 0 12 2 5 Observations 488 535.00 0 0 0 0 0 0 9 3 5 525.00 0 0 0 0 0 0 8 4 5 ANOVA 525.00 0 0 0 0 0 0 11 5 5  df SS MS F Significance F 565.00 1 0 0 0 0 0 8 1 5 Regression 7 130083.2 18583.31 18.51908 7.15E-22 545.00 1 0 0 0 0 0 9 2 5 Residual 480 481664.8 1003.468 600.00 1 0 0 0 0 0 16 3 5 Total 487 611748    610.00 1 0 0 0 0 0 10 4 5 551.00 1 0 0 0 0 0 14 5 5  Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%660.00 0 1 0 0 0 0 16 1 6 Intercept 550.1364 4.221853 130.3069 0 541.8408 558.432 541.8408 558.432525.00 0 1 0 0 0 0 22 2 6 X Variable 1 13.15889 5.009014 2.627041 0.008889 3.316584 23.00119 3.316584 23.00119525.00 0 1 0 0 0 0 14 3 6 X Variable 2 19.23145 4.611888 4.169973 3.62E-05 10.16947 28.29343 10.16947 28.29343575.00 0 1 0 0 0 0 6 4 6 X Variable 3 18.99983 4.765821 3.986685 7.74E-05 9.635377 28.36428 9.635377 28.36428611.01 0 1 0 0 0 0 6 5 6 X Variable 4 20.68547 4.669282 4.430119 1.17E-05 11.51072 29.86023 11.51072 29.86023575.00 0 1 0 0 0 0 7 6 6 X Variable 5 13.51221 4.372878 3.090004 0.002118 4.919864 22.10456 4.919864 22.10456610.00 0 0 1 0 0 0 16 1 7 X Variable 6 1.498683 0.291226 5.146122 3.88E-07 0.926448 2.070917 0.926448 2.070917636.99 0 0 1 0 0 0 15 2 7 X Variable 7 -2.30508 0.338148 -6.81677 2.8E-11 -2.96951 -1.64064 -2.96951 -1.64064570.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 0 5 6 10 550.00 0 0 0 1 0 0 4 7 10 560.00 0 0 0 1 0 0 5 8 10 560.00 0 0 0 1 0 0 9 9 10 560.00 0 0 0 1 0 0 7 10 10 545.00 0 0 0 0 1 0 7 1 5 560.00 0 0 0 0 1 0 4 2 5 545.00 0 0 0 0 1 0 4 3 5 556.00 0 0 0 0 1 0 6 4 5 631.99 0 0 0 0 1 0 6 5 5 539.99 0 0 0 0 0 1 4 1 11 529.99 0 0 0 0 0 1 2 2 11 549.99 0 0 0 0 0 1 4 3 11 549.99 0 0 0 0 0 1 3 4 11 559.99 0 0 0 0 0 1 4 5 11 549.99 0 0 0 0 0 1 4 6 11 549.99 0 0 0 0 0 1 3 7 11 549.99 0 0 0 0 0 1 2 8 11 555.00 0 0 0 0 0 1 4 9 11 545.00 0 0 0 0 0 1 3 10 11 549.99 0 0 0 0 0 1 3 11 11 549.99 0 0 0 0 0 0 9 1 10 559.00 0 0 0 0 0 0 6 2 10 559.00 0 0 0 0 0 0 15 3 10 522.01 0 0 0 0 0 0 10 4 10 560.00 0 0 0 0 0 0 11 5 10 540.00 0 0 0 0 0 0 5 6 10 550.00 0 0 0 0 0 0 5 7 10 560.00 0 0 0 0 0 0 7 8 10 550.00 0 0 0 0 0 0 6 9 10 560.00 0 0 0 0 0 0 5 10 10 550.00 1 0 0 0 0 0 5 1 7 536.01 1 0 0 0 0 0 5 2 7 523.00 1 0 0 0 0 0 6 3 7 570.00 1 0 0 0 0 0 4 4 7 551.00 1 0 0 0 0 0 5 5 7 570.10 1 0 0 0 0 0 9 6 7 556.01 1 0 0 0 0 0 12 7 7 561.00 0 1 0 0 0 0 7 1 4 539.99 0 1 0 0 0 0 3 2 4 536.00 0 1 0 0 0 0 2 3 4 536.00 0 1 0 0 0 0 2 4 4 560.00 0 0 1 0 0 0 8 1 6 680.00 0 0 1 0 0 0 1 2 6 590.00 0 0 1 0 0 0 11 3 6 560.00 0 0 1 0 0 0 6 4 6 600.00 0 0 1 0 0 0 9 5 6 560.00 0 0 1 0 0 0 9 6 6 582.00 0 0 0 1 0 0 9 1 6 603.00 0 0 0 1 0 0 11 2 6 590.00 0 0 0 1 0 0 7 3 6 570.00 0 0 0 1 0 0 6 4 6 511.00 0 0 0 1 0 0 5 5 6 574.00 0 0 0 1 0 0 12 6 6 711.55 0 0 0 0 1 0 13 1 10 750.00 0 0 0 0 1 0 21 2 10 536.00 0 0 0 0 1 0 7 3 10 525.00 0 0 0 0 1 0 5 4 10 620.01 0 0 0 0 1 0 10 5 10 680.00 0 0 0 0 1 0 10 6 10 660.00 0 0 0 0 1 0 10 7 10 590.00 0 0 0 0 1 0 7 8 10 595.00 0 0 0 0 1 0 10 9 10 570.05 0 0 0 0 1 0 5 10 10 553.00 0 0 0 0 0 1 12 1 6 550.00 0 0 0 0 0 1 13 2 6 569.99 0 0 0 0 0 1 11 3 6 590.00 0 0 0 0 0 1 11 4 6 575.00 0 0 0 0 0 1 10 5 6 570.00 0 0 0 0 0 1 18 6 6 610.00 1 0 0 0 0 0 5 1 5 640.00 1 0 0 0 0 0 14 2 5 560.00 1 0 0 0 0 0 10 3 5 530.00 1 0 0 0 0 0 12 4 5 570.00 1 0 0 0 0 0 9 5 5 560.00 0 1 0 0 0 0 15 1 6 535.00 0 1 0 0 0 0 27 2 6 520.00 0 1 0 0 0 0 8 3 6 545.00 0 1 0 0 0 0 5 4 6 521.00 0 1 0 0 0 0 3 5 6 585.00 0 1 0 0 0 0 8 6 6 560.00 0 0 1 0 0 0 9 1 1

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 ofa 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) 1! 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 thevariables included in the model collectively explain a signicant amount ofthe variation in winning bids? Cite the appropriate test, test statistic, p-value, and your conclusion at the a = .05 level. b. Is there a relationship between the winning bid price and the rank ofthe auction (in this model)? Cite an appropriate test, your test statistic, p -value, and your conclusion at the a = .05 level. c. What is the price difference between a Dell laptop auctioned on Saturday and one auctioned on Sunday (all otherthings remaining equal}? Is this difference =2 $0? Cite the relevant test statistic, the p - value, and your conclusion at the a =.05 level