The purpose of this tutorial is to provide instruction on performing basic functions using Microsoft Excel. Although Excel has the ability to perform a large array of mathematical and statistical ...
Most good spreadsheets have very similar capabilities, but the syntax of the commands differs slightly. I will use the keyboard command and mouse syntax of Excel® by Microsoft for this example. ...
Regression analysis can be used to identify the line or curve which provides the best fit through a set of data points. This curve can be useful to identify a trend in the data, whether it is linear, ...
This paper develops a refinance model that provides pertinent information for investors about refinancing their mortgage. We discuss the input variables and how to compute the breakeven ...
This document introduces users to basic Excel tasks, such as creating, saving, and opening new Excel workbooks and worksheets; selecting, copying, and moving data; constructing formulas; formatting ...