Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The estimation of the selling price of commercial properties (warehouses) constitutes an important problem for supply chain companies. A data analyst wishes to study the
The estimation of the selling price of commercial properties (warehouses) constitutes an important problem for supply chain companies. A data analyst wishes to study the relation of the selling price Y (in thousands of euros) and the size (area) of the warehouse X (in square meters). For this reason, he has collected the data for ten warehouses in Aspropyrgos Attica, in the file TO2_EA2.xlsx. Data for the problem of price estimation of warehouse Month 1 X (Area size of the property in square meters) 72 113 85 Y (Price of property in thousands ) 105 152 2 3 140 4 115 76 101 5 137 98 123 6 7 89 117 8 121 165 147 9 119 134 10 156 Question 2.3 (15%) Calculate the correlation coefficient using i) Excel formulas, ii) only the R-square, and iii) the Data Analysis tool, and interpret the result
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