A supermarket sells pre-packaged bags of spices.A customer wants to determine if there is a linear relationship between theprice ($/gram) of a bag of spices and the weight (grams) per bag.The customer collects a random sample of bags and records thepriceandweight.

Excel was then used to establish a simple linear regression ofpriceonweight. Here is a table of the sample data, with the Excel regression output:

Weight (grams) Price ($/gram) SUMMARY OUTPUT 250 15 1,000 10 Regression Statistics 4,000 7 Multiple R 0.8793823 1,000 10 R Square 0.7733132 350 13 Adjusted R Square |0.7582008 500 12 Standard Error 1.6860956 5,000 6 Observations 17 1,000 10 5,000 6 ANOVA 1,000 10 df MS F Significance F 350 16 Regression 1 145.473869 145.5 51.1706 3.319E-06 5,000 6 Residual 15 42.6437781 2.843 500 12 Total 16 188.1176471 400 15 4,000 7 Coefficients Standard Error t Stot P-value Lower 95% Upper 95% 1,000 10 Intercept 13.481395 0.575159301 23.44 3.1E-13 12.255472 14.707318 500 15 Weight (grams) -0.001594 0.000222872 -7.153 3.3E-06 -0.0020693 -0.0011192