Cereal Nutritional Value Multiple Regression Forecasts and Error Analysis Data Foot Loops Cocoa Pebbles Capn' Crunch Berries Corn Pops Raisin Bran Crunch Frosted Mini Wheat's Kashi Heart to Heart Oatmeal Crisp Crunchy Almond Cookie Crisp Cinnamon Toast Crunch Honey Kix Cereal Reese's Puf Lucky Charms Honey Nut Cheerios Uncle Sam Barbara's Puffins Cascadian Farms Purely O's Erewhon Crispy Brown Rice Kashi Go Lean Purely Elizabeth Ancient Grain Baked Naked Granola Ezekiel 4:9 Sprouted Grain Barbara's Multigrain Squarefuls Natures Path Qia Superfood Chia Kashi Good Friends Wheatena Natures Path Original Oatmeal Arrowhead Mills Steel Cut Coefficients Forecast Price/12.2oz Box 2.98 2.58 2.48 2.98 2.98 3.12 3.12 3.28 2.82 2.82 2.98 2.97 2.96 2.98 5.28 5.16 4.92 4.77 3.12 6.59 4.92 3.96 4.2 9.29 2.64 2.4 3.77 4.25 5.2210431884 13.2595620707 Fat/g 1 1.5 2 0 1 1 1 4 1.3 2.5 0.8 4 1.3 2 8 8 2 0.5 3 18 10 2 1 6 1.5 1 4 19 Sodium/mg 135 226.7 200 105 200 10 210 125 160 200 184 213 226 160 187 107 250 180 100 318 38 140 190 0 110 5 200 0 Carbs 26 33.3 30.7 27 45 46 44 47 29.3 40 22 30 30 32 49 33 22 25 38 54 22 24 47 14 42 29 32 108 Sugar/g 13 13.3 16 9 19 11 14 14 12 9 4.9 13 13 12 0.8 8 1 1 13 18 9 0 9 3 10 0.6 0 0 Calories 120 160 147 120 190 180 230 240 133 190 96 160 147 160 280 147 110 110 190 424 212 380 200 140 160 126 190 600 0.27719 -0.00052895 -0.0490022 -0.05531573 -0.0006752 Forecast Error Absolute Squared Abs Pct Err 3.352643 -0.3726433809 0.3726433809 0.138863 12.50% 3.041416 -0.4614163391 0.4614163391 0.212905 17.88% 3.180965 -0.7009648845 0.7009648845 0.491352 28.26% 3.263582 -0.2835822771 0.2835822771 0.080419 09.52% 2.008064 0.9719362295 0.9719362295 0.94466 32.62% 2.508839 0.6111605769 0.6111605769 0.373517 19.59% 2.301348 0.8186519351 0.8186519351 0.670191 26.24% 3.024121 0.2558786604 0.2558786604 0.065474 07.80% 3.307408 -0.4874080335 0.4874080335 0.237567 17.28% 3.222017 -0.4020173797 0.4020173797 0.161618 14.26% 3.931557 -0.9515571537 0.9515571537 0.905461 31.93% 3.919941 -0.9499405859 0.9499405859 0.902387 31.98% 3.173428 -0.2134277143 0.2134277143 0.045551 07.21% 3.350906 -0.3709056343 0.3709056343 0.137571 12.45% 4.705244 0.5747560039 0.5747560039 0.330344 10.89% 5.22312 -0.0631197791 0.0631197791 0.003984 01.22% 4.435554 0.4844462051 0.4844462051 0.234688 09.85% 3.909788 0.8602117784 0.8602117784 0.739964 18.03% 3.290249 -0.1702488188 0.1702488188 0.028985 05.46% 6.114188 0.475811939 0.475811939 0.226397 07.22% 6.25382 -1.333819569 1.333819569 1.779075 27.11% 4.268752 -0.3087520258 0.3087520258 0.095328 07.80% 2.461754 1.7382455551 1.7382455551 3.021498 41.39% 5.937683 3.3523171947 3.3523171947 11.23803 36.09% 2.859368 -0.2193676517 0.2193676517 0.048122 08.31% 3.956264 -1.556264168 1.556264168 2.421958 64.84% 4.527662 -0.7576617749 0.7576617749 0.574051 20.10% 4.790319 -0.5403189078 0.5403189078 0.291945 12.71% Total 9.769963E-015 20.286832156 26.40191 540.54% Average 3.489272E-016 0.7245297199 0.942925 19.30% Bias MAD MSE MAPE SE 1.095485 29 Correlation 0.751569