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
** 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
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
51 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön
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
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
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