Question in analyze data tool

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172051%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EQuestion%20in%20analyze%20data%20tool%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172051%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EWhat%20are%20the%20kind%20of%20question%20you%20can%20ask%20in%20the%20box%20%22Ask%20a%20question%20about%20your%20data%22%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348639i8B9BF3E86DCBABD0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Robbie79_0-1644998777472.png%22%20alt%3D%22%5C%26quot%3BRobbie79_0-1644998777472.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFor%20example%20can%20you%20ask%20for%20a%20frequency%20plot%20of%20a%20certain%20data%20element%3F%20Is%20there%20a%20list%20of%20possible%20questions%2Fcommands%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172051%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3172051%22%20slang%3D%22en-US%22%3EQuestion%20in%20analyze%20data%20tool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3172051%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20are%20the%20kind%20of%20question%20you%20can%20ask%20in%20the%20box%20%22Ask%20a%20question%20about%20your%20data%22%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Robbie79_0-1644998777472.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348639i8B9BF3E86DCBABD0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Robbie79_0-1644998777472.png%22%20alt%3D%22Robbie79_0-1644998777472.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFor%20example%20can%20you%20ask%20for%20a%20frequency%20plot%20of%20a%20certain%20data%20element%3F%20Is%20there%20a%20list%20of%20possible%20questions%2Fcommands%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3172051%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

What are the kind of question you can ask in the box "Ask a question about your data"?

Robbie79_0-1644998777472.png

For example can you ask for a frequency plot of a certain data element? Is there a list of possible questions/commands?

3 Replies

@Robbie79 

Analyze Data in Excel

Use the Analysis ToolPak to perform complex data analysis

 

Maybe this link will help you, if not just ignore it.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@NikolinoDEthe links are not answering the question I have. But thanks for the effort

Hi @Robbie79, thanks for reaching out about this. 

We don't have a comprehensive list of queries we cover, but you can see the latest blog for some examples: Better insights from Analyze Data feature in Excel (office.com)

Since you were asking about frequency plots, yes, you can ask something like "frequency of sales" or just "frequency" to see what histograms we can produce for you.

Let me know if you have any other questions about the feature.