Ολοκληρωμένο

I need some help with Excel - how to calculate the weighted average price?

I have made a list of 28 online pharmacies containing prices of 75 drugs in order to find out what pharmacy is the cheapest by calculating the total basket value.

Because non of the pharmacy has 100% products, I have to calculate price of the products that are missing. I don't want calculate the average price and use it in case the pharmacy doesn't have the specific product - it won't be fair towards cheap pharmacies that don't have many of the products.

I want to calculate the average price of the missing product taking into account price level of other products that are avaliable in certain pharmacy - if the pharmacy in cheap, I assume that the missing product will be cheap as well.

Ικανότητες: Επεξεργασία Δεδομένων, Excel

Περισσότερα: need help excel contacts, excel vba weighted average example files, i need a excel spreedsheet prepared, weighted ranking excel, weighted average calculation, weighted grade calculator excel template, weight in excel, weighted average excel pivot table, excel weighted average if, volume weighted average price excel, how to calculate weighted average in excel with percentages, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker

Σχετικά με τον Εργοδότη:
( 0 αξιολογήσεις ) Poland

Ταυτότητα Εργασίας: #18030259

Ανατέθηκε στον:

Galata16

As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, Minitab, Περισσότερα

$10 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0

13 freelancers κάνουν προσφορές κατά μέσο όρο $33 για αυτή τη δουλειά

citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Περισσότερα

$150 USD σε 3 μέρες
(56 Αξιολογήσεις)
5.4
$30 USD σε 1 μέρα
(51 Αξιολογήσεις)
5.1
khurram1984

Hi. I am an affiliate chartered accountant (equivalent to CPA) and a financial expert since 2009. i can take care of your weighted average cost issue as per requirement. Please contact and discuss the details.

$40 USD σε 1 μέρα
(21 Αξιολογήσεις)
4.7
rifamorejo

Hello, I am master in economics and currently, I am enrolled in PhD program of Middlesex University. I am very dedicated and I ensure timely performance, highest quality and accurate work as per client instructions Περισσότερα

$30 USD σε 1 μέρα
(9 Αξιολογήσεις)
4.4
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Περισσότερα

$20 USD σε 1 μέρα
(14 Αξιολογήσεις)
3.4
sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with data processing using Excel formula and macro. I have finished many projects like this. I'm confident in your project and I promise to do your proj Περισσότερα

$25 USD σε 1 μέρα
(6 Αξιολογήσεις)
3.4
DigitallyBoost

Digitally Boost is a leading company in Delhi NCR. Our main aim is client satisfaction, we provides the our best services to our client so that client boost their business on next level. We deal in Digital Marketing Περισσότερα

$20 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Mnaeem3761

Hello , I am a professional Accountant having wast knowledge about preparation of Financial statements . I also have 6 months MS office training crerificate. Your work will be done exactly as per your requirements and Περισσότερα

$15 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Ashwanip1

Hello! I have read your project description and would like to do this for you as per your requirement using MS word. 14 Month Experience in copy Editor and proof reader in news paper in India for Us and 1 year exp. Περισσότερα

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
$15 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0