Find Jobs
Hire Freelancers

Excel file with average rates fill in the blanks and analyze data with detailed report

$250-750 USD

Cancelled
Posted almost 7 years ago

$250-750 USD

Paid on delivery
Hello, Please see attached file of 18,226 Flatbed/Van rates for 12 months. I need to fill in the blanks and analyze the rates. The first task is to come up with a way to fill in all the missing rates with an average rate from the previous and succeeding months. One challenge will be there are multiple blank rates in a row. Second task analyze data. I need to know there are no outliers for rates in these files. There should be a natural flow for the rates going up or down and no large spikes in the data. I'm looking for a very detailed report. In your bid please describe what kind of data you can provide me in analyzing this data. Thank you,
Project ID: 13835160

About the project

36 proposals
Remote project
Active 7 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
36 freelancers are bidding on average $359 USD for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I always take project to completion. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$500 USD in 3 days
5.0 (897 reviews)
9.4
9.4
User Avatar
"Dear employer, can we Discuss more over the chat and do the sample for you?! I am a highly trained Data Entry, Research, Web search, Web scrape, Product Add Any Type Of eCommerce Cart, Expert with great knowledge of Excel and all Social Networks. Please check my profile and ask me if you have any quest?? My bid is optional and I will let you chose the price that suits you best!!! I just want to prove my skills and have a long-term employer in you!!! Ready to work right now. Jewel.!!" Finally, I'll invite you to visit my Portfolio, here, to know me more in deep and see what people says about my jobs. https://www.freelancer.com/u/jeweljitu.html No more Sr., do not hesitate to contact me, I'll be glad to answer you. Have a nice day. Regards. Jewel. P.S.: I will not accept any previous award before to discuss with you all the details."
$526 USD in 10 days
4.9 (1074 reviews)
8.8
8.8
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$300 USD in 3 days
4.9 (560 reviews)
8.5
8.5
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$250 USD in 2 days
5.0 (503 reviews)
8.0
8.0
User Avatar
1st Task: I need to calculate the average rates from previous and succeeding months. I understand some rows have multiple blanks. Will not be a problem. 2nd Task: I can create a DYNAMIC chart within the spreadsheet, that will show you if there is a spike of more than 10% (percentage will be customizable) ZERO ERROR GUARANTEED!! Please read my 190+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$250 USD in 5 days
5.0 (321 reviews)
7.8
7.8
User Avatar
Hi there! I’m an expert on any data entry jobs and I’ve lot of experience on this type projects.. I’m ready to start it right away. I look forward to hearing from you. Regards
$555 USD in 10 days
4.8 (267 reviews)
7.3
7.3
User Avatar
I can do exactly what you need. I can obtain the missing rates you need and then to analyze the data by standard methods of statistical analysis in which I am an expert. It is reasonable to define outliers as data points that are more than 3 standard deviations from the mean of the sample. If you have other suggestions, please let me know, but you can safely leave the statistical analysis to me if you wish. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$250 USD in 10 days
4.8 (202 reviews)
7.3
7.3
User Avatar
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We can do this for you quickly and with great quality as per your budget.. We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think is fair. Please do give me a shot. Awaiting your response. Thanks!
$250 USD in 3 days
4.9 (134 reviews)
6.6
6.6
User Avatar
Dear Sir/Madam, I’ve read your brief and went trough the attachment, and 100% sure that I can do this task perfectly. I have already done lots of similar data analysis tasks for various clients around the globe. If you'd like to see some samples and my reliability, take a look at my freelancer portfolios. I assure you that I will go beyond your expectations, and looking forward to your respond Best regards, Priyal
$250 USD in 1 day
5.0 (198 reviews)
6.7
6.7
User Avatar
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.
$250 USD in 2 days
4.9 (75 reviews)
5.7
5.7
User Avatar
A proposal has not yet been provided
$250 USD in 3 days
5.0 (42 reviews)
5.3
5.3
User Avatar
1. Calculate average (Month) 2. Fill in blanks with the average by way of formula (Tip; your worksheet includes dashes and blanks. Only one of these characters should be used to denote blank entries) 3. A Line chart to be shown for each row/route for the rates timephased by month. Markers will show the highs and lows. Bar Chart can also be shown instead of line chart. 4. Others as required. My bid proposal is at a minimum because am a newbie at freelancer.com and i want to kickstart my account with this project. Thanks.
$250 USD in 1 day
5.0 (7 reviews)
4.7
4.7
User Avatar
Hi, My core expertise is in online data processing, data mining, online research projects. Follows instruction and do pay close attention to details. Looking forward for your reply Thanks
$750 USD in 10 days
5.0 (7 reviews)
3.8
3.8
User Avatar
Dear I am an excel professional having hands on expertise in data analysis I will do your project as per your requirements. best regards humayoon
$397 USD in 3 days
4.7 (12 reviews)
4.1
4.1
User Avatar
Hello, I am Giorgi from Georgia. I would like to work with you. I have a big experience working in MS Office, Web searching and Data Entry. Please text me so we can discuss the details about the task. Thank you! P.S. I have done a sample, but I have some questions
$250 USD in 3 days
4.8 (9 reviews)
3.6
3.6
User Avatar
I am a hardworking individual and I pay attention to detail and pride myself on my work. I have extensive experience in research and data analysis. I also have good knowledge of Microsoft Office. I pride myself in my work and strive to submit my tasks on time and completed with the utmost accuracy. The missing rates will be filled in with the average rate as per your suggestion. The best way to analyse the data would be graphs as this will clearly highlight any abnormalities.
$616 USD in 10 days
4.8 (4 reviews)
3.4
3.4
User Avatar
Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can do the project very well.                          THE BID PROPOSAL I will complete your job under your guidance and supervision with 100% accuracy. Why you should hire me… :- * Because I have better experiences in data entry including copy typing, MS-office ,data compiling, data processing  and of cause other manually typing works. *I am ready to work even with the lowest budget. * I'm always responsible and put my effort to hand-over the final project before the proposed date. *Revisions are always welcome until you are satisfying. *Although I handover you the completed project, if you think it wouldn't impressed you and I scammed you, don’t worry inform me, I would ready to refund your total cost honestly. Besides, I have attached some samples of my past works very similar to what you are seeking, you can check them also from here:- www.freelancer.com/u/rumesh402.html So I would like to invite you, please review my resume and contact me.                                your sincerely,                                        Rumesh
$250 USD in 0 day
4.1 (9 reviews)
2.6
2.6
User Avatar
Hello. I have been doing an Excel course that allows me to present you with the required information. The filling is simple and it would be done pretty quickly. Regarding the rows in which there're several blank spaces, we could discuss as to how to handle the values. As for the data analyzing, I believe some excel functions could help show when spikes appear in any line. (For example, line 97 of flatbed rates. In December the rate went from $777 to $871 and then down again in January to $701)
$277 USD in 3 days
5.0 (3 reviews)
1.8
1.8
User Avatar
Hi, my name is Mike, I’m based in Oxford, UK. Your project description sounds interesting to me and I do have skills & experience that are required to complete it to a high standard. I can show you some examples of my work that are similar to this. Let me know when you’re available to go through it in more details.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi im a experienced excel, spread sheets, and MS-Office worker, i can work fast and with a highlevel of accuracy, my proposal is: take an average of the existing months and also compare with another rates going between the same states and the same months in another transactions, for fill the blank spaces , please do not hesitate to message me i have so much interest in work with you
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
medford, United States
5.0
70
Payment method verified
Member since Apr 12, 2009

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.