Question

How do they get the last number with Excel? It always looks on Excel like this:

Year	Accidents
2001	197	#NV
2002	235	197,00
2003	197	212,20
2004	189	206,12
2005	209	199,27
2006	232	203,16
2007	211	214,70
2008	204	213,22

How do I get the 209.53? (I always go on Data Analysis - Exponential Smoothing - Damping Factor 0.6) However I never get the last number...can you maybe help me how to solve it?

The following data represent the number of accidents in a yearly car race series from 2001 to 2008. Complete parts a through g Year 2001 2002 2003 2004 2005 2006 2007 2008 Accidents 197 235 197 189 209 232 211 204 c. Using a smoothing coefficient of W 0.40, exponentially smooth the series and plot the results Complete the table below Year Accidents ES (W0.40) 2001 2002 2003 2004 2005 2006 2007 2008 197 235 197 189 209 232 211 204 197 212.20 206.12 199.27 203.16 214.70 213.22 209.53

Answer 1

When you are selecting the input range, select one additional row after the last row. In this manner you will get last number as 209.53. I have shown how you can do it in MS Excel using step by step screenshot.

In this case, W = 0.4 so Dampening Factor = 1 - 0.4 = 0.6

1. Following is data provided

Page Layout Formulas Data File Home Insert Review as Cut Calibri Paste Format PainterBUA Font Clipboard fic H16 1 Year Time-Series Value Exponential Smoothing (W0.40) 2 2001 з 2002 4 2003 5 2004 6 2005 7 2006 8 2007 9 2008 10 2009 197 235 197 189 209 232 211 204

2. Select Exponential Smoothing from Data analysis dialog box and click Ok.

Data Analysis Analysis Tools OK Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Cancel Help ponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogranm

3. In Exponential Smoothing Dialog Box fill value as shown in screenshot below and click Ok

Please note that here in input range instead of selecting rows from B1 to B9, you should select rows from B1 to B10. In other words, you need to select one additional row. This way you will obtain the last number.

MAD MAPE - Microsoft Excel Home Insert Page Layout Formulas Dta Rview View XLSTAT Connection A AZ Clear Properties Reapply From From From From Other Existing Refresh Access Web Text Sources▼ Connections! All. G@Edit Links Sort Filter Text to RemoveData Consolidate Advanced Columns Duplicates Validation Get External Data Data Tools Connections Sort & Filter B1 1 Year Time-Series Value: Exponential smoothing (W=0.40) 2 2001 З 2002: 4 2003 5 2004 6 2005209 2INM 8 2007 9 2008 10 2009 Exponential Smoothing 197 235 197 189 Input Input Range: Damping factor: Labels Output options Output Range: New Worksheet Ply: New Workbook B$1:58$10 0.6 1k如 232 211 204 $C$2 Chart Output Standard Errors 12

Following is the output that you will obtain:

HomerPage Layout Formulas DataReview File Cut Copy' Format Painter Calibri Paste Font Clipboard fc H17 1 Year Time-Series Value Exponential Smoothing (W 0.40) 2 2001 з 2002 #N/A 197.00 212.20 206.12 199.27 203.16 214.70 213.22 209.53 197 235 197 189 209 232 211 204 5 2004 6 2005 9 2008

Check the highlighted value, it is same value that you mentioned 209.53.