Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am having trouble understanding the meaning behind the covariance.s function in Excel. I understand how to use the function, but not sure how to
I am having trouble understanding the meaning behind the covariance.s function in Excel. I understand how to use the function, but not sure how to explain the answer that is received. Example below... So what exactly does that 9107.3 mean?
Years | S&P 500 | Stock Price | |
2014 | 1,692 | $68.00 | |
2015 | 1,978 | $102.00 | |
2016 | 1,884 | $110.00 | |
2017 | 2,151 | $112.00 | |
2018 | 2,519 | $154.00 | |
COVARIANCE.S | 9107.3 | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started