This section describes the basic statistical functions that come with Excel. To see which functions Excel provides or to see which arguments a function requires, click the Paste Function toolbar button and then select Statistical from the Function Category list box (see Figure 4-1). Once … [Read more...] about Statistical Formulas in Excel
Articles
Easy Refresher: Basic Business Statistics
To determine which function to use and to insert the correct variables in the correct places, you need to know some key statistical terms. This section describes these terms. The science of statistics makes a fundamental distinction between two types of data sets, population data and sample data. … [Read more...] about Easy Refresher: Basic Business Statistics
Quick Primer on Charting: Mapping Geographic Data
Excel includes a useful tool for mapping geographic data. The Microsoft Map tool that comes with Excel (but often isn’t installed until you first attempt to use it) makes to easy create charts that show data using maps. The following section describes how to add the Map button to the toolbar. The … [Read more...] about Quick Primer on Charting: Mapping Geographic Data
Quick Primer on Charting: Presenting Data With Charts
Once you understand the terms that Excel uses to describe to-be-charted data and the parts of a chart, you can easily create charts. In essence, you need to simply select the worksheet data you want to chart, indicate where Excel should place the chart, and then tell the Chart Wizard to create the … [Read more...] about Quick Primer on Charting: Presenting Data With Charts
Quick Primer on Charting: Understanding Excel’s Charting Terms
In order to easily work with Excel’s Chart Wizard, you’ll want to learn both how Excel views to-be-plotted data and the terminology that Excel uses to refer to the parts of a chart. How Excel Sees Chart Data To easily use Excel for charting, you need to learn three key terms: data points,data … [Read more...] about Quick Primer on Charting: Understanding Excel’s Charting Terms
Quick Primer on Excel: Printing Workbooks
Excel provides you with a wide variety of printing and presentation options, which is fortunate. As you move beyond the work of collecting and analyzing quantitative information, you’ll usually want to share your information with others—typically by printing it. Tip: If you want to print a … [Read more...] about Quick Primer on Excel: Printing Workbooks