Advanced Summary by Awesome Table vs XLMiner Analysis ToolPak

Discover a powerful tool to save time analyzing Google Forms™ data. Advanced Summary allows you to dig deeper into your Google Forms™ responses. Using intuitive filters, you can make the most of your charts and data by isolating variables and segments that are important to you. Native charts on Google Forms™ won’t give you anywhere near this level of flexibility. With Advanced Summary, you can quickly summarize your responses data by any field of responses you’ve collected - things like location, department, or age. Advanced Summary is built on Awesome Table, a Google Sheets add-on with over 10 million installations and a 4.6/5 rating on the Google Workspace Marketplace. Click the install button above to start using Advanced Summary. GETTING STARTED Turn your Google Form™ responses into filterable charts in a few steps. Install the Advanced Summary add-on from the Google Workspace Marketplace. Open the Google Form™ that you want to use. Then select (a) Add-ons (it looks like a puzzle piece) > (b) Advanced Summary by Awesome Table > (c) click Create Advanced Summary. Select the questions that you want to include in the Awesome Table. (Optional) Add or remove filters. (Optional) Add, modify or remove charts. USE CASES ➤ Academic research: conduct deeper analysis of your research. Intuitive filters allow you to isolate responses and variables to see how they impact other parts of your data. ➤ Community building: understand your community better. Slice and dice survey results to see how variables like age, experience, and equipment affect preferences. ➤ Education: filter through teacher feedback and easily group results by teaching grade, subject, location, or any variable that's meaningful to you. ➤ Businesses and entrepreneurs: save time analyzing user survey data with improved filtering of results based on demographic and psychographic information you've collected. MAIN BENEFITS AND FEATURES ➤ Filters and search: your Advanced Summary will include a selection of interactive filters and searches for your users to easily find the exact information they want. This isn’t possible with the native charts in the Google Forms™ Summary tab. ➤ Embed anywhere: embed your Advanced Summary on any site, including Google Sites, WordPress, Microsoft Teams, Sharepoint, Lumapps, Happeo, Wix, Confluence, Weebly, and Squarespace. ➤ Automatic charts: Advanced Summary will automatically find the most appropriate chart type for each Google Form™ section whether it’s a pie chart, word cloud, table that shows off the top five or ten results in a given column, or a selection of other visualizations. ➤ Customization: each Advanced Summary is connected to a spreadsheet just like any Awesome Table. If you want to change the type of chart being displayed then you just need to change the keyword on the spreadsheet! ➤ Safe and secure: Advanced Summary never uploads your data to our servers. They are fetched at display time from your browser. The ADVANCED SUMMARY ADVANTAGE ➤ Much more customizable than native Google Forms™ charts and much easier to configure than creating separate charts via Google Sheets or Excel. ➤ Advanced Summary users have access to Awesome Table’s world-class customer support team that works around the clock. ➤ Advanced Summary is built by the company behind Awesome Table, AODocs, YAMM, and Form Publisher, which has some of the best Google Workspace expertise in the world. PRICING ➤ Free Plan: 500 pageview limit ➤ Paid apps start at $39 / user / month More options on our pricing page: https://awesome-table.com/pricing HELP CENTER Do you need some help with Advanced Summary? Please contact the Awesome Table support team at https://support.awesome-table.com/hc/en-us/requests/new PRIVACY - DATA SECURITY Please find all the information you need about privacy here: https://support.awesome-table.com/hc/en-us/articles/360001374519 FOOTNOTES Google Form™ is a trademark of Google LLC

With the XLMiner Analysis ToolPak Add-on, you can easily perform statistical analyses of the same types available in the Analysis ToolPak add-in that has been part of Microsoft Excel for over 20 years, and has been featured in large numbers of textbooks, videos, statistics courses and the like. The add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression. Sidebar input fields and output on the spreadsheet will be very familiar to Excel Analysis ToolPak users. The 20 functions are: ANOVA: Single Factor ANOVA: Two-Factor with Replication ANOVA: Two-Factor without Replication Correlation Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Linear Regression Logistic Regression Moving Average Random Number Generation Rank and Percentile Sampling t-Test: Paired Two-Sample for Means t-Test: Two-Sample Assuming Equal Variances t-Test: Two-Sample Assuming Unequal Variances z-Test: Paired Two-Sample for Means Results will generally match the Excel Analysis ToolPak, as seen in many textbooks, screen images and videos. The add-on's Random Number Generation function uses the Mersenne Twister algorithm.