The following information applies to the questions displayed below.] This exercise provides a total of 13 data visualizations that describe a real companys performance based on 17 quarters of financial data. The visualizations are grouped into five dashboards that were created in Tableau: (1) sales analysis, (2) gross margin analysis, (3) operating expense analysis, (4) profitability analysis, and (5) market performance analysis. Required: For each section, review the Tableau visualizations and answer the questions.

Refer to the Operating Expense Analysis Dashboard below and answer the questions.

(Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 3a-1. Which of the following statements are true with respect to Visualization 1: Technology and Content Expense as a Percent of Sales: Year-Over-Year?

check all that apply 1

• It shows trends in each quarters technology and content expense beginning with quarters 1-4 of year 1 and running consecutively to quarters 1-4 of year 4.unanswered
• It shows each quarters technology and content expense as a percent of sales on a year-over-year basis.unanswered
• It shows each quarters technology and content expense (in billions of dollars) on a year-over-year basis.unanswered

3a-2. Which of the following statements are true with respect to Visualization 2: Fulfillment Expense as a Percent of Sales: Year-Over-Year?

check all that apply 2

• The five blue bars depict the fulfillment expense as a percent of sales for the first quarter of years 1-5.unanswered
• It shows each quarters fulfillment expense as a percent of sales on a year-over-year basis.unanswered
• The four red bars depict the fulfillment expense as a percent of sales for the fourth quarter of years 1-4.unanswered

3a-3. Which of the following statements are true with respect to Visualization 3: Marketing Expense as a Percent of Sales: Year-Over-Year?

check all that apply 3

• The four red bars depict the marketing expense as a percent of sales for the third quarter of years 1-4.unanswered
• It shows each quarters marketing expense as a percent of sales beginning with quarters 1-5 of year 1 and running consecutively to quarters 1-4 of year 4.unanswered
• The four orange bars depict the marketing expense as a percent of sales for quarters 1-4 of year 2.unanswered

3b-1. Which of the following statements are true with respect to Visualization 1: Technology and Content Expense as a Percent of Sales: Year-Over-Year?

check all that apply 4

• The technology and content expense as a percent of sales for each of the quarters in years 3 and 4 is equal to or greater than the corresponding quarters in years 1 and 2.unanswered
• The technology and content expense as a percent of sales always ranges between 10% and 14% for all 17 quarters.unanswered
• The percentages for quarter 4 (across all four years) are lower than all of the other percentages depicted in the chart.unanswered

3b-2. Which of the following statements are true with respect to Visualization 2: Fulfillment Expense as a Percent of Sales: Year-Over-Year?

check all that apply 5

• In quarter 2, the companys fulfillment expense as a percent of sales steadily increased from 12.4% in year 1 to 15.0% in year 4.unanswered
• The fulfillment expense as a percent of sales is trending slightly downward (on a year-over-year basis) in the fourth quarter of year 4 and the first quarter of year 5.unanswered
• Broadly speaking, the companys fulfillment expense as a percent of sales is decreasing over time.unanswered

3b-3. Which of the following statements are true with respect to Visualization 3: Marketing Expense as a Percent of Sales: Year-Over-Year?

check all that apply 6

• The companys marketing expense as a percent of sales reached its 17-quarter peak of 6.1% in the first quarter of year 5.unanswered
• In quarter 3, the companys marketing expense as a percent of sales steadily increased from 5.0% in year 1 to 5.8% in year 4.unanswered
• The marketing expense as a percent of sales for each of the quarters in years 3 and 4 is always greater than or equal to the same quarters in years 1 and 2.unanswered

3c. Which of the following statements are true with respect to the three visualizations contained in the Operating Expense Analysis Dashboard?

check all that apply 7

• If you combine the three expenses depicted in these three visualizations, they equal 29.0% of sales in the first quarter of year 1.unanswered
• If you combine the three expenses depicted in these three visualizations, they equal 33.8% of sales in the first quarter of year 5.unanswered
• If you combine the three expenses depicted in these three visualizations, they equal 27.6% of sales in the third quarter of year 3.

07 10.0% 15.0% 15.0% Y1-01 4.8% Y1-01 12.1% Y1 - Q1 12.1% Y2-01 4.9% Y2-01 12.7% Y2-01 12.1% Y3-01 5.4% Y3-01 13.2% Y3-01 13.5% Y4-01 5.3% Y4-Q1 15.3% Y4-Q1 13.2% Y5-01 6.1% Y5-01 14.4% Y5-01 13.3% Y1-Q2 5.0% Y1 - Q2 12.4% Y1-02 13.0% Y2-Q2 5.1% Marketing Expense as a Percent of Sales: Year-Over-Year Y2-02 12.8% Year-Over-Year Technology and Content Expense as a Percent of Sales: Y2-02 12.8% Fulfillment Expense as a Percent of Sales: Year-Over-Year Y3-02 5.9% Y3-02 13.6% Y3-02 14.6% Y4-Q2 5.5% Year/Quarter Y4 - Q2 15.0% Year/Quarter Y4-02 13.7% Year/Quarter Y1-Q3 5.0% Y1-03 12.7% Y1-Q3 12.6% Y2-03 5.3% Y2-Q3 13.3% Y2-03 12.6% Y3-03 5.7% Y3-03 14.7% Y3-03 13.6% Y4-03 5.8% Y4 - Q3 14.6% Y4-03 12.7% Y1-04 4.9% Y1-Q4 12.7% Y1-04 10.0% Y2-04 5.7% Y2-04 13.1% Y2-Q4 10.4% Y3-04 5.7% Y3-04 14.8% Y3-04 10.4% Y4-04 6.8% Y4 - Q4 13.9% Y4 - Q4 10.6%