How to use Google Sheets and perform AI as percentile should be calculated which will be used in AI? An example:
Should we use our own application as an external source which will read Google Sheet and connect to AI service?
Did… you consider looking it up in Google sheets?
Returns the value at a given percentile of a dataset. Sample Usage PERCENTILE(A2:A100,A2) PERCENTILE(A2:A100,0.67) Syntax PERCENTILE(data, percentile) data - The array or range
Literally googling “percentile google sheets” returns this as the first link.
It is not an issue to use Percentile function but written AI text which pushes an output. As I understand AI is supported by application but needs automatic trigger. One solution is use of AI Agent which will respond to content related to Google Sheet.
Throwing the letters “AI” into the post dont tell me anything. AI is a general area of computing.
Are you using a specific piece of software?
I will check software if AI agent can manage and read tables.