Question: i have been trying so many methods to get this working and failed. Originally I was trying to use take the data from another sheet

i have been trying so many methods to get this working and failed. Originally I was trying to use take the data from another sheet but since its not mandatory I copy and pasted the data in the same sheet which is "Destination" and "Pallets" They are 408 rows and no matter what I enter for the median if function I end up with #VALUE!. I tried using "Oakland CA" to search the correct item in the list and then switched it to search the B6 cell for example and so on. Can anyone provide a function that actually works? Also I am required to use the IF function. Thank you.

i have been trying so many methods to get this working and

-MEDIAN(IF(SBS21:SBS428-A6,$C$21:$C$428)) Mean pallet shipment Median pallet shipment Mode pallet shipment Oakland CA Portland OR #VALUE! 22.2 19.0 6 Riverside Riverside CA #VALUE! Seattle WA 23.0 10 12 13 14 15 16 17 18 19 Was unable to create mean colum with average if function but I have yet to figure out how to obtain median and mode Destination Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Oakland CA Portland OR Portland OR Portland OR Portland OR Portland OR Portland OR Portland OR Portland OR Pallets 21 1 1 1 23 24 1 26 27 28 29 30 31 32 1 35 36 37 38 1 1 M1 A-E Data | Costs&Distances MIA MIB MIC MID MIE MIFM2 A-EFSA-B

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 Databases Questions!

Mauer clearly states there are linking factors between race and class leading to an increase in criminal behavior, what are they? The trial of O. I. Simpson, however unusual, taught the nation much...

Case 11 Equal Exchange: Doing Well by Doing Good1 Rev. Dr. Benita W. Harris Asbury United Methodist Church Frank Shipper, PhD Perdue School of Business, Salisbury University Karen P. Manz Author and...

GLOBAL SOURCING AT NIKE 1. Identify the Ethical dilemma in the case 2. Alternatives to Ethical Dilemma 3. Conclusion of the Case NaE.N-HE MSIE.A MicaA at. W. Tcozsi.1. C.HviA Hu i. Global Sourcing at...

Management 587 Case/Assignment/Summary Activity Name Texas A&M-Commerce In partial fulfillment of the requirements for MGT 587 Professor Lloyd M. Basham June 8, 2014 (The above [and the next 3 lines]...

Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...

Please answer the following question after reading the case study which is attached below: How much PM is enough PM? How much PMO support is enough PMO support? The AtekPC Project Management Office...

The AtekPc project management office A rain had started in the early evening of March 3, 2007, and the streets of Metropolis were cold and grey where the AtekPC headquarters were located. As John...

The AtekPc project management office:- A rain had started in the early evening of March 3, 2007, and the streets of Metropolis were cold and grey where the AtekPC headquarters were located. As John...

1. Question 1 Why do we have an allowance for doubtful accounts? 1 point Your answer cannot be more than 10000 characters. 2. Question 2 The Allowance for doubtful accounts is an 1 point Liability...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS th 8 Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, eighth edition, 2015. Prepared by John Kammeyer-Mueller...

For the following shipment create a basic pallet plan to hold all of the cargo listed. Calculate the chargeable weight of the palletized load for each truck, air and ocean modes of transport. Then,...

Transform the following triple integral into spherical coordinates in the or- der dp do do. 2 4- -x-y HIT -2-4-1 x + y x + y + z2 dzdydx

9. In the United States, nearly all resources are owned by . ( LO1 ) a) the government c) individuals b) business fi rms d) foreigners

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

B Do you have a page on Facebook, MySpace, or some other social networking site? Think objectively about the impression of you that the page conveys. Would you hire you?

4 How can you create a better online image for yourself?

Tell me about yourself. What led you to choose your particular field (or your academic major)? Describe your level of satisfaction with your choice.