The data set shown below gives the calories and salt content in 17 brands

profiletutor4helpyou
data.xlsx

With outlier

Brand Calories Sodium(mg)
1 173 458 SUMMARY OUTPUT
2 191 506
3 182 473 Regression Statistics
4 190 545 Multiple R 0.8634
5 172 496 R Square 0.7455
6 147 360 Adjusted R Square 0.7285
7 146 387 Standard Error 48.9132
8 139 386 Observations 17
9 175 507
10 136 393 ANOVA
11 179 405 df SS MS F Significance F
12 153 372 Regression 1 105104.7533 105104.7533 43.9310 0.0000
13 107 144 Residual 15 35887.4820 2392.4988
14 195 511 Total 16 140992.2353
15 135 405
16 140 428 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
17 138 339 Intercept -91.1853 77.8124 -1.1719 0.2595 -257.0384 74.6679 -257.0384 74.6679
Calories 3.2117 0.4846 6.6280 0.0000 2.1789 4.2445 2.1789 4.2445

Scatter plot

Sodium(mg) 173 191 182 190 172 147 146 139 175 136 179 153 107 195 135 140 138 458 506 473 545 496 360 387 386 507 393 405 372 144 511 405 428 339

Calories

Sodium(mg)

Without Outlier

Brand Calories Sodium(mg)
1 173 458 SUMMARY OUTPUT
2 191 506
3 182 473 Regression Statistics
4 190 545 Multiple R 0.8339
5 172 496 R Square 0.6954
6 147 360 Adjusted R Square 0.6736
7 146 387 Standard Error 36.4061
8 139 386 Observations 16
9 175 507
10 136 393 ANOVA
11 179 405 df SS MS F Significance F
12 153 372 Regression 1 42359.8253 42359.8253 31.9600 0.0001
14 195 511 Residual 14 18555.6122 1325.4009
15 135 405 Total 15 60915.4375
16 140 428
17 138 339 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 46.9001 69.3712 0.6761 0.5100 -101.8864 195.6865 -101.8864 195.6865
Calories 2.4008 0.4247 5.6533 0.0001 1.4900 3.3117 1.4900 3.3117

Scatter plot

Sodium(mg) 173 191 182 190 172 147 146 139 175 136 179 153 195 135 140 138 458 506 473 545 496 360 387 386 507 393 405 372 511 405 428 339

Calories

Sodium(mg)

Sheet3