Question: Hi Expert Tutor, Here's the link for the excel database excel informations which related to the following questions. https://docs.google.com/spreadsheets/d/1QFG8e-CjsADYFaVPzH6qeKVaYIW7mRStrdD8ltMfSB8/edit?usp=sharing Question 1: Investigating the relationship between

Hi Expert Tutor, Here's the link for the excel database excel informations which related to the following questions.

https://docs.google.com/spreadsheets/d/1QFG8e-CjsADYFaVPzH6qeKVaYIW7mRStrdD8ltMfSB8/edit?usp=sharing

Question 1: Investigating the relationship between property area and land value. This is worth 8 marks out of 10 marks.

Subset the data set in order to have only the variables "AREA" and "LAND VALUE 1".

a)Use this subset to find the correlation between these two variables and show your Excel command.

b)Construct a scatterplot of "LAND VALUE 1" (vertical) against "AREA" (horizontal). Insert a sensible title and axis labels.

c)Describe what the scatterplot is saying about the relationship between these two variables. (3 to 4 sentences amounting to less than 100)

PS: Thanks in Advance! I have been stress to do this part as I am not sure. Hope your ideas could help me to this question. and please brief the explanation related to your answer. Thank you so much!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!