Find Jobs
Hire Freelancers

Conditioning, sorting, coloring, and filtering data on Excel

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
Hello, Joel here. Just need someone to create 6 bar graphs using a data set. That bars graphs should be for specific group comparisons using statewide information only (exclude NYC). Bar graph 1: (ELA )for economically disadvantaged (use the color red)/not economically disadvantaged (use the color blue) using the percentages for tests scores (L (level)1,2,3,4 PCT) Title the graph "Average Statewide ELA Test Scores for Economically Disadvantage and Not Economically Disadvantage Students, Grades 3-8". Bar graph 2: (Math )for economically disadvantaged (use the color red)/not economically disadvantaged (use the color blue) using the percentages for tests scores (L (level)1,2,3,4 PCT) Title the graph "Average Statewide Math Test Scores for Economically Disadvantage and Not Economically Disadvantage Students, Grades 3-8". Bar graph 3: (ELA) should be a comparison between African American (use the color green), Hispanics (use the color yellow), and White (use the color blue) using percentages for tests scores (L1,2,3,4 PCT) and title the bar graph as "Average Statewide ELA Test Scores among African American, Hispanic, and White Students, Grades 3-8". Bar graph 4: (Math) should be a comparison between African American (use the color green), Hispanics (use the color yellow), and White (use the color blue) using percentages for tests scores (L1,2,3,4 PCT) and title the bar graph as "Average Statewide Math Test Scores among African American, Hispanic, and White Students, Grades 3-8". Bar graph 5:The last graph should be a comparison between English language learner (use the color green) and not English language learners (use the color red) again using percentages for tests scores (L1,2,3,4 PCT) and title the bar graph "Average Statewide ELA Test Scores for English Language Learners and Not English Language Learners, Grades 3-8". Bar graph 6:The last graph should be a comparison between English language learner (use the color green) and not English language learners (use the color red) again using percentages for tests scores (L1,2,3,4 PCT) and title the bar graph "Average Statewide Math Test Scores for English Language Learners and Not English Language Learners, Grades 3-8". Lastly, please write a brief description of how you sorted, filtered, or conditioned the data. This task should be fairly simple since the data set is very small. Thank you!
Project ID: 19665215

About the project

20 proposals
Remote project
Active 5 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
Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards
$30 USD in 1 day
4.8 (27 reviews)
4.5
4.5
20 freelancers are bidding on average $92 USD for this job
User Avatar
Hello, Joel. I am Chien. I can create your chart as your description. I see it 's a basic task and I can do it right now. All will be done in around 2 hours. Please contact me and I will start. Thank you.
$60 USD in 1 day
5.0 (148 reviews)
5.9
5.9
User Avatar
Hello. I 'm expert in "Data Entry, Data Processing, Excel, Mathematics, Statistics" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$155 USD in 3 days
4.8 (91 reviews)
5.9
5.9
User Avatar
Hello Joel, I read you project description and I also opened the data file. I can give you the output as requested (including the explanation on how was done) in a couple of hours. Please feel free to contact me for any additional information. BR, Razvan
$30 USD in 1 day
5.0 (19 reviews)
5.8
5.8
User Avatar
First of all I strongly recommend to use Google sheet instead of Excel But can do in Excel of course I'll need Your sample Excel file with data Also I'll need some clarifications because Relevant Skills and Experience I'm not economist and some Your teinology is unclear for me After we will finish I'll provide explanations as well
$90 USD in 2 days
5.0 (2 reviews)
3.5
3.5
User Avatar
Hello sir i will complete your work as soon as possible I am also free please hire me for this job. Thank you Relevant Skills and Experience I have 2 year experience in data entry etc...
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir I will do complete your conditions formating in5 days with your conditions. Relevant Skills and Experience I have experience advance excel like conditional formatting, vlookup, H,lookup , pivot table and word , internet search.
$77 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I want to prove my self for your given work if you give me a chance, i promise you will be very happy.........Thank you
$30 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent work in my life
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Credentials : - I head the center of excellence for a 200 million dollar data science , Machine Learning and AI services provider , leading its efforts in predictive analytics, computer vision, artificial intelligence , machine learning, internet of things , Natural language processing, image and video analytics. - Have been recognized as one of the TOP 40 DATA SCIENTISTS for the work in computer vision and machine learning - 9+ years work experience playing varied roles from data scientist to analytics consultant to analytics delivery leader to head of innovation and development to analytics strategist to fortune 500 clients - Patent pending and industry leading award winning frameworks in customer analytics, customer support using machine learning and AI, social media analytics less - Analytics, data science mentor - designed curriculum for 3 of the leading institutes in India offering advanced programs in data science. On the leadership panel and executive coach with Board Infinity (an enterprise that connects talent to industry in analytics), multiple workshops, boot camps to train on advanced data science concepts - 500+ candidates trained
$77 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi.. I am a BCA student so I have enough knowledge and skill to do your job with your requirements. Kindly take me to do this job.. Thank you Relevant Skills and Experience I have good knowledge of ms word and Ms excel
$66 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good work on time with good quality...want to only one chance....
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir please give me this opportunity, I will not let you down. Thank You.☺
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm doing my major in statistics. I've completed my data processing course & achieved an A in theory and A+ in lab & currently working as a teaching assistant of the course. I've completed an academic research paper in a collaboration with my professor where I've to create different bars, histogram etc. Besides I've experienced in professional work. So mentioned 6 graphs won’t be a problem for me. I'm very good in SPSS & SAS. I can even use this software if you want. As I'm new here & doing it mostly for good review, dedicated work is guaranteed.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i think you need some to help you
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I've completed my major in Economics and I'm good with handling data. Also I'm pursuing Actuarial Science. I'll be best for this job.
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Having expertise in data analysis... currently working as a business analyst in one of the world’s largest polyester manufacturing company I.e Polyplex . Data analysis is my key expertise. Relevant Skills and Experience Key expertise in data analysis, financial feasibility
$166 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Woodside, United States
5.0
5
Payment method verified
Member since Dec 5, 2016

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.