anatech .pdf

Analytics - process of discovering, interpreting, - Where you enter formulas and functions and communicating meaningful patterns in data Sheets Tabs - Allows you to organize your data Key aspects of analytics:...

Analytics - process of discovering, interpreting, - Where you enter formulas and functions and communicating meaningful patterns in data Sheets Tabs - Allows you to organize your data Key aspects of analytics: Sorting - arrange data alphabetically or numerically - Data Collection - Data Cleaning and Preparation. Filtering - Show only specific data based on - Data Analysis criteria - Data Visualization conditional formatting - when the formatting - Interpretation and Communication characteristics of the data set changes when four types of data analytics: user-specified conditions are met - Descriptive Analytics: focused on colon (:) - create a reference to a range of cells summarizing and describing, answers the commas - separate individual values, cell question "What happened?" references, and cell ranges - Diagnostic Analytics: goes deeper into the data to understand why something sort sheet - organizes all of the data in your happened, answers the question "Why did it spreadsheet by one column happen?" sort range - sorts the data in a range of cell - Predictive Analytics: uses statistical models and machine learning algorithms to column chart - uses bars of varying heights to forecast future outcomes, answers the illustrate data in a worksheet question "What will happen?" line chart - uses points connected by a line - Prescriptive Analytics: focused on recommending actions to take based on the pie chart - shows the relationship of parts of a insights gained, answers the question "What whole should we do?" scatter chart - uses dots to show the relationship - cartesian graph - It is just two number lines that Google Sheets - free, web-based spreadsheet cross at 0 application developed by Google - part of the Google Workspace productivity heatmap - individual values contained in a matrix suite and offers a versatile platform for are represented as colors. creating, editing, and collaborating on parallel coordinate graph - plotting multivariate spreadsheets online. numerical data and a common way of visualizing spreadsheet - layout of information arranged in high-dimensional geometry. row and columns in a table box plot - displays the five-number summary of a columns - vertical lines labeled with letters set of data. The five-number summary is the minimum, first quartile, median, third quartile, and rows -horizontal lines labeled with numbers maximum. cells - intersection of a row and a column, where Summary Statistics: Using functions like you enter your data AVERAGE, SUM, COUNT, MAX, MIN cell name - consists of the column letter and the Frequency Distributions: Creating tables or row number charts to show how often different values occur cell range - group of cells Cross-tabulation: Summarizing data across two or Toolbar - contains menus and buttons for various more variables to reveal relationships. functions (formatting, inserting charts, etc.) Data Visualization: Using various charts (bar, pie, Formula Bar - Displays the contents of the line, etc.) currently selected cell Pivot Tables: Creating interactive tables to summarize, filter, and explore data from different angles. Drill-Down Analysis: Exploring data at increasingly granular levels to identify root causes. Conditional Formatting: Using colors or icons Data Validation: Setting rules to ensure data quality and prevent errors. Trend Analysis: Identifying patterns over time to predict future values or behaviors. Regression Analysis: Using statistical models to predict relationships between variables. Forecasting: Predicting future trends using historical data and forecasting techniques. Goal Seek: Finding the input value needed to achieve a desired output. Solver: Finding the optimal solution to a problem with multiple constraints. What-If Analysis: Exploring the impact of changing variables on outcomes.