Prepping your data To prep your data for a line plot graph, follow these steps: 1. Chapter 5: Managing Data: I Can Do That? A simple example of when you might use this task is to transpose a table that has four rows and two columns for example, Quarter and Sales to one row and four columns one column for each unique quarter. See Chapter 15 for more information on how to set up data sources for efficient access. Ranked order No of records, percentile ranks of records, decile ranking of records, quartile ranking of records, ntiles ranking of records, percentages, six advanced ranking methods Sum, Average, Count, Distinct Count, N, Max, Min, Range, Number Missing, Variance, Standard Error, about 20 others Statistics Available continued A specialized task for creating output data sets that have ranked a variable with one of the specified methods for further analysis, reporting, or graphing. You can click anywhere on the value row to select the desired value. A normal distribution is the most commonly used distribution in statistical analysis; it is often referred to as a bell-shaped curve.
Click the Add Tables button in the upper-left quarter of the task. Note that an in-depth understanding of general principles in each analytic area is beyond the scope of this book, but is crucial to getting the most from these techniques. Chapter 5: Managing Data: Can I Do That? The Specify the Engine for the Library page appears, as shown in Figure 4-12. Feel free to try these later; the process is similar with slightly different functionality, depending on the file type. Large is a relative term, but any source with more than 10,000 records also referred to as rows, observations, or data points of data can probably be considered large for this purpose.
Chapter 5: Managing Data: Can I Do That? After you open a wizard in advanced mode and save it, you can open it only in task form. Action is a relative term; after all, this is business and analytical software, not World of Warcraft. When in doubt, think long and hard about what you need to say with your graph before proceeding. Bubble plots Bubble plots are a specialized form of a scatter plot, using bubbles of various sizes rather than points for each data point. You can quickly find the most and least populous states and their proximity to one another. Units appears in the Expression Text at the top of the dialog box. The default behavior is the option to output a data set.
A specialized wizard that analyzes every variable in a data set or every data set in a library and prints a concise report and analysis of every variable for quick data review. Simple listings, summarizations, and cross-tab reports begin to tease that story apart. Clear the Include Ranking Values check box. Click Titles, click Report Titles, uncheck Use Default Text, and change the report title to Product Sales Ranking by Year. Chapter 11 discusses how to select the appropriate report format for sharing results in different ways.
Right-click the graph to see the available editing capabilities. According to multiple studies by graphing experts, accurately interpreting a donut chart is very difficult for most people. Example query: Part one Follow these steps to join the three sample tables and create an output table that includes a new computed column: 1. Figure 4-12: Enter the path where your data is located. Right-click the Import Data task and then choose Modify. When you master the basics of the Filter and Query task, your success at accessing the data you need will know no limits! Click the second field to reveal the list of comparison operators. The text element is added to the report layout, below the List Report output.
Right-click the graph to see the available editing capabilities. The Box Plot task appears, displaying the Box Plot type selection pane. The summary tables task makes it easy to create a wide array of summary reports using a highly flexible layout pane that includes the most commonly used statistics. To create this chart, follow these steps: 1. For example, you could display the numeric value 419184523 as a Social Security number 419-18-4523 or 9192449876 as a phone number 919-244-9876. The Line Plot task appears, displaying the Line Plot type selection pane. Administered data: One version of the truth Consider a simple report of sales invoices, which includes data from customer, shipping, and returns systems.
Figure 4-1: Start importing data here. This example illustrates some of the most commonly used data management tasks. This section shows how to get simple statistics for numeric variables. A hi-lo plot or a hi-lo-close plot can show the high, low, and closing price of a stock over time. Study up and impress your friends! A good example would be a bar chart of sales by region for the current year, as shown in Figure 7-1. Thanks to all of you for helping me, encouraging me, and supporting me throughout the years! You can also rearrange the table layout for easier reference in the Tables and Joins dialog box. After your join is set the way you want it, you can create computed columns with your data, a topic discussed in the following section.
To ensure that you have a solid grasp of forecasting principles, be sure to read Chapter 9. Try to avoid this output type because of its many shortcomings. Chapter 5: Managing Data: I Can Do That? In the Process Flow or Project Tree, right-click the task for which you want to specify a special type and then click Properties to open the Properties dialog box. Chapter 5: Managing Data: I Can Do That? When subsetting your data, select only the variables needed for your next tasks. Foolish Assumptions To better manage the task of writing this book, we had to begin with some assumptions about you, the reader.
Well, you might want to reserve some space in your memory banks for the content next to the Remember icon. Click the Local Computer Icon. You can now navigate the standard Windows file system. To achieve this, use the Query Builder task: a. The West region has the most variable average order amount, whereas the Central and East regions average order amounts correlate more smoothly with their total sales for each month. This section describes each task in more detail.
All rows and variables are used from every table, and the tables are combined or figuratively stacked one on top of the other. Click Titles, click Report Titles, deselect the Use Default Text check box, and change the report title to Product Sales Ranking by Year. The Rank dialog box appears. At ThriftBooks, our motto is: Read More, Spend Less. Figure 3-21: Forecast Options settings for the Basic Forecasting task.