Question

The following data sets are annual growth rates for two products Calculate Statistics with Excel Y 2013 2014 2015 2016 2017 2018 2019 2020 5.35% 6.25% 3.06% 12.05% 14.25% 5.25% -7.35% 9.50% 7.25% 4.35% 6.95% -13.50% -14.50% 18.00% 19.50% 2.00%

Answer 1

18) The correct answer is option a

To calculate the population standard deviation, we can make use of the STDEV.P function in excel. In excel, go to formulas, select statistical under more function and select STDEV.P. Enter the arguments as below

File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Σ ? А la le e Define Name Fit Use in Formula AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Used Time Reference Trig - Functions Manager Create from Selection Function Library Defined Names - Trace Precedents 5 She Trace Dependents Err Remove Arrows- Fx Eva Insert Function Formula AL C3 fx ? X A B с D 1 Returns =STDEV.P(C3:010) Function Arguments E STDEV.P Number1 03:10 Number2 2 Year Nm {0.0725;0.0435;0.0695:-0.135,-0.145... number 2013 17 4 2014 5 2015 6 х Y 5.35% 7.25% 6.25% 4.35% 3.06% 6.95% 12.05% -13.50% 14.25% -14.50%! 5.25% 18.00% -7.35% 19.50% 9.50% 2.00% 0.061726 03:010) 2016 2017 2018 2019 7 8 = 9 10 2020 0.117668081 Calculates standard deviation based on the entire population given as arguments (ignores logical values and text). Numbert: number1, number2,... are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers. 11 12 13 14 Formula result = 0.117668081 15 Help on this function OK Cancel 16 17

tbs qstAUTORE Excel File Home Insert Page Layout Formulas Data Review View Help fx Σ Tell me what you want to do Define Name Ft Use in Formula Create from Selection ? А al AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library - Trace Precedents Sho Trace Dependents to Erre Remove Arrows Eva Insert Function Name Manager Defined Names Formula Au B3 X ESTDEV.P(B3:B10) Function Arguments ? A B с D E 1 Returns STDEV.P Number1 B3:10 = {0.0535;0.0625;0.0306;0.1205;0.1425,... Number2 number 5 2 Year х Y 3 2013! 5.35% 7.25% 4 2014 6.25% 4.35% 2015; 3.06% 6.95% 6 20161 12.05% -13.50% 7 2017 14.25% -14.50% 8 2018 5.25% 18.00% 9 2019 -7.35% 19.50% 10 20201 9.50% 2.00% 11 B3:B10) 12 0.061726453 Calculates standard deviation based on the entire population given as arguments (ignores logical values and text). Numbert: number1, number2... are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers. 13 14 Formula result = 0.061726453 15 Help on this function OK Cancel 16

File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do N fx e Define Name Ft Use in Formula Create from Selection - Trace Precedents Trace Dependents Remove Arrows Formu PHI POISSON.DIST PROB F M N Σ ? A la le Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Function Used - Time- Reference Trigº Functions Manager Function Library IN Statistical B11 fox LA Engineering Cube A B с D E G 0 Information 1 Returns 2 Year х Y Compatibility 2013 5.35% 7.25% 4 2014 6.25% 4.35% 5 2015 3.06% 6.95% 2016 12.05% -13.50% 7 2017 14.25% -14.50% 8 2018 5.25% 18.00% 9 2019 -7.35% 19.50% 10 2020 9.50% 2.00% 11 QUARTILE.EXC QUARTILE.INC 3 @ Web RANK.AVG 5 RANK.EQ RSQ SKEW SKEW.P SLOPE SMALL STANDARDIZE STDEV.P STDEV STDEV.P(number 1, number2.) STDEV Calculates standard deviation based STDEV on the entire population given as arguments (ignores logical values STEYX and text). 12 13 14 15 16 17 18

--------------------------------------------------------------------------------------------------------

19) The correct answer is option C

To find the sample standard deviation, choose the STDEV.S function in excel.

S 5 tbs qs(AutoRecovered) - Excel fx File Home Insert Page Layout Formulas Data Review View Help Σ ? A la le Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Function Used Time- Reference Trigº Functions Manager Function Library Ww Statistical B11 fox LA Engineering Cube A B с D E F G 6 Information 1 Returns L. Compatibility 2 Year х Y 2013 5.35% 7.25% 4 2014 6.25% 4.35% 5 2015 3.06% 6.95% 6 2016 12.05% -13.50% 7 2017 14.25% -14.50% 8 2018 5.25% 18.00% 9 2019 -7.35% 19.50% 2020 9.50% 2.00% 11 3 @ Web Tell me what you want to do Define Name - Trace Precedents she Ft Use in Formula Trace Dependents Err Create from Selection Remove Arrows x Eve QUARTILE.EXC Formula AL QUARTILE.INC RANK.AVG M N RANK.EQ RSQ SKEW SKEW.P SLOPE SMALL STANDARDIZE STDEV.P STDEV.S STDEVA STDEV.S(number1, number2.) STDEVPA Estimates standard deviation based STEYX on a sample (ignores logical values T.DIST and text in the sample). 10 12 13 14 15 16 T.DIST.2T Tell me more

File Home Insert Page Layout Formulas Data Review View Help fx Σ Tell me what you want to do e Define Name Fit Use in Formula Create from Selection Defined Names - Trace Precedents 5 Sho Trace Dependents Remove Arrows Eva Erre ? IA la e AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trige Functions Function Library Insert Function Name Manager Formula Au B3 х fx ESTDEV.S(B3:B10) А B с D E Function Arguments ? X 1 STDEV.S = {0.0535;0.0625;0.0306;0.1205;0.1425... Number1 B3:B10 Number2 = number 5 6 Returns 2 Year х Y 3 2013 5.35% 7.25% 4 2014 6.25% 4.35% 2015i 3.06% 6.95% 2016! 12.05% -13.50% 7 2017 14.25% -14.50% 8 2018 5.25% 18.00% 9 2019 -7.35% 19.50% 10 20201 9.50%! 2.00% 11 B3:B10) 12 = 0.065988354 Estimates standard deviation based on a sample (ignores logical values and text in the sample). Numbert: number1, number2... are 1 to 255 numbers corresponding to a sample of a population and can be numbers or references that contain numbers. 13 Formula result = 0.065988354 14 15 Help on this function OK Cancel 16 17

File fx Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do ? А e e Define Name Fu Use in Formula AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Used Time Reference Trige Functions Manager Create from Selection Function Library Defined Names Σ Insert Function - Trace Precedents 5A Show Trace Dependents Error Remove Arrows Evalu Formula Aud C3 for A B C D ? Х 1 =STDEV.S(C3:010) E Function Arguments STDEV.S Number1 C3:010 Number2 2 Year = 3 2013 {0.0725;0.0435;0.0695:-0.135:-0.145;... = number 4 5 6 Returns х Y 5.35% 7.25%! 6.25% 4.35% 3.06% 6.95% 12.05% -13.50% 14.25% -14.50%! 5.25% 18.00% -7.35% 19.50% 9.50%! 2.00% 0.065988|C3:C10) 2014 2015 2016 2017 2018 2019 2020 7 00 9 = 0.12579247 Estimates standard deviation based on a sample (ignores logical values and text in the sample). Numbert: number1, number2,... are 1 to 255 numbers corresponding to a sample of a population and can be numbers or references that contain numbers. 10 11 12 13 Formula result = 0.12579247 14 15 Help on this function OK Cancel 0) 17