User Profile
MarGines
MicrosoftJoined Oct 01, 2018
User Widgets
Recent Discussions
Re: help with analyzing data
Thanks your question. Have you tried asking "are there any trends" in the input box? Would it be possible for you to share more about the columns you have and the kind of data they contain? That'd make it easier to figure out how Analyze DAta can better help you.1KViews0likes0CommentsRe: Question in analyze data tool
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.1.1KViews1like0CommentsRe: Analyze Data tool
The Data Analysis add-in should be in the Data tab in the ribbon. It appears you might be selecting Analyze Data in the Home tab, which is a different feature that offers statistically significant analysis, summaries and visualizations, as well as the ability to ask data questions using English. Thank you for posting your question.958Views0likes0CommentsRe: Regression Menu
The Data Analysis add-in should be in the Data tab in the ribbon. It appears you might be selecting Analyze Data in the Home tab, which is a different feature that offers statistically significant analysis, summaries and visualizations, as well as the ability to ask data questions using English. Thank you for posting your question. I hope this is helpful.833Views0likes0CommentsRe: Analyze Data - Help with Structuring Data to Improve Analysis
skeskali We currently don't have documentation of the sort you describe. Based on the structure of the data, we aren't able to understand "for each year". I think that asking: "top istat based on year 2017 for each location" would give you what you want, but you'd need to ask the same question for each year. We'll explore how to improve this scenario. Best, Mar1.4KViews0likes0CommentsRe: Analyze Data - Help with Structuring Data to Improve Analysis
Sorry that didn't work. I wasn't suggesting you changed the structure of your data, just that the scenarios for which we have optimized the feature so far typically have dates grouped in columns. We continue to iterate and improve the quality of the feature and we'll incorporate your feedback as we do so. Thanks again for reaching out, skeskali Mar1.5KViews0likes2CommentsRe: Analyze Data - Help with Structuring Data to Improve Analysis
skeskali Thanks for sending a question about the Analyze Data feature. Analyze Data can’t currently create suggestions based on PivotTables, so you’ll want to make sure you are running it on your original data. If you have a column for each of the years, you’ll want to mention each one specifically, for example: 2017, 2018, 2019 and 2020 by item class as column chart (or a different chart type). Note that it's easier to ask questions over time when you have a single column with multiple date values. If this doesn't work, you might want to make sure your data is formatted as a table. Please select all of it and click on Format as Table in the Home tab and then try Analyze Data again. Let us know if this doesn’t solve your issue. Thanks for your feedback, Mar1.3KViews0likes4Comments
