When you use @RISKs correlation feature to generate correlated random numbers, how can you verify that they
Question:
a. Use Excel’s CORREL function to calculate the correlation between the two input variables. It should be close to 0.7. Then create a scatterplot of these two input variables. The plot should indicate a definite positive relationship.
b. Are the two input variables correlated with the output? Use Excel’s CORREL function to find out. Interpret your results intuitively.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Question Posted: