Chapter 1
Building Formulas for Data Analysis
Introducing Data Analysis
Data analysis is the application of tools and techniques to organize, study, reach conclusions, and sometimes make predictions about a specific collection of information. A sales manager might use data analysis to study the sales history of a product, determine the overall trend, and produce a forecast of future sales. A scientist might use data analysis to study experimental findings and determine the statistical significance of the results. A family might use data analysis to find the maximum mortgage that they can afford, or to determine how much they need to put aside each month to finance their retirement or their children’s education.
Manipulate Raw Data
The point ...
