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
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