Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 5 items sold through an auction.Price in dollars 23 29 32 38 41Number of Birds 10 14 15 16 17A) Step 1 of 3: Draw a scatter plot of the given data.B)Step 2 of 3: Estimate the correlation in words: positive, negative, no correlation.C) Step 3 of 3: Calculate the correlation coefficient, r. Round your answer to three decimal places
Accepted Solution
A:
Answer:Step 1: Figure attachedStep 2: Positive correlationStep 3: r=0.9534Step-by-step explanation:Step 1For this step we can use excelWe click on Insert> Insert Scatterpplot(X,Y) or Bubblechart. We select the data and then we select the Layout 9. Then we can edit the title and the names for the x and y axis.The result obtained is on the Figure attached.Step 2As we can see on the plot obtained the slope obtained is positive since is increasing, so with this result we can conclude that the correlation would be positive and possible strong. We need to compute it in order to be sure of this.Step 3In order to calculate the correlation coefficient we can begin doing the following table:n x y xy x*x y*y1 23 10 230 529 1002 29 14 406 841 1963 32 15 480 1024 2254 38 16 608 1444 2565 41 17 697 1681 289[tex] n =5 \sum x \sum y \sum xy \sum x^2 \sum y^2[/tex]n=5 [tex] \sum x = 163, \sum y = 72, \sum xy 2421, \sum x^2 =5519, \sum y^2 =1066[/tex] And in order to calculate the correlation coefficient we can use this formula:[tex]r=\frac{n(\sum xy)-(\sum x)(\sum y)}{\sqrt{[n\sum x^2 -(\sum x)^2][n\sum y^2 -(\sum y)^2]}}[/tex][tex]r=\frac{5(2421)-(163)(72)}{\sqrt{[5(5519) -(163)^2][5(1066) -(72)^2]}}=0.9534[/tex]So then the correlation coefficient would be r =0.9534