I have seen some tools for statistical analysis and formula generation in Excel, and they are free of charge

Your requirement is to be able to automatically add rows (add corresponding formulas to calculate the corresponding data) or filter data through AI, which may allow AI to create a new data (automatically generate corresponding rows and make the data simpler)

AI analysis Excel is usually done by writing code to complete the analysis and finally making a summary