Loading
HomeComputer Science Help › excel, advanced vlookup from two workboobs and pivot tables.
Status: Completed
excel, advanced vlookup from two workboobs and pivot tables.
Date Posted: 19/04/2021
Category: Computer Science
Due Date: 20/04/2021
Instruction
Please note: -Explain how you produced the information. This should be done by writing 2- 3 sentences explaining the steps you went through producing the information for each of the tables that are produced. -Interpret the information that you have produced. This should be done by writing 2-3 sentences based on the information for each of the tables that are produced. Following are the questions for excel: (a) A table that shows a row for each customer that is sorted by their last name, and a column for each month that shows the total number of orders that have been processed for each customer in each month. Note: If you have the first name of the customer in cell C17 and the last name of the customer in cell D17, the following formula in cell E17 with produce the last name followed by a comma followed by the first name: =D17&", "&C17 If you were to then create a pivot table, using the data in column E for the rows in the pivot table would show the full name of the customer, and have them sorted into alphabetical order by last name. (b) A table that shows a row for each month and a column for each city that shows the total value of orders that were processed in each city in each month. (c) A table that shows a row for each month and a column for each city that shows the average number of days taken to process orders in each city in each month. (d) A table that shows the outliers (where an outlier is defined for the purposes of this exercise as being more than 2 standard deviations below the mean number of days to process an order or 2 standard deviations above the mean number of days to process an order) based on the city of the customer. (e) A table that shows the outliers (where an outlier is defined for the purposes of this exercise as being more than 2 standard deviations below the mean number of days to process an order or 2 standard deviations above the mean number of days to process an order) based on the month of the order.
Bidders
paulk 4 years, 12 months ago
Rated 9.77 earned 9672.34 around 332 assignments.
After reviewing your instructions, I decided to bid confidently that I will deliver. Thanks
$50.00
  • can you work on excel?
    User_30699 | Apr 19, 2021, 11:40 AM
  • Yes, I'm an expert. But I will charge you $50
    paulk | Apr 19, 2021, 11:51 AM
  • sorry, but will pay $30.
    User_30699 | Apr 19, 2021, 11:58 AM
  • $40
    User_30699 | Apr 19, 2021, 13:24 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
financeville 4 years, 12 months ago
Rated 9.22 earned 28485.23 around 697 assignments.
Hello, are you looking for the best academic writer? Do you need an A grade in your assignment? Do you need your work delivered before the DUE DATE? DON'T WORRY BECAUSE I'M HERE FOR YOU. I'm an expert and a proficient tutor. I have a vast experience and I can assure you of an A grade in this assignment. I deliver timely and plagiarism free papers with impeccable grammar. Please choose me to do your assignment and enjoy my excellent services. I'M THE BEST DEAL YOU WOULD GET.
$70.00
  • its excel
    User_30699 | Apr 19, 2021, 14:13 PM
  • its an excel assignment
    User_30699 | Apr 19, 2021, 14:14 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
kennwals 4 years, 12 months ago
Rated 9.62 earned 40078.92 around 1187 assignments.
I am a tenured mathematician and an expert in not only excel but also R, STATA, SPSS, Mplus, and Mathlab. Kindly assign the order and get value for this engagement.
$65.00
  • happy to pay $40. tips if on time. its in excel, can you do it?
    User_30699 | Apr 19, 2021, 13:39 PM
  • I can do it. Lets make the price a little favorable for the two of us.
    kennwals | Apr 19, 2021, 13:44 PM
  • Make it $65 and the rubber meets the road immediately
    kennwals | Apr 19, 2021, 13:45 PM
  • how long will it take for you to finish the assignment? let me know
    User_30699 | Apr 19, 2021, 13:48 PM
  • A day or two..
    kennwals | Apr 19, 2021, 13:50 PM
  • can you take a look at the assignment see..if you can deliver it
    User_30699 | Apr 19, 2021, 13:51 PM
  • in next 12hours or so? please
    User_30699 | Apr 19, 2021, 13:55 PM
  • I have evaluated the instructions and i can deliver on it.
    kennwals | Apr 19, 2021, 13:56 PM
  • 16 hours is workable.
    kennwals | Apr 19, 2021, 13:57 PM
  • okay...sure? i dont dont to suffer a loss on this one..please
    User_30699 | Apr 19, 2021, 14:00 PM
  • if 16 hours then its okay... but still if you can manage it a bit before that, i will appreciate it.
    User_30699 | Apr 19, 2021, 14:01 PM
  • should i assign it to you then?
    User_30699 | Apr 19, 2021, 14:07 PM
  • let me know and i will assign you for the assignment
    User_30699 | Apr 19, 2021, 14:28 PM
  • Kindly assign
    kennwals | Apr 19, 2021, 14:47 PM
  • can you change the price to $65
    User_30699 | Apr 19, 2021, 15:19 PM
  • have assigned you. i will really really appreciate in next 16 hours or earlier
    User_30699 | Apr 19, 2021, 15:37 PM
  • Hey i forgot to mention that in the assignment on one ot the excel sheets there is contacts name with,. &&-nnnn, where nnnn is two to four digit number. The contacts with && on that list are the only ones to be concerned with or in simple words they are the one required to be sorted with the questions. Hope you understand
    User_30699 | Apr 19, 2021, 21:10 PM
  • Does this mean that we ignore the rest of the names in answering the questions? i.e. do we limit the respondents to only those with a prefix  &&-nnnn?
    kennwals | Apr 19, 2021, 23:59 PM
  • Yes please . Really sorry for the confusion. Thanks for responding
    User_30699 | Apr 20, 2021, 00:02 AM
  • Hi there. Any update on the assignment. Please and thanks.
    User_30699 | Apr 20, 2021, 05:09 AM
  • Hello, With the reviews sent, i have had to start over. Will be uploading in the next 2 and half hrs.
    kennwals | Apr 20, 2021, 05:18 AM
  • i am soory about that. happy to wait. but I will higly appreciate it if you could do it around that time frame. many many thanks
    User_30699 | Apr 20, 2021, 05:22 AM
  • hi there. Any update yet with the excel assignment. please
    User_30699 | Apr 20, 2021, 09:03 AM
  • Finalizing on interpreting the last bit. Just 10 minutes please
    kennwals | Apr 20, 2021, 09:12 AM
  • okay...no probs
    User_30699 | Apr 20, 2021, 09:15 AM
  • Kindly confirm receipt and rate me well. Thank you
    kennwals | Apr 20, 2021, 09:52 AM
  • hi there. can you please send me the excel sheet you worked on? please
    User_30699 | Apr 20, 2021, 10:48 AM
  • sorry just seen your message. i need to attach the actual excel sheet in which the functions/formula were typed and show the actual work in excel.
    User_30699 | Apr 20, 2021, 10:51 AM
  • i really need the workings in excel that you used
    User_30699 | Apr 20, 2021, 10:55 AM
  • I have uploaded the excel workbook. Kindly check
    kennwals | Apr 20, 2021, 10:55 AM
  • hi there. no probs. i was out. just got back. i am going through the excel sheets. Please give me 10 minutes or so and i will release the payment. also i will add a bonus if everything is okay. sorry for the trouble
    User_30699 | Apr 20, 2021, 11:10 AM
  • Thanks for your help. I have released the payment. thanks once again
    User_30699 | Apr 20, 2021, 11:32 AM
  • Hey will you mind rating me with 10 stars?
    kennwals | Apr 20, 2021, 17:34 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
drjim 4 years, 12 months ago
Rated 9.55 earned 24203.41 around 648 assignments.
Hello! I can work on this task asap. I can also help you with your whole class at a discount!
$75.00
  • the assignment is for excel. can you do it?
    User_30699 | Apr 19, 2021, 13:14 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
committedwriter 4 years, 12 months ago
Rated 9.14 earned 89563.32 around 3017 assignments.
Hello, I can do this work for you. Am posses advanced excel skills and therefore am the best
$75.00
  • hi there. $35+$(tip). if you were to finish it at earliest stage possible, please and thanks
    User_30699 | Apr 19, 2021, 12:57 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
tutor4U_d_971 4 years, 12 months ago
Rated 9.33 earned 53632.21 around 1383 assignments.
Hello Friend, Kindly allow me to help you in SPSS, R, Excel, R-Markdown, StatCrunch, PhStat, Tableau, MATLAB, and Ms Project, Sociology, Religion, Political science, Psychology, Health Care, Nursing, Finance and Accounting, Economics, Business, Biology, HRM history and Government, Law, Auditing, Research papers, peer review articles, PPT slides, Calculus, Algebra online classes, and term papers. I guarantee distinct and excellent work. Quality, Timely and 100% plagiarism free work. Nothing short of A+++ and GPA 4.0
$75.00
  • its an excel assignment. happy to pay $30 as someone is willing to do for the same
    User_30699 | Apr 19, 2021, 12:08 PM
  • I just placed my fair bid
    tutor4U_d_971 | Apr 19, 2021, 12:18 PM
  • $45?
    User_30699 | Apr 19, 2021, 13:25 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
mutungamatee1 4 years, 12 months ago
Rated 9.86 earned 38667.41 around 1279 assignments.
Hi, I am an expert in this particular field and I’m available and happy to work on the assignment. Kindly, hire me for the best results!
$75.00
  • How much time do we have?
    mutungamatee1 | Apr 19, 2021, 11:35 AM
  • around 6 hours. its not too difficult if you are good at excel. happy to pay $30
    User_30699 | Apr 19, 2021, 11:57 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
expert4u 4 years, 12 months ago
Rated 9.0 earned 77109.21 around 2331 assignments.
Hi, this is my area of expertise. Award me this project and you will be assured of quality work. Thank you.
$105.00
  • When do you need it completed?
    expert4u | Apr 19, 2021, 11:34 AM
  • in next 15 hours. its in excel, pivot, look up etc. 5 questions. happy to pay $50
    User_30699 | Apr 19, 2021, 14:52 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
TheMasterTutor 4 years, 12 months ago
Rated 9.22 earned 4872.37 around 168 assignments.
I am an experienced writer well acquainted with this subject, and I am sure I will timely deliver quality work. I am online and ready to start working asap. Kindly assign
$25.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
bestwriter 4 years, 12 months ago
Rated 9.51 earned 8492.90 around 325 assignments.
Hello client, please let me help you for an outstanding work. I will deliver a plagiarism free work on time, with correct grammar and with accurate answers arrived after strictly following instructions
$85.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
aggrey 4 years, 12 months ago
Rated 9.47 earned 33434.92 around 816 assignments.
Hello! I can work on this task asap. I can also help you with your whole class at a discount!
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
Robert_d_308 4 years, 12 months ago
Rated 9.37 earned 62524.46 around 2184 assignments.
Hello friend. I'm here to help you. Thank you
$50.00
  • its in excel, can you do it?
    User_30699 | Apr 19, 2021, 11:50 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
highquality 4 years, 12 months ago
Rated 8.77 earned 11734.44 around 327 assignments.
Dear client, I have read and understood the task requirements and I can assure you that I will deliver a WELL-RESEARCHED and a HIGH-QUALITY paper BEFORE the deadline. In addition, I promise to deliver a 100% plagiarism-free paper that meets all your expectations. Kindly assent to my bid
$50.00
  • its an excel assignment
    User_30699 | Apr 19, 2021, 15:29 PM
  • I am proficient in excel
    highquality | Apr 19, 2021, 15:30 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}