When using the data analysis toolpack to carry out regression, you enter a
Y-input range and an X-input range. The result is a lot of data, including a
p-value, contained in a number of tables. My question is, is there a function
which makes it possible to return only the regression p-value in a single
cell for the X and Y data range? If so, it would then be possible to drag the
function down the sheet to return a p-value for a number if different Y data
ranges without having to produce a large number of tables just to get a
p-value for each one.