A company has recorded data on the weekly sales for its prod…
A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of seven weeks follows. Use Excel to:a.Compute a 95% confidence interval for expected sales for all weeks when the competitor’s price is 0.30.b.Compute a 95% prediction interval for sales for a week when the competitor’s price is 0.30. WeekPriceSales 10.3320 20.2514 30.4422 40.4021 50.3516 60.3919 70.2915