Attempt $1$

In Progress

NEXT UP: Submit Assignment

Add Comment

$1$ Attempt Allowed

$\frac{8}{26}\frac{?}{2024}$ to $\frac{10}{13}\frac{?}{2024}$

Details

Problems $5,7,9$ and $25$ due $11$:$59$pm $10/13.$ YOU MUST USE FORMULAS IN

YOUR SPREADSHEET FILES to fully use Excel's capabilities & avoid point

deductions.

Submit completed Excel workbooks by clicking on the assignment name in Canvas

and attaching your file. Please rename the file with your last name.

The Word document or pdf file contain some suggestions for completing the

assignment spreadsheets.

There are some videos in the Ch $8$ Videos folder that show how to enter some of

the formulas you need to enter in order to complete the assignment.

The Excel Videos folder contains some videos showing you how to use Excel.

Ch $8$ Homework Shell Summer $2017.$xIsx

darr

MGT $465$ Suggestions for completing spreadsheet shell.docx ubrace$(darrubrace)$

Given the historical date, which do you think would be the better to use?

you need to enter in order to complete the assignment.

Problem $5$

Don't forget to answer the question about which forecast to use in the spreadsheet.

Reference the alpha values stored in cells C $2$ and C $12$ when you enter the exponential

smoothing formula in column C$.$ Entering cell references in formulas rather than

numerical values makes it easier to change the alpha values; simply enter new values in

cell C$2$ or C$12$ and the spreadsheet automatically calculates new forecasts and MAD

values.

Use the MAD function $($Mean Absolute Deviation$)$ to calculate the absolute error values

in column E$.$

Use the average function to calculate the MAD value.