Question: The sample data on this page is sales data for an imaginary office supply company, and each row represents one order. Each row shows: -

The sample data on this page is sales data for an imaginary office supply company, and each row represents one order. Each row shows: - OrderDate: when the order was placed, - Region: geographical area in which the sale was made - Rep: sales representative's name - Item: name of the item sold - Units: number of units sold - UnitCost: cost of one unit - Total: total cost of the order - Units x UnitCost Now, please answer the following questions: 1. What is the average unit cost of all orders? ( 1.25 points) 2. How many units are sold in total? ( 1.25 points) 3. What is the maximum value for the number of sold units? (tip: you can either use sorting feature or "max0" function) ( 1.25 points) 4. How many of the orders are placed in the Central region? ( 1.25 points) 5. (optional) What is the difference between the total sold units of pencil and pen? ( 0.5 Extra points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Poindexter LeMans sat at his Louis XIV desk and looked at the garage monitor. Sure enough, there was his Bugatti Chiron Sport 110 Ans parked snuggly in the middle of his other 50 cars. He thought to...

A vendor is recommending a program to make supervisors better at 'dealing with difficult conversations' at work. How would you apply the concepts of optimisation and the Kirkpa- trick model to set up...

Is it possible to estimate the ROI of training for all training programs? Which are more or less susceptible to this calculation? 6 TRAINING AND DEVELOPMENT CFO asks CEO, 'What happens if we invest...

Demand Estimation Assignment Charlies Charlies Meat Market sells a variety of high-quality meats in Memphis, TN. While they have been in business several years, they have approached you to provide...

BlueStar Office Supply Company Introduction BlueStar is a well established office supply company with annual revenue of $950M. The company sources, manufactures, and markets a variety of products...

Data For Tasks 1-8, consider the following data: 7.2, 1.2, 1.8, 2.8, 18, -1.9, -0.1, -1.5, 13.0, 3.2, -1.1, 7.0, 0.5, 3.9, 2.1, 4.1, 6.5 In Tasks 1-8 you are asked to conduct some computations...

Quizzes and graded assignments in MATH1280 are NOT group projects. Please answer the questions and do not share the questions or answers with others or accept advance access to questions or answers...

Determine the location of the center of mass of the cylinder shown if its density varies directly with the distance from its base,3 i.e., = 200z kg/m3. 0.5 m 1m (0,0, 2) dz y

Using the value line investing survey, list the average annual P/E ratio for the following companies for the last five years: Apple computer, Coca-Cola, Caterpillar, and Amazon. What conclusions can...

Which term refers to the effective date of an employee participation of 4 0 1 ( k ) plan option a entry date option B contribution date option BC for vesting or option the age requirement

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...