Hello,

How do you test question c-1 I have tried with regression and looked at other samples but still can not get it to come calculate properly.

Check my work 2 Below are percentages for annual sales growth and net sales attributed to loyalty card usage at 74 Noodles & Company restaurants. 2 Annual Sales Growth (px; ) and Loyalty Card Usage (px; of Net Sales) (n = 74 restaurants points Store Growth% Loyalty% Store Growth% Loyalt .8. e 0.5 38 7.3 2.4 1QUI AWNI 2.5 39 7.5 1. 6 -7.5 40 7 .8 1.9 eBook - 6.4 2 .4 -5.2 1 .8 41 8 .0 2 . 1 - 5 .0 42 8 . 1 1. 6 References 2 . 1 - 1 .7 1 .6 43 8 .1 1. 3 - 0 .7 2 . 1 44 8 . 5 2.5 - 0 .5 2. 2 45 8.5 2 . 3 0 .5 1.2 46 8 .6 1.4 0.5 2 .6 47 8 .7 9. 8 10 11 0 . 3 2 . 6 48 8 . 8 2.7 0 . 0 . 8 49 9 .0 2 . 1 12 13 0.9 1.9 50 9 . 1 1.4 14 1 .2 1 . 3 51 9 . 2 2 . 1 1.7 2 . 2 52 10.5 2.0 16 1 . 8 2 .4 10 .8 1 .7 1.4 17 1. 2 .5 54 10 .8 18 2 . 1.9 55 11.0 19 4. 0 . 8 56 11. 3 1.8 20 4. 2 . : 57 1 1.4 1. 2 4.5 1.4 58 11.6 0 . 7 21 22 4 .7 1.5 23 4.9 IN ! 59 11 . 8 1 . 60 1 1 . 8 2 . 1 24 5 .2 1. 61 13 .5 1.2 25 5.2 2 .4 62 14 .1 1.5 26 5 . 3 1 .6 14 .3 1.9 5 .4 1 .2 64 15.1 0 . 7 2 . 1 28 5 .5 2 .0 65 15.5 29 5 .6 2 . 6 66 15.9 1. 6 30 5 .7 2 .0 67 16.0 0. 9 31 5 .9 1.5 68 16.2 2.6 32 6.0 1.9 69 16.2 1.4 33 5.4 2 . 3 70 17 .8 34 6.4 71 18 . 8 2 . 2 0 . 6 2 . 1 35 5.6 1.9 72 18.9 1.3 9.6 36 5.6 2 . 3 73 19 .8 6.7 74 1.7 37 1 .2 24.0 Click here for the Excel Data File (b) Find the correlation coefficient. (Round your answer to 3 decimal places. AHelp Save & Exit Submit Check my work 2 24 5 .2 61 13 . 3 1 . 2 25 14.1 1.5 26 . 2 5 . 3 14 . 3 1.9 27 28 5 .4 64 15 .1 0. 7 5 .5 65 15.5 2. 1 29 5 . 6 66 15.9 1. 6 2 30 5 .7 67 16.0 0 .9 5 .9 16.2 2.6 points 31 68 32 6 . 6 1.9 69 16.2 1.4 33 6.4 2 . 3 70 17 .8 2 . 2 34 35 6.4 0 . 6 71 18 . 8 2. 1 eBook 5. 6 1.9 72 18.9 1.3 36 . 6 2 . 3 73 19 .8 0 . 6 References 37 6.7 1. 2 74 24 . 0 1.7 Click here for the Excel Data File (b) Find the correlation coefficient. (Round your answer to 3 decimal places. A negative value should be indicated by a minus sign.) r -0.1995 (c-1) To test the correlation coefficient for significance at a = 0.01, fill in the following. (Use the rounded value of the correlation coefficient from part b in all calculations. For final answers, round tcalc to 3 decimal places and the p- value to 4 decimal places. Negative values should be indicated by a minus sign.) tcalc p-value (c-2) There is no significant correlation. O True O False (d) Does it appear that increased loyalty card usage is associated with decreased sales growth