Find Jobs
Hire Freelancers

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

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 18030259

About the project

12 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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, SPSS I am able, available and ready to do this kind of work in the best conditions,
$10 USD in 1 day
5.0 (9 reviews)
2.9
2.9
12 freelancers are bidding on average $34 USD for this job
User Avatar
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 markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD in 3 days
4.8 (65 reviews)
5.6
5.6
User Avatar
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 in 1 day
4.7 (47 reviews)
5.7
5.7
User Avatar
"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 working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$20 USD in 1 day
5.0 (19 reviews)
4.6
4.6
User Avatar
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. I have viewed your attachments and I can help in computing weighted average price. I have done this throughout my education and work life. I have high professionalization in excel analysis, data processing and statistical projects. Best Regards, Isabella Hills.
$30 USD in 1 day
5.0 (11 reviews)
4.6
4.6
User Avatar
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, SEO, Web designing, Mobile Application, Complete Software Solution and Maintenance & Support. We have expert team members for our different services so that we can deliver our best solutions and services to our esteem client.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 fast delievery is guaranteed .
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of POLAND
Warszawa, Poland
5.0
1
Payment method verified
Member since Aug 10, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.