Suljettu

excel calculate MEDIAN

attached is a table -

you have to calculate all the blue marked cells in the results_tab.

Some values i calculated (for your crosscheck), so you can see if you calculate correct.

I used the Excel MEDIAN() formula.

you can also use the real Median formula if you use VBA; results can then be slightly different

REMARKS:

** if you dont know what a median is pls dont bid.

** Pls start with " I KNOW WHAT A MEDIAN IS" -

all bids without that are considered generic and will be deleted

Sorry, and thanks for your understanding

Winner must:

a) provide one sentence how he will solve this (by excel formulas or VBA scripts, especially the weigthed MEDIAN (weighted by the number of sold units)

b) provide at least 1 number for each type as test to verify correct calculation before award

c) should provide resuklts by latest tomorow afternoon

thank you

Taidot: Excel, Excel VBA

Näytä lisää: excel calculate workload, excel calculate refresh queries vb6, creating function excel calculate cidr, excel calculate projected sales, use excel calculate store expenses, hpsd excel calculate, excel calculate money, reading excel file writing access table, using excel calculate regression, use excel calculate regression, excel vba internet html table, excel calculate regression, logarithmic regression excel calculate, write excel file dataset data table, excel multiuser vba access table, excel calculate statistics, excel web services pivot table, macro excel calculate range, use excel calculate stat, excel calculate work hours days, transfer data excel multiple sheet access table

About the Employer:
( 68 reviews ) munich, Germany

Projektin tunnus: #14972460

51 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Lisää

50 $ USD 1 päivässä
(182 arvostelua)
7.0
elqueabandona

I KNOW WHAT A MEDIAN IS Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Best regards Habilidades y experi Lisää

100 $ USD 3 päivässä
(167 arvostelua)
6.6
best4best

I KNOW WHAT A MEDIAN IS. I can calculate the MEDIANS using Excel Median function with 100% accuracy for all the Cat IDs. Below is the sample data: Lead_Cat | Offered Price MED | Sold Price MEDIAN 99996 | 755.46 Lisää

45 $ USD 1 päivässä
(121 arvostelua)
6.2
avinav606lx

I KNOW WHAT A MEDIAN IS I can try this in VBA using formulas. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Relevant Skills and Experienc Lisää

61 $ USD 1 päivässä
(124 arvostelua)
6.2
sandroshubladze

I KNOW WHAT A MEDIAN IS Hi I can complete your task using vba , quickly If interested, let me know Relevant Skills and Experience Excel VBA Proposed Milestones $40 USD - F

40 $ USD 1 päivässä
(82 arvostelua)
6.1
TonmoyRoy111

A proposal has not yet been provided

35 $ USD 1 päivässä
(196 arvostelua)
6.1
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience Excel Proposed Milestones $40 USD - d

40 $ USD 10 päivässä
(58 arvostelua)
5.6
dgled

Hi I KNOW WHAT A MEDIAN IS. To give you a result meaning to work on the project (which have to be done by VBA). I have experience in accounting, Financial Report Tools, and in Excel/VBA. I served as CFO, Controller, an Lisää

250 $ USD 10 päivässä
(32 arvostelua)
5.7
MoohHHooM

I KNOW WHAT A MEDIAN IS i can help you in this project: a) by formulas b) working on it .

40 $ USD 0 päivässä
(24 arvostelua)
5.3
50 $ USD 2 päivässä
(10 arvostelua)
4.8
osmemon

I am statistics export with strong skills on excel and VBA... See my profile for client reviews about me.. I can get this done very quickly. Relevant Skills and Experience Excel, VBA, 7 Years of experience. Proposed Lisää

25 $ USD 1 päivässä
(15 arvostelua)
5.1
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Lisää

48 $ USD 2 päivässä
(40 arvostelua)
5.6
The24CarrotsInc

A proposal has not yet been provided

20 $ USD 1 päivässä
(32 arvostelua)
4.7
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $30 Lisää

30 $ USD 10 päivässä
(45 arvostelua)
4.9
beltran0404

"I KNOW WHAT A MEDIAN IS" Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this excel - median project! I see your file and I understand what you are requiring you need to calculate the med Lisää

30 $ USD 10 päivässä
(54 arvostelua)
4.7
SShtv

I KNOW WHAT A MEDIAN IS" Relevant Skills and Experience I KNOW WHAT A MEDIAN IS" Proposed Milestones $50 USD - calculate MEDIAN

50 $ USD 1 päivässä
(20 arvostelua)
4.5
daniyal3214

I know what a median is. I posses expertise in utilizing advance level tools of excel to perform financial analysis, regression analysis and other statistical analysis along with data analysis. Relevant Skills and Exp Lisää

40 $ USD 10 päivässä
(15 arvostelua)
4.2
princessheather

I know what a median is, a median is the middle number in a series of numbers, so in this case I would add up values in an excel sheet and determine the median. Relevant Skills and Experience I have done multiple math Lisää

40 $ USD 10 päivässä
(6 arvostelua)
3.1
shezy007

I KNOW WHAT A MEDIAN IS "I'm expert of Probability & Statistics " Using Excel Formula ..!! Relevant Skills and Experience Stat , Excel expert Proposed Milestones $45 USD - excel calculate MEDIAN

45 $ USD 10 päivässä
(5 arvostelua)
2.8
ank199018

I know what a median is. I am a data scientist by profession and having high level advance excel skills. I have solved many complex problems in excel. Please contact me. Relevant Skills and Experience Excel,VBA Propo Lisää

30 $ USD 10 päivässä
(3 arvostelua)
3.1