Question: #1: (Dfunction) How many customers placed a LARGE order (greater than average)? begin{tabular}{c|c|} hline average & Large orders hline & #VALUE! hline end{tabular}

$\#1: (Dfunction) How many customers placed a LARGE order (greater than$

\#1: (Dfunction) How many customers placed a LARGE order (greater than average)? \begin{tabular}{c|c|} \hline average & Large orders \\ \hline & \#VALUE! \\ \hline \end{tabular} \#2: (Dfunction) What was the total number of highlighters ordered on the weekend? \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \#3: (Dfunction) Who placed the largest order on a Friday? \begin{tabular}{|c|c|c|} \hline Customer Name & Order Day & Quantity \\ \hline 0 & Friday & 0 \\ \hline \end{tabular} \begin{tabular}{|l|c|l|c|r|l|} \hline Customer Name & Contact Info & Product & Quantity & Order Date & Order Day \\ \hline P. Qui & 6798420 & highlighters & 15 & 4/3/19 & Wednesday \\ \hline L. Morris & 3652883 & tshirt & 6 & 4/4/19 & Thursday \\ \hline V. Wu & 1504751 & notebook & 5 & 4/8/19 & Monday \\ \hline L. Morris & 3652883 & highlighters & 4 & 4/8/19 & Monday \\ \hline Y. Zeenith & 1719949 & mug & 3 & 4/9/19 & Tuesday \\ \hline I. Jameston & 8898296 & highlighters & 9 & 4/9/19 & Tuesday \\ \hline C. Dovestail & 9741735 & mug & 9 & 4/9/19 & Tuesday \\ \hline V. Wu & 1504751 & mug & 2 & 4/10/19 & Wednesday \\ \hline T. Unigo & 3114039 & highlighters & 8 & 4/11/19 & Thursday \\ \hline S. Tavshan & 3476423 & notebook & 10 & 4/12/19 & Friday \\ \hline M. Neilson & 6444430 & tshirt & 7 & 4/14/19 & Sunday \\ \hline D. Everest & 1348405 & mug & 1 & 4/15/19 & Monday \\ \hline T. Unigo & 3114039 & mug & 3 & 4/16/19 & Tuesday \\ \hline N. O'Donnal & 8902767 & notebook & 2 & 4/16/19 & Tuesday \\ \hline H. Ignacio & 5002539 & tshirt & 8 & 4/17/19 & Wednesday \\ \hline W. Yeeshoo & 9215243 & pencils & 3 & 4/19/19 & Friday \\ \hline B. Chesterfield & 8981107 & notebook & 6 & 4/20/19 & Saturday \\ \hline N. O'Donnal & 8902767 & notebook & 8 & 4/21/19 & Sunday \\ \hline O. Peterson & 1837361 & tshirt & 7 & 4/22/19 & Monday \\ \hline V. Wu & 1504751 & mug & 3 & 4/23/19 & Tuesday \\ \hline V. Wu & 1504751 & mug & 1 & 4/23/19 & Tuesday \\ \hline \end{tabular} \#1: (Dfunction) How many customers placed a LARGE order (greater than average)? \begin{tabular}{c|c|} \hline average & Large orders \\ \hline & \#VALUE! \\ \hline \end{tabular} \#2: (Dfunction) What was the total number of highlighters ordered on the weekend? \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \#3: (Dfunction) Who placed the largest order on a Friday? \begin{tabular}{|c|c|c|} \hline Customer Name & Order Day & Quantity \\ \hline 0 & Friday & 0 \\ \hline \end{tabular} \begin{tabular}{|l|c|l|c|r|l|} \hline Customer Name & Contact Info & Product & Quantity & Order Date & Order Day \\ \hline P. Qui & 6798420 & highlighters & 15 & 4/3/19 & Wednesday \\ \hline L. Morris & 3652883 & tshirt & 6 & 4/4/19 & Thursday \\ \hline V. Wu & 1504751 & notebook & 5 & 4/8/19 & Monday \\ \hline L. Morris & 3652883 & highlighters & 4 & 4/8/19 & Monday \\ \hline Y. Zeenith & 1719949 & mug & 3 & 4/9/19 & Tuesday \\ \hline I. Jameston & 8898296 & highlighters & 9 & 4/9/19 & Tuesday \\ \hline C. Dovestail & 9741735 & mug & 9 & 4/9/19 & Tuesday \\ \hline V. Wu & 1504751 & mug & 2 & 4/10/19 & Wednesday \\ \hline T. Unigo & 3114039 & highlighters & 8 & 4/11/19 & Thursday \\ \hline S. Tavshan & 3476423 & notebook & 10 & 4/12/19 & Friday \\ \hline M. Neilson & 6444430 & tshirt & 7 & 4/14/19 & Sunday \\ \hline D. Everest & 1348405 & mug & 1 & 4/15/19 & Monday \\ \hline T. Unigo & 3114039 & mug & 3 & 4/16/19 & Tuesday \\ \hline N. O'Donnal & 8902767 & notebook & 2 & 4/16/19 & Tuesday \\ \hline H. Ignacio & 5002539 & tshirt & 8 & 4/17/19 & Wednesday \\ \hline W. Yeeshoo & 9215243 & pencils & 3 & 4/19/19 & Friday \\ \hline B. Chesterfield & 8981107 & notebook & 6 & 4/20/19 & Saturday \\ \hline N. O'Donnal & 8902767 & notebook & 8 & 4/21/19 & Sunday \\ \hline O. Peterson & 1837361 & tshirt & 7 & 4/22/19 & Monday \\ \hline V. Wu & 1504751 & mug & 3 & 4/23/19 & Tuesday \\ \hline V. Wu & 1504751 & mug & 1 & 4/23/19 & Tuesday \\ \hline \end{tabular}

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!

While on holiday in Bridlington, Helen had her credit cards and purse stolen from the beach while she was swimming. She was left with only 40, which she had kept in her hotel room, but she had three...

H 1 J K L M N o P B C D E F G 1 Practice 3 2 Analyze product sales. For each order, customer name, contact info are given. 3 Product and order quantity as well as order date and day of week are...

How does McDonald's create value for its customers? What are its key success factors? Here is the reading: McDonald's (in 2013): How to Win Again? FEBRUARY 24, 2013. Don Thompson looked over the 2012...

1. Analyze the five-forces for the fast food restaurant industry. what about all companies in the industry, do they face the same pressures? How do firms survive the competition? Here is the reading:...

1. What factors in the General Environment have affected the restaurant industry since McDonald's founding? What impact have they had on competitors and McDonald's in particular? McDonald's (in...

1.Analyze the five-forces for the fast food restaurant industry. a)The bargaining power of customers or buyers b)The bargaining power of suppliers c)The threat of substitution d)The threat of new...

Prove overhead rate is 105% of the material cost. Introduction Woodhill Paper Company (WPC), a small, closely-held paperboard manufacturer that produces a broad line of paperboard in large reels,...

NOTE** READ THE CASE AND FOLLOW ALL INSTRUCTIONS STEP BY STEP. CALCULATION ON EXCEL VERY IMPORTANT. Above is the case, now follows the questions. EXCEL file and well explained work important. THE...

Compute the DPMO and sigma level of the order taking task using the data in exhibit 4.2. Based on the sample data on pizza thickness collected for the 30 day period and presented in Exhibit4.1,...

Q8 A firm that operates a large, direct-to-consumer sales force would like to implement a system to monitor the progress of new agents. A key task for agents is to open new accounts; an account is a...

Titrations (a) Reading a titration curve (d) (a) [130] = - ka + VOLUME OF BASE ADDED A titration curve for a monoprotic weak acid with a strong base was obtained and is displayed above. From the...

How much will the monthly payment be? Sarah wants to buy a new car worth $10,000. The dealer offers to finance the car at a 16.82% nominal interest rate for 15 months if she pays a $1,000 down...

Carly has one child, Chris, who is 1 8 years old at the end of the year. Chris lived at home for three months during the year before leaving home to work full time in another city. During the year,...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...