Excel 2013 Data Analysis

View:  
Sorted by:  

How to Use the Goal Seek Feature in Excel 2013

When you need to do analysis, you use Excel 2013’s Goal Seek feature to find the input values needed to achieve the desired goal. Sometimes when doing what-if analysis, you have a particular outcome in [more…]

How to Use the Scenario Manager in Excel 2013

Excel 2013’s Scenario Manager option on the What-If Analysis button’s drop-down menu on the Data tab of the Ribbon enables you to create and save sets of different input values that produce different calculated [more…]

How to Produce a Summary Report in Excel 2013

You can use the Summary button in the Scenario Manager dialog box of Excel 2013 to create a summary report that shows the changing values used in each scenario and, if you want, key resulting values that [more…]

The Solver Add-In Utility for Excel 2013

When dealing with complex problems in Excel 2013, you might need to use the Solver add-in. For example, use the Solver to find the best solution when you need to change multiple input values in your model [more…]

Set Up and Define Problems in Excel's Solver Add-In Utility

The first step in setting up a problem in Excel 2013 for the Solver add-in utility to work on is to create the worksheet model for which you will define the objective cell, variables cells, and the constraint [more…]

Stem-and-Leaf Plots Present a Distribution of Scores in Excel

Stem-and-leaf displays organize data so that an entire distribution of scores is quickly and easily comprehensible. The display breaks each score into two components: a [more…]

Box-and-Whisker Charts for Excel

Excel doesn’t offer a box-and-whisker chart. Instead, you can cajole a type of Excel chart into boxes and whiskers. Instead of showing the mean and the standard error, the [more…]

Data Smoothing in Excel

Statisticians typically have to look at large masses of data and find hard-to-see patterns. Sometimes an overall trend suggests a particular analytic tool. And sometimes that tool, although statistically [more…]

How to Perform Analyses of Variance with Two Kinds of Variables

What happens when you are performing analyses of variance (ANOVA) and you have a Between Groups variable and a Within Groups variable . . . at the same time? How can that happen? [more…]

How to Perform Analyses of Variance in Excel

Someday, Excel’s Analysis ToolPak might have a choice labeled ANOVA: Mixed Design. That day, unfortunately, is not today. To run two ANOVAs on the same data and combine the ANOVA tables, follow these steps [more…]

How to Graph the Results of Analyses of Variance in Excel

Because analyses of variance (ANOVA) isn’t a built-in tool, Excel doesn’t produce the descriptive statistics for each combination of conditions. You have to have those statistics [more…]

Post-Analysis after an Analysis of Variance

A significant result in an analysis of variance (ANOVA) in Excel tells you that an effect is lurking somewhere in the data. Post-analysis tests tell you where. Two types of tests are possible — either [more…]

Analysis of Variance for Mac Users of Excel

You can use StatPlus LE to do analysis of variance in Excel on a Mac. The first thing you have to do, however, is rearrange the data the way StatPlus likes it — in columns. The second thing is to recode [more…]

Improve Your Excel Reports with Sparklines

Much of the reporting done in Excel is table-based, in which precise numbers are more important than pretty charts. However, in table-based reporting, you often lose the ability to show important aspects [more…]

3 Types of Sparklines for Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. Although sparklines look like miniature charts (and can sometimes take the place of a chart), this feature is completely [more…]

How to Create Sparklines in Your Excel Dashboards

Sparklines in Excel enable you to see trends and patterns within your data at a glance using minimal real estate on your dashboard. Sparklines are essentially mini word-sized charts placed in and among [more…]

Use Sparkline Groups in Your Excel Dashboards and Reports

Sparklines in Excel enable you to see trends and patterns within your data at a glance using minimal real estate on your dashboard. Most of the time, you’ll probably create a group of sparklines — one [more…]

Excel Dashboards and Reports: Size and Merge Sparkline Cells

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you activate a cell that contains a sparkline, Excel displays an outline around all the sparklines in its [more…]

Customize Sparklines in Your Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you activate a cell that contains a sparkline, Excel displays an outline around all the sparklines in its [more…]

Adjust Sparkline Axis Scaling in Excel Dashboards and Reports

Sparklines give you the ability to show data trends in your Excel dashboards and reports. When you create one or more sparklines, they all use (by default) automatic axis scaling. In other words, Excel [more…]

Excel Dashboards and Reports: Fake a Sparkline Reference Line

Sparklines give you the ability to show data trends in your Excel dashboards and reports. One useful feature that’s missing in the Excel 2013 implementation of sparklines is a reference line. For example [more…]

How to Sort Excel Table Records

After you place information in an Excel table, you'll find it very easy to sort the records. You can use the Sort & Filter button’s commands to sort and organize your information. [more…]

How to Use AutoFilter on an Excel Table

Excel provides an AutoFilter command that’s pretty cool. When you use AutoFilter, you produce a new table that includes a subset of the records from your original table. For example, in the case of a grocery [more…]

How to Use the Custom AutoFilter on an Excel Table

You can construct a custom AutoFilter. To do this, select the Text Filter command from the table menu and choose one of its text filtering options. No matter which text filtering option you pick, Excel [more…]

How to Use Advanced Filtering on an Excel Table

Most of the time, you’ll be able to filter Excel table records in the ways that you need by using the Filter command or that unnamed table menu of filtering options. However, in some cases, you might want [more…]

Sign Up for RSS Feeds

Computers & Software
Great Gadget Giveaway -- Enter to Win!

Inside Dummies.com