can you write the full equation too
Data Tables - Student Office Warehouse inc. currently makkes four products. The Sales Director has asked you to run a preliminary analysis on last year's saies data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. \begin{tabular}{|l|lr|l|} \hline Products Available & \multicolumn{2}{|c|}{ Price per Unit } & \\ \hline Paper & $ & 21.00 & per case \\ Pens & $ & 8.00 & per box \\ \hline Sticky Notes & $ & 10.00 & per package \\ Envelopes & $ & 4.00 & per box \\ \hline \end{tabular} Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? \begin{tabular}{|l|l|l|} \hline & Product & Total \\ \hline Units Ordered & & \\ \hline Total Sales & & \\ \hline \end{tabular} Which rep has the highest total sales for each region? \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Region } & Rep Name & Total Sales \\ \hline East & & \\ \hline Midwest & & \\ \hline South & & \\ \hline West & & \\ \hline \end{tabular} What is the total annual sales for each region? \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Region } & Total Salos \\ \hline East & \\ \hline Midwost & \\ \hline South & \\ \hline West & \\ \hline \end{tabular} Using the data above, create a pie chart to determine the sales percentage for eacin i eymu. Now, create a PivotTable to determine the monthly sales earned by each region. Use that data to create a 2D clustered column chart. Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year. Data Tables - Student Office Warehouse inc. currently makkes four products. The Sales Director has asked you to run a preliminary analysis on last year's saies data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. \begin{tabular}{|l|lr|l|} \hline Products Available & \multicolumn{2}{|c|}{ Price per Unit } & \\ \hline Paper & $ & 21.00 & per case \\ Pens & $ & 8.00 & per box \\ \hline Sticky Notes & $ & 10.00 & per package \\ Envelopes & $ & 4.00 & per box \\ \hline \end{tabular} Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? \begin{tabular}{|l|l|l|} \hline & Product & Total \\ \hline Units Ordered & & \\ \hline Total Sales & & \\ \hline \end{tabular} Which rep has the highest total sales for each region? \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Region } & Rep Name & Total Sales \\ \hline East & & \\ \hline Midwest & & \\ \hline South & & \\ \hline West & & \\ \hline \end{tabular} What is the total annual sales for each region? \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Region } & Total Salos \\ \hline East & \\ \hline Midwost & \\ \hline South & \\ \hline West & \\ \hline \end{tabular} Using the data above, create a pie chart to determine the sales percentage for eacin i eymu. Now, create a PivotTable to determine the monthly sales earned by each region. Use that data to create a 2D clustered column chart. Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year
