AutoSave . Off 14) + Assignment#1_Fall 2021 - Search Sign in X File Home Insert Page Layout Formulas Data Review View Add-ins Help Share Comments J32 X V fx A B D G H K L M N O P Q F - Constant 96 t Year China cell phones/100 1997 1.052726386 199 1.886071369 Consider the data in this sheet on China Cellphone per 100 people. Using basic Excel 1999 3.401326149 OUT A W N H 2000 6.658707962 (NOT ForecastX software) by optimizing MSE: 2001 11.24474524 10 2002 15.90376731 A) Fit a Logistic model into these data assuming the constant L=97. Report the 11 2003 20.72082242 12 8 2004 25.55100154 estimated coefficients. 13 9 2005 29.84470593 14 10 2006 34.76674887 B) Fit a Gompertz model into the data assuming the constant L=97. Report the 15 11 2007 41.01687431 estimated coefficients. 16 12 2008 47.75671627 17 13 2009 $5.29808341 C) Plot, in two separate graphs, the original data and your estimated (fitted) Logistic 18 14 2010 53.17027802 and Gompertz modeld. Each graph should include the original and the fitted 19 15 2011 72.0713209 20 16 2012 30.76271455 model. 21 17 2013 88.70833462 22 18 2014 92.27349082 23 19 2015 94.38011871 24 20 2016 96.87787265 25 Report your forecast models of Gompertz and Logistic in two separate sheets. 26 Please note that you eventually will upload only ONE excel file under assignment#1. 27 28 29 30 31 32 Problem 1 Answer 1 Problem 2 Peoblem 3 + Ready we're starting the add-ins runtime, just a moment. + 100% 10:33 PM Type here to search O amazon 6 CD 4) ENG 2021-10-07