Forecasting Multiple regression Enter the data in the shaded area. To get a forecast use the shaded data area at the bottom left of the sheet. 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 Puff Lucky Charms Honey Nut Cheerios 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 Fat/g Sodium/mg Carbs 1 135 26 1.5 226.7 33.3 2 200 30.7 0 105 27 1 200 45 1 10 46 1 210 44 4 125 47 1.3 160 29.3 2.5 200 40 0.8 184 22 4 213 30 1.3 226 30 2 160 32 Sugar/g Calories 13 120 13.3 160 16 147 9 120 19 190 11 180 14 230 14 240 12 133 9 190 4.9 96 13 160 13 147 12 160 3.0743440034 -0.024713 -0.001953 -0.018857 -0.013471 0.006429 2.70365499 Forecasts and Error Analysis Forecast Error Absolute Squared Abs Pct Err 2.892105 0.087895 0.0878953902 0.007726 02.95% 2.816134 -0.236134 0.2361341712 0.055759 09.15% 2.784999 -0.304999 0.3049992679 0.093025 12.30% 3.010434 -0.030434 0.0304338995 0.000926 01.02% 2.776113 0.203887 0.2038874809 0.04157 06.84% 3.171805 -0.051805 0.0518045843 0.002684 01.66% 3.099967 0.020033 0.020033213 0.000401 00.64% 3.199561 0.080439 0.0804385882 0.00647 02.45% 2.87069 -0.05069 0.050690007 0.002569 01.80% 2.968033 -0.148033 0.1480325079 0.021914 05.25% 2.831581 0.148419 0.1484191129 0.022028 04.98% 2.847378 0.122622 0.1226222387 0.015036 04.13% 2.80513 0.15487 0.1548697914 0.023985 05.23% 2.976071 0.003929 0.0039286224 1.54E-005 00.13% Total 8.88E-016 1.6441888754 0.294109 58.54% Average 6.34E-017 0.1174420625 0.021008 04.18% Bias MAD MSE MAPE SE 0.191738 15 Correlation 0.688267 Forecasting Multiple regression Enter the data in the shaded area. To get a forecast use the shaded data area at the bottom left of the sheet. Data Price/12.2oz Box 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 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 Fat/g Sodium/mg 8 8 2 0.5 3 18 10 2 1 6 1.5 1 4 19 187 107 250 180 100 318 38 140 190 0 110 5 200 0 Carbs 49 33 22 25 38 54 22 24 47 14 42 29 32 108 Sugar/g Calories 0.8 8 1 1 13 18 9 0 9 3 10 0.6 0 0 280 147 110 110 190 424 212 380 200 140 160 126 190 600 5.6158212487 0.305581185 0.001341126 -0.0533994 -0.058476 -0.002568 10.1995390195 Forecasts and Error Analysis Forecast Error Absolute Squared Abs Pct Err 4.928984 0.351016 0.351015739 0.123212 06.65% 5.596547 -0.436547 0.4365472235 0.190573 08.46% 5.046567 -0.126567 0.1265673782 0.016019 02.57% 4.334119 0.435881 0.4358814036 0.189993 09.14% 3.38947 -0.26947 0.2694699595 0.072614 08.64% 6.517966 0.072034 0.0720339529 0.005189 01.09% 6.477195 -1.557195 1.5571954532 2.424858 31.65% 4.15747 -0.19747 0.1974701522 0.038994 04.99% 2.626643 1.573357 1.5733574609 2.475454 37.46% 6.166826 3.123174 3.1231742463 9.754217 33.62% 2.983368 -0.343368 0.3433677272 0.117901 13.01% 4.020923 -1.620923 1.6209234057 2.627393 67.54% 4.909748 -1.139748 1.1397480074 1.299026 30.23% 4.114173 0.135827 0.1358265042 0.018449 03.20% Total -2E-014 11.382578614 19.35389 258.24% Average -2E-015 0.8130413296 1.382421 18.45% Bias MAD MSE MAPE SE 1.55539 15 Correlation 0.711221