Necessary data is included in the Excel file. Please help me answer these few statistics questions. Thank you.
1. Complete a regression analysis of the relationship.
2. Estimate the winning bid if there were seven bidders. (Round your answer to 4 decimal places.)
3. Compute the 95% prediction interval for a winning bid if there are seven bidders.