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

Tietoa työnantajasta:
( 70 arvostelua ) munich, Germany

Projektin tunnus: #14972460

49 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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ä
(198 arvostelua)
7.1
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ä
(172 arvostelua)
6.7
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ä
(123 arvostelua)
6.3
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ä
(146 arvostelua)
6.5
TonmoyRoy111

A proposal has not yet been provided

$35 USD 1 päivässä
(217 arvostelua)
6.3
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ä
(135 arvostelua)
6.3
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ä
(37 arvostelua)
5.8
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ä
(60 arvostelua)
5.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ä
(28 arvostelua)
5.5
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ä
(26 arvostelua)
5.3
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ä
(61 arvostelua)
5.2
The24CarrotsInc

A proposal has not yet been provided

$20 USD 1 päivässä
(42 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
$50 USD 2 päivässä
(11 arvostelua)
4.8
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ä
(24 arvostelua)
4.8
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ä
(62 arvostelua)
4.8
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ä
(17 arvostelua)
4.5
$40 USD 10 päivässä
(16 arvostelua)
4.0
jasalaz100

I KNOW WHAT A MEDIAN IS I ALREADY SOLVED USING EXCEL FORMULAS LeatCat: 99992 ColumnM: 646,22 ColumnO: 528,57 ColumnP: 2.075,21 LeatCat: 100045 ColumnM: 192,44 ColumnO: 192,44 ColumnP: 1.005,04 I dont´t if the w Lisää

$40 USD 0 päivässä
(8 arvostelua)
3.8
$40 USD 10 päivässä
(10 arvostelua)
4.3