Chapter $3$ Assignment

Question $1$ of $6$

$\frac{-}{4}$

View Policies

Current Attempt in Progress

As the company controller for a yarn manufacturing supply company, you are asked to investigate sales by customer for the month of June $2025.$ You have critically assessed the objective and questions of your analysis and documented them as follows:

$\backslash$table$[[$Objective$,$Initial Question,Sub$-$questions,Possible Measures$],[\backslash$table$[[$Understand sales by customer for$],[$the month of June.$]],\backslash$table$[[$What happened to sales in the$],[$month of June?$]],$What was total sales?,$1.$ Sum of sales amount $($total measure$).],[,,\backslash$table$[[$What was the average sales$],[$amount$?]],\backslash$table$[[2.$ Average of sales amount $($measure of$],[$location$).]]],[,\backslash$table$[[$What was total sales by$],[$customer$?]],3.$ Total sales separated by customer.,$],[,\backslash$table$[[$Which customers had the$],[$highest sales?$]],\backslash$table$[[4.$ Total sales separated by customer$],[$using a highlight table.$]],]]$

Click here to view the data.

Click here to view the tableau.

Use the available data to perform the analyses proposed in the possible measures section of the analysis plan. Perform each analysis on a separate tab in an Excel workbook and appropriately label the tab with the corresponding number and an appropriate description. Upload the Excel file that contains your analyses.

Supported file formats: Excel, ZIP