Skip to Main Content
Business Statistics, 3rd Edition
book

Business Statistics, 3rd Edition

by Naval Bajpai
April 2024
Intermediate to advanced content levelIntermediate to advanced
921 pages
37h 16m
English
Pearson India
Content preview from Business Statistics, 3rd Edition
Chapter 16
PB
Time Series and Index Numbers
649
given with the three plots, we  nd that all the three measures are less for the highest value of
a, that is, for 0.7. Figure 16.18 clearly exhibits that the actual values vary considerably with the
largest value of a seeming to forecast the best.
16.11.1 Using MS Excel for Exponential Smoothing
Click Data/Data Analysis/Exponential Smoothing/OK. The Exponential Smoothing dialog
box as shown in Figure 16.19 will appear on the screen. In this dialog box, place data values in
Input Range. MS Excel computes the smoothed values by using a damping factor de ned as
(1 – exponential smoothing constant). So, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Statistics

Business Statistics

Bajpai
Applied Statistics

Applied Statistics

Dieter Rasch, Rob Verdooren, Jürgen Pilz
Data Analytics for Marketing

Data Analytics for Marketing

Guilherme Diaz-Bérrio

Publisher Resources

ISBN: 9789390168996