NEWS has gathered data over the last 52 weeks. Two of the data items that have be Question 1: Using the data given below, complete Task 1 and provide a very brief, between Profit and the Number of Defective Items. ANSWER: A downward trend is observed between profit and number of defectives. The points between profit and number of defectives. Question 2: Using the data given below, complete Task 2 and provide a statistical d between Profit and the Number of Defective Items. ANSWER: Since the value is close to -1, I observe there is a strong negative linear relaitonshi by taking the sqrt of R^2 there is a negative linear relationship between profit and n Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Profit Number of (thousands) Defective Items $ 35.00 974 $ 490.00 693 $ 777.00 248 $ 922.00 277 $ 519.00 509 $ 520.00 635 $ 899.00 200 $ 391.00 743 $ 577.00 563 $ 419.00 715 $ 667.00 397 $ 399.00 720 $ 540.00 659 $ 954.00 123 $ 1,078.00 8 $ 563.00 444 $ 619.00 464 $ 625.00 483 $ 351.00 715 $ 674.00 444 $ 547.00 639 $ 578.00 503 $ 609.00 565 Task 1: Create a Scatterplot Step 1. Highlight the two columns of d Step 2. Click the Quick Analysis icon o Step 3. Select Charts and Scatter Place the Chart below this row Chart Title 1200 1000 R = 0.9552159453 800 600 400 200 0 $- $200.00 $400.00 $600.00 Task 2: Correlation and Regression F Step 1. Place your mouse over any po Step 2. Select Linear, then scroll down 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 228.00 871.00 188.00 632.00 442.00 442.00 1,114.00 864.00 825.00 750.00 615.00 445.00 282.00 409.00 637.00 646.00 999.00 232.00 152.00 874.00 981.00 289.00 771.00 806.00 921.00 150.00 113.00 1,084.00 350.00 785 286 842 480 721 571 25 272 241 252 500 674 732 701 401 536 156 824 964 212 218 747 356 303 113 883 910 85 745 Step 3. Place the values in a visible ar Determine the Correlation Coefficient (R CORRELATION COEFFICIENT = Check the Correlation Coefficient (R) by Determine the sign (+ or -) of R based on CORRELATION COEFFICIENT = ata items that have been gathered are Profit and the Number of Defective Items. d provide a very brief, general description of whether or not a relationship exists defectives. The points are close to each other implying there is a strong neagtive linear relationship d provide a statistical description of whether or not a relationship appears to exist ative linear relaitonship between Number of Defective Items and profits. p between profit and number of defects. a Scatterplot t the two columns of data (Profit, Defective Units) e Quick Analysis icon on the bottom right harts and Scatter below this row Chart Title 59453 0 $400.00 $600.00 $800.00 $1,000.00 $1,200.00 ation and Regression Fitted Line ur mouse over any point within your scatterplot above and right click. Then select Add Trendline. near, then scroll down and Display Equation and R squared Value on Chart e values in a visible area of the chart so that they are legible and not covered by any of the data orrelation Coefficient (R), using the CORREL function and highlighting each column (Profit, Defective). COEFFICIENT = (0.977) ation Coefficient (R) by taking the square root (SQRT) of the R squared value in the chart above. gn (+ or -) of R based on the direction of the regression line. COEFFICIENT = 0.977 Strong negative association (r= -0.9) generally observed between the profit linear relationship t Add Trendline. ny of the data ofit, Defective). rt above. y observed between the profit amount and the number of defective items