What do the coefficients, SE and correlation signify?
tutor4helpyou
data.xlsxcereal_unhealthy
| Forecasting | Multiple regression | |||||||||||
| Data Bellinda Jones-Thomas: Forecasting: Submodel = 2; Problem size @ 14 by 5 | Forecasts and Error Analysis | |||||||||||
| Price/12.2oz Box | Fat/g | Sodium/mg | Carbs | Sugar/g | Calories | Forecast | Error | Absolute | Squared | Abs Pct Err | ||
| Foot Loops | 2.98 | 1 | 135 | 26 | 13 | 120 | 2.8921046098 | 0.0878953902 | 0.0878953902 | 0.0077255996 | 02.95% | |
| Cocoa Pebbles | 2.58 | 1.5 | 226.7 | 33.3 | 13.3 | 160 | 2.8161341712 | -0.2361341712 | 0.2361341712 | 0.0557593468 | 09.15% | |
| Capn' Crunch Berries | 2.48 | 2 | 200 | 30.7 | 16 | 147 | 2.7849992679 | -0.3049992679 | 0.3049992679 | 0.0930245534 | 12.30% | |
| Corn Pops | 2.98 | 0 | 105 | 27 | 9 | 120 | 3.0104338995 | -0.0304338995 | 0.0304338995 | 0.0009262222 | 01.02% | |
| Raisin Bran Crunch | 2.98 | 1 | 200 | 45 | 19 | 190 | 2.7761125191 | 0.2038874809 | 0.2038874809 | 0.0415701049 | 06.84% | |
| Frosted Mini Wheat's | 3.12 | 1 | 10 | 46 | 11 | 180 | 3.1718045843 | -0.0518045843 | 0.0518045843 | 0.002683715 | 01.66% | |
| Kashi Heart to Heart | 3.12 | 1 | 210 | 44 | 14 | 230 | 3.099966787 | 0.020033213 | 0.020033213 | 0.0004013296 | 00.64% | |
| Oatmeal Crisp Crunchy Almond | 3.28 | 4 | 125 | 47 | 14 | 240 | 3.1995614118 | 0.0804385882 | 0.0804385882 | 0.0064703665 | 02.45% | |
| Cookie Crisp | 2.82 | 1.3 | 160 | 29.3 | 12 | 133 | 2.870690007 | -0.050690007 | 0.050690007 | 0.0025694768 | 01.80% | |
| Cinnamon Toast Crunch | 2.82 | 2.5 | 200 | 40 | 9 | 190 | 2.9680325079 | -0.1480325079 | 0.1480325079 | 0.0219136234 | 05.25% | |
| Honey Kix Cereal | 2.98 | 0.8 | 184 | 22 | 4.9 | 96 | 2.8315808871 | 0.1484191129 | 0.1484191129 | 0.0220282331 | 04.98% | |
| Reese's Puff | 2.97 | 4 | 213 | 30 | 13 | 160 | 2.8473777613 | 0.1226222387 | 0.1226222387 | 0.0150362134 | 04.13% | |
| Lucky Charms | 2.96 | 1.3 | 226 | 30 | 13 | 147 | 2.8051302086 | 0.1548697914 | 0.1548697914 | 0.0239846523 | 05.23% | |
| Honey Nut Cheerios | 2.98 | 2 | 160 | 32 | 12 | 160 | 2.9760713776 | 0.0039286224 | 0.0039286224 | 0.0000154341 | 00.13% | |
| Total | 0 | 1.6441888754 | 0.2941088711 | 58.54% | ||||||||
| Coefficients | 3.0743440034 | -0.0247126009 | -0.0019530446 | -0.0188567349 | -0.0134705216 | 0.0064293843 | Average | 2.22044604925031E-16 | 0.1174420625 | 0.0210077765 | 04.18% | |
| Bias | MAD | MSE | MAPE | |||||||||
| SE | 0.1917383866 | |||||||||||
| Forecast | 2.70365499 | 15 | ||||||||||
| Correlation | 0.6882669471 |
Enter the data in the shaded area. To get a forecast use the shaded data area at the bottom left of the sheet.
cereal_healthy
| Forecasting | Multiple regression | |||||||||||
| Data Bellinda Jones-Thomas: Forecasting: Submodel = 2; Problem size @ 14 by 5 | Forecasts and Error Analysis | |||||||||||
| Price/12.2oz Box | Fat/g | Sodium/mg | Carbs | Sugar/g | Calories | Forecast | Error | Absolute | Squared | Abs Pct Err | ||
| Uncle Sam | 5.28 | 8 | 187 | 49 | 0.8 | 280 | 4.928984261 | 0.351015739 | 0.351015739 | 0.123212049 | 06.65% | |
| Barbara's Puffins | 5.16 | 8 | 107 | 33 | 8 | 147 | 5.5965472235 | -0.4365472235 | 0.4365472235 | 0.1905734784 | 08.46% | |
| Cascadian Farms Purely O's | 4.92 | 2 | 250 | 22 | 1 | 110 | 5.0465673782 | -0.1265673782 | 0.1265673782 | 0.0160193012 | 02.57% | |
| Erewhon Crispy Brown Rice | 4.77 | 0.5 | 180 | 25 | 1 | 110 | 4.3341185964 | 0.4358814036 | 0.4358814036 | 0.189992598 | 09.14% | |
| Kashi Go Lean | 3.12 | 3 | 100 | 38 | 13 | 190 | 3.3894699595 | -0.2694699595 | 0.2694699595 | 0.0726140591 | 08.64% | |
| Purely Elizabeth Ancient Grain | 6.59 | 18 | 318 | 54 | 18 | 424 | 6.5179660471 | 0.0720339529 | 0.0720339529 | 0.0051888904 | 01.09% | |
| Baked Naked Granola | 4.92 | 10 | 38 | 22 | 9 | 212 | 6.4771954532 | -1.5571954532 | 1.5571954532 | 2.4248576794 | 31.65% | |
| Ezekiel 4:9 Sprouted Grain | 3.96 | 2 | 140 | 24 | 0 | 380 | 4.1574701522 | -0.1974701522 | 0.1974701522 | 0.038994461 | 04.99% | |
| Barbara's Multigrain Squarefuls | 4.2 | 1 | 190 | 47 | 9 | 200 | 2.6266425391 | 1.5733574609 | 1.5733574609 | 2.4754536998 | 37.46% | |
| Natures Path Qia Superfood Chia | 9.29 | 6 | 0 | 14 | 3 | 140 | 6.1668257537 | 3.1231742463 | 3.1231742463 | 9.7542173728 | 33.62% | |
| Kashi Good Friends | 2.64 | 1.5 | 110 | 42 | 10 | 160 | 2.9833677272 | -0.3433677272 | 0.3433677272 | 0.1179013961 | 13.01% | |
| Wheatena | 2.4 | 1 | 5 | 29 | 0.6 | 126 | 4.0209234057 | -1.6209234057 | 1.6209234057 | 2.6273926873 | 67.54% | |
| Natures Path Original Oatmeal | 3.77 | 4 | 200 | 32 | 0 | 190 | 4.9097480074 | -1.1397480074 | 1.1397480074 | 1.2990255204 | 30.23% | |
| Arrowhead Mills Steel Cut | 4.25 | 19 | 0 | 108 | 0 | 600 | 4.1141734958 | 0.1358265042 | 0.1358265042 | 0.0184488393 | 03.20% | |
| Total | -0 | 11.3825786141 | 19.3538920322 | 258.24% | ||||||||
| Coefficients | 5.6158212487 | 0.3055811847 | 0.0013411265 | -0.0533993843 | -0.0584759932 | -0.0025675946 | Average | -9.19899077546558E-16 | 0.8130413296 | 1.3824208594 | 18.45% | |
| Bias | MAD | MSE | MAPE | |||||||||
| SE | 1.5553895024 | |||||||||||
| Forecast | 10.1995390195 | 15 | ||||||||||
| Correlation | 0.7112207637 |
Enter the data in the shaded area. To get a forecast use the shaded data area at the bottom left of the sheet.
