Data Analysis Day 1

Data Analysis Day 1 - Data Analysis Data Tables Allow you...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Analysis Data Tables Allow you to examine how changes in one or two variables can affect other formulas Data Tables are dynamic – if you make changes to the underlying formulas or to the range of possible values for the variables, the Data Table will automatically update Note that Data Tables are different from Tables that were discussed previously o Tables are used to manage and organize large data sets o Data Tables are used to for what-if analysis You can use either a one-input Data Table or a two-input Data Table To set up a Data Table o Create the structure of the Data Table with the associated rows and columns o Provide labels for the data being used o Data – Data Tools – What-If Analysis – Data Table For one-input Data Tables, enter either the row or column input cell For two-input Data Tables, enter both a row and a column input cell The input cell is the cell whose value will be changed in the Data Table Note that a row input cell is used if the possible values for the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/02/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 2

Data Analysis Day 1 - Data Analysis Data Tables Allow you...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online