WEEK 4.pptx

WEEK 4: Analyzing and Visualizing Data PREPARED BY: MS. HANAN ALMUBARAK After completing this lesson, student will be able to: • Analyze data: • Create and modify tables. • Apply basic, intermediate and advanced conditional formatting. • Visualize data with charts: • Create charts. • Modify and f...

WEEK 4: Analyzing and Visualizing Data PREPARED BY: MS. HANAN ALMUBARAK After completing this lesson, student will be able to: • Analyze data: • Create and modify tables. • Apply basic, intermediate and advanced conditional formatting. • Visualize data with charts: • Create charts. • Modify and format charts. • Use advanced charts features. Analyze Data • Create and modify tables: tables can be used to organize and analyze related data. Tables will make it easy and flexible to sort, filter and format data withing a sheet. • Apply basic, intermediate and advance conditional formatting: conditional formatting makes it easy to highlight certain values or make particular cells easy to identify, this changes the appearance of a cell range based on a condition or criteria. Visualize data with charts • Create charts: charts are used to make a graphical representation of any set of data. Each chart type is suitable for specific data representation. • Modify and format charts: as users you will be able to change format and type of chart. • Use advanced charts features: advance features that enhance the reader understanding. Types of charts • Column Chart: Data that’s arranged in columns or rows on a worksheet can be plotted in a column chart. A column chart typically displays categories along the horizontal (category) axis and values along the vertical (value) axis. Types of charts • Line Chart: Data that's arranged in columns or rows on a worksheet can be plotted in a line chart. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. Line charts can show continuous data over time on an evenly scaled axis, so they're ideal for showing trends in data at equal intervals, like months, quarters, or fiscal years. Types of charts • Pie and doughnut Chart: Data that's arranged in one column or row on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. Types of charts • Doughnut Chart: Data that's arranged in columns or rows only on a worksheet can be plotted in a doughnut chart. Like a pie chart, a doughnut chart shows the relationship of parts to a whole, but it can contain more than one data series. Types of charts • Bar Chart: Data that's arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items. In a bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis. Types of charts • Area Chart: Data that's arranged in columns or rows on a worksheet can be plotted in an area chart. Area charts can be used to plot change over time and draw attention to the total value across a trend. By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole. Types of charts • X Y Scatter / bubble Chart: Data that's arranged in columns and rows on a worksheet can be plotted in an xy (scatter) chart. Place the x values in one row or column, and then enter the corresponding y values in the adjacent rows or columns. • A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data. Types of charts • Bubble Chart: Much like a scatter chart, a bubble chart adds a third column to specify the size of the bubbles it shows to represent the data points in the data series. Types of charts • Stock Chart: Data that's arranged in columns or rows in a specific order on a worksheet can be plotted in a stock chart. As the name implies, stock charts can show fluctuations in stock prices. However, this chart can also show fluctuations in other data, like daily rainfall or annual temperatures. Make sure you organize your data in the right order to create a stock chart. • For example, to create a simple highlow-close stock chart, arrange your data with High, Low, and Close entered as column headings, in that order. Types of charts • Surface Chart: data that's arranged in columns or rows on a worksheet can be plotted in a surface chart. This chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values. You can create a surface chart when both categories and data series are numeric values. Types of charts • Radar Chart: Data that's arranged in columns or rows on a worksheet can be plotted in a radar chart. Radar charts compare the aggregate values of several data series. Types of charts • Treemap Chart: The treemap chart provides a hierarchical view of your data and an easy way to compare different levels of categorization. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types. The treemap chart can be plotted when empty (blank) cells exist within the hierarchal structure and treemap charts are good for comparing proportions within the hierarchy. Types of charts • Sunburst Chart: The sunburst chart is ideal for displaying hierarchical data and can be plotted when empty (blank) cells exist within the hierarchal structure . Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. A sunburst chart without any hierarchical data (one level of categories), looks similar to a doughnut chart. However, a sunburst chart with multiple levels of categories shows how the outer rings relate to the inner rings. The sunburst chart is most effective at showing how one ring is broken into its contributing pieces. Types of charts • Box and Whisker Chart: A box and whisker chart shows distribution of data into quartiles, highlighting the mean and outliers. The boxes may have lines extending vertically called “whiskers”. These lines indicate variability outside the upper and lower quartiles, and any point outside those lines or whiskers is considered an outlier. Use this chart type when there are multiple data sets which relate to each other in some way. Types of charts • Waterfall Chart: A waterfall chart shows a running total of your financial data as values are added or subtracted. It's useful for understanding how an initial value is affected by a series of positive and negative values. The columns are color coded so you can quickly tell positive from negative numbers. Types of charts FUNNEL CHART: FUNNEL CHARTS SHOW VALUES ACROSS MULTIPLE STAGES IN A PROCESS. Types of charts • Combo Chart: data that's arranged in columns and rows can be plotted in a combo chart. Combo charts combine two or more chart types to make the data easy to understand, especially when the data is widely varied. Shown with a secondary axis, this chart is even easier to read. In this example, we used a column chart to show the number of homes sold between January and June and then used a line chart to make it easier for readers to quickly identify the average sales price by month. Types of charts • Map Chart: You can use a Map Chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. • For example, Countries by Population uses values. The values represent the total population in each country, with each portrayed using a gradient spectrum of two colors. The color for each region is dictated by where along the spectrum its value falls with respect to the others. The End of lesson