FM -BINUS -AA-FPU -579 /R3 Profit 14 11 15 16 24 22 21 26 43 34 Sales 6 3 5 5 15 18 17 12 15 20 14 5 Answer : Calculate a regression line : B C D F G H 1 Store Sales Profits 14 Regicision 7 X 11 Incut 15 Input! Range 16 Cancel Input _ Range 58521 506 11 HEi: _ Constant is Zero Confidence Level Chriput apliens O gulpul Arge: New Worksheet OF Brudwas Reudual Hats Standardized Residuals Line FR Plots Normal Probability Plots A B C D E G H SUMMARY OUTPUT 4 MultipleR 0.86872 5 R Square 0.754675 6 Adjusted R. 0.730142 7 Standard E 5. 149527 12 10 ANOVA 11 55 mificonce F 12 Regression 1 815.7404 $15.7401 30.7622 0.090245 13 Residual 10 265.1763 26.51763 14 Total 11 1080 917 15 16 Coefficientsmedard Err + Star P-vale Lower 939%Upper 93%%ower 92.01 pper 93.09 17 Intercept 5.935683 3242211 1.830752 0.097056 -128841 13.15978 -1.25841 13.15978 18 X Variable 1.120532 0.256119 5.516368 0.000215 0.819562 1.991201 0.819862 1.991201 19 20 Equatica 21 Profits - 5.9361 1.42*Sales - When sales = IDR 24 million , Profits (in hundreds of thousands ) = 5.936 + 1.42 x 24 = IDR 40.016 - When sales = IDR 30 million Profits (in hundreds of thousand ) = 5.936 + 1.42 x 30 = IDR 40.583