Hi AudreyJ,

The "NUM!" error in regression analysis usually occurs when there is a problem with the data in the cells that are being used for the analysis. This error message indicates that Excel is unable to perform the calculation because it is encountering a value that is not a number.

There are a few reasons why you might be seeing this error message in your regression analysis. One possibility is that there are blank cells or cells with text in the range of data that you are using for the analysis. Another possibility is that there are cells with errors, such as #DIV/0! or #VALUE!, in the range of data.

To fix this issue, you can try the following steps:

1. Check the range of data that you are using for the analysis and make sure that there are no blank cells or cells with text in the range.
2. Check for any cells with errors in the range of data and correct them if necessary.
3. If you have deleted some fields of data, make sure that you have not accidentally deleted any cells that are being used in the analysis.
4. Check the formatting of the cells in the range of data and make sure that they are all formatted as numbers.
5. If none of the above steps work, try copying the data to a new worksheet and performing the analysis again.