Use the Data Given Below to Answer the Following Question(s)

question 10

Multiple Choice

Use the data given below to answer the following question(s) .
The table provided below gives the sales details of the number of android smart phones at an electronic retail store for the past 6 weeks. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. (Hint: Optimize α value in 0.1 increments) $$\begin{array} { | c | c | } \hline \text { Week } & \text { Units sold } \\\hline 1 & 88 \\\hline 2 & 44 \\\hline 3 & 54 \\\hline 4 & 65 \\\hline 5 & 72 \\\hline 6 & 85 \\\hline\end{array}$$
-Calculate the value of the mean absolute percentage error for the given data.

• A) 20.90
• B) 16.60
• C) 21.72
• D) 29.97

---

Definitions:

Prewritten Formula

Predefined calculations offered in spreadsheet software like Excel, which automatically perform operations on data when applied.

Excel

A spreadsheet application developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns.

Built into Excel

A phrase denoting features or functionalities that are directly incorporated into Microsoft Excel, such as formulas, pivot tables, and charts.

Cooler Colors

Colors that are perceived as calming and soothing, typically including blues, greens, and purples, often associated with water, sky, or foliage.