Author: Anonymous

SUMPRODUCT for Resource UsageUsing the same door-and-window data: Plant Door Hours Window Hours Available Hours Plant 1 1 0 4 Plant 2 0 2 12 Plant 3 3 2 18 Suppose the number of doors is in cell B8, the number of windows is in cell C8, and the Plant 3 coefficients, 3 and 2, are in cells B5:C5. Which Excel formula correctly calculates Plant 3 hours used?Source: Adapted from the Wyndor Glass spreadsheet model, Chapter 5.

Exponential Smoothing in ExcelA company uses exponential smoothing to forecast daily call volume. Last month’s forecast was 782 calls, and the actual call volume was 792 calls. The smoothing constant is:alpha = 0.3Use the formula:What is the new forecast?Source: Adapted from J. J. Bone Company forecasting problem, Chapter 4.

Training and Validation PartitionsA spreadsheet contains 1,000 historical customer records. A predictive model is developed using 700 records and then tested on the remaining 300 records. What is the main purpose of using the remaining 300 records?Source: Adapted from the textbook’s Chapter 3 discussion of training and validation partitions.

Classification Tree Prediction in ExcelA classification tree for predicting whether a household will install solar panels uses these rules:If household income is $89,000 and peak sun hours are > 4.25, predict Yes.If household income is > $89,000, peak sun hours are

Classification Tree Prediction with Strong Sun HoursA classification tree for predicting whether a household will install solar panels uses these rules:If household income is $89,000 and peak sun hours are > 4.25, predict Yes.If household income is > $89,000, peak sun hours are

Identifying the Type of AnalyticsA retailer creates a spreadsheet dashboard showing last quarter’s sales by region, product category, and sales representative. The dashboard summarizes what has already happened but does not forecast future sales or recommend an optimal decision. Which category of analytics is this?Source: Adapted from the textbook’s Chapter 1 discussion of descriptive, predictive, and prescriptive analytics.

Classification Tree Prediction with Low Sun HoursA classification tree for predicting whether a household will install solar panels uses these rules:If household income is $89,000 and peak sun hours are > 4.25, predict Yes.If household income is > $89,000, peak sun hours are

What does las gafas de sol mean?

What does la ropa interior mean?

What does la falda mean?