Calculate P-Value for multiple products using Linear Regression tools

Huyly0325

My data has multiple product sale in a time series. For each product, I want to calculate the P-Value. In the example, I have 2 products with 250 points of sale data.

I used Linear Regression and R tool to extract for P-Value of 1 product only.

Is there a way to calculate the P-Value of multiple products at the same time? My data set has 1000+ products.

I'm looking for the output as below:

Product	P-Value
1	0.00005
2	0.0002
3	0.00008
4	0.0004

Linear Regression for multiple set of records.yxmc

Test.xlsx

Qiu

@Huyly0325 
I dont know much about Leanear Regression, but It seems that a Batch Macro might be working for this case.

Linear Regression for multiple set of records-r1.yxzp