Answer:
Its the VLookup and the HLOOKUP.
Explanation:
And it depends upon the manner in which the marks are mentioned. If they are mentioned in row then we use Hlookup, and if in columns then we use vlookup.
And the syntax for vlookup is :
vlookup(lookup value, range containing the lookup value, column number in range containing the return value, approximate 0 or exact value 1)
The best possible fit would be a person with a creative mind and flexible mind.
The technical stuff can be taught and learnt. But to evolve and keep up with the pace of how technology improves day to day, you'd need some with flexibility to cope up with this and creativeness to make innovations.
For 1.
Positive correlation means if you plot a country's population and land size on a graph. There would be a linear regression line that's sloping upwards.
Since it's a scatterplot, there will be some that fall out of the line, but most of them should be on the line.
It's (A)
For 2.
An outlier is a datapoint that's far, FAR away from the others, so it's (B)
For 3. (A), it's a single line-of-best fit that runs through the middle of the cluster of data points.