David B. answered 01/31/23
Math and Statistics need not be scary
First the basics. You are examining Bivariate data which implies a regression analysis. The test statistic for the parameters will be a t distribution, NOT a z distribution. Also you need to do a regression. Your Z values would not be needed . Also, they seem to be Z values for a 99 % confidence interval.
Since you do NOT know the population parameters you need to estimate them from the sample. Here are the parameters for your bivariate data, and the estimates (96% confidence interval) of the prices.
mean ppm =. 3.208333 mean price. 296.2725
PPM lwr upr
1 2.1 142.5401 277.4666
2 3.1 250.6984 324.9819
3 4.1 307.1824 424.1716
Using R the following code will produce the answer.
NOTE: if you are expected to do this by hand you can calculate it with the correct formula. See https://rpubs.com/aaronsc32/regression-confidence-prediction-intervals#:~:text=Confidence%20(Mean)%20Intervals&text=To%20find%20the%20confidence%20interval,to%20output%20the%20mean%20interval. for a good example.
here is the r code which will calculate the above