Refer to the Excel file for the Exam and to the worksheet entitled $$Moving Average.$$ Calculate the following and report your answers: AutoSave

Copy of Excel File for Exam $1-$ Data File

Search $(Cmd+Ctrl+U)$

Enter

Accessibility: Good to go AutoSave

Copy of Excel File for Exam $1-$ Data File

Search $(Cmd+Ctrl+U)$

D$10,AAvv{f}_x$

$\backslash$table$[[,$A$,,$B$,$C$,$D$,$E$,$F$,$G$,$H$,$I,J$,$K$,$L$],[1,$Month,,Monthly Sales,,,,,,,,,,$],[20,$May$-21,$$$,150,627,,,,,,,,,,],[21,$Jun$-21,$$$,148,092,,,,,,,,,,],[22,$Jul$-21,$$$,138,348,,,,,,,,,,],[23,$Aug$-21,$$$,150,841,,,,,,,,,,],[24,$Sep$-21,$$$,124,185,,,,,,,,,,],[25,$Oct$-21,$$$,163,818,,,,,,,,,,],[26,$Nov$-21,$$$,135,543,,,,,,,,,,],[27,$Dec$-21,$$$,165,231,,,,,,,,,,],[28,$Jan$-22,$$$,175,323,,,,,,,,,,],[29,$Feb$-22,$$$,165,522,,,,,,,,,,],[30,$Mar$-22,$$$,162,789,,,,,,,,,,],[31,$Apr$-22,$$$,172,230,,,,,,,,,,],[32,$May$-22,$$$,133,626,,,,,,,,,,],[33,$Jun$-22,$$$,168,267,,,,,,,,,,],[34,$Jul$-22,$$$,184,518,,,,,,,,,,],[35,$Aug$-22,$$$,144,750,,,,,,,,,,],[36,$Sep$-22,$$$,159,990,,,,,,,,,,],[37,$Oct$-22,$$$,179,163,,,,,,,,,,],[38,$Nov$-22,$$$,126,675,,,,,,,,,,]]$

Enter

Accessibility: Good to go AutoSave

Copy of Excel File for Exam $1-$ Data File

Search $(Cmd+Ctrl+U)$

Enter

Accessibility: Good to go AutoSave

Copy of Excel File for Exam $1-$ Data File

Search Cmd $+$ Ctrl $+U$

D$10,vvvvfx$

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$,$I,J$,$K$,$L$],[1,$Month,Monthly Sales,,,,,,,,,,$],[54,$Mar$-24,$$$165,612,,,,,,,,,,],[55,$Apr$-24,$$$167,874,,,,,,,,,,],[56,$May$-24,$$ $147,217,,,,,,,,,,],[57,$Jun$-24,$$ $133,314,,,,,,,,,,],[58,$Jul$-24,$$$168,609,,,,,,,,,,],[59,$Aug$-24,$$ $152,766,,,,,,,,,,],[60,,,,,,,,,,,,],[61,,,,,,,,,,,,],[62,,,,,,,,,,,,],[63,,,,,,,,,,,,],[64,,,,,,,,,,,,],[65,,,,,,,,,,,,],[66,,,,,,,,,,,,],[67,,,,,,,,,,,,],[68,,,,,,,,,,,,],[69,,,,,,,,,,,,],[70,,,,,,,,,,,,],[71,,,,,,,,,,,,],[72,,,,,,,,,,,,]]$

Enter

Accessibility: Good to go

$3-$month moving average for August $2024.$

$6-$month moving average for August $2024.$

For which time series will the coefficient of variation $($CV$)$ be lowest $$ the $3-$month moving average or the $6-$month moving average? $($Hint: The Excel$$s Data Analysis ToolPak is the easiest method to generate CV values$).$