시작하기무료로 시작하기

Correlation between seller rating and closing price

Now you will explore the correlation between the seller's rating and the auction closing price. Common sense would lead you to believe that the higher ratings a seller has, the higher the closing price. If this were the case you would see a "positive" correlation, both acting similarly.

Remember that "correlation is not causation"! You may suspect that higher ratings improves trust thereby causing prices to edge higher. However, other factors could really be the cause. Perhaps sellers with higher ratings are allowed to sell more expensive products. In which case the real cause is the expensive products, not trust. Thus be careful when exploring correlation & drawing conclusions.

이 연습은 강의의 일부입니다

Google Sheets로 배우는 통계 입문

강의 보기

연습 안내

  • In D2, calculate the correlation between "Seller Rating" and "Close Price".
  • Insert a scatter (XY) plot at F1, with "Seller Rating" on the x-axis.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작