Conditioning, sorting, coloring, and filtering data on Excel
$30-250 USD
Terminado
Publicado hace alrededor de 5 años
$30-250 USD
Pagado a la entrega
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!
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 en 1 día
4,8 (27 comentarios)
4,5
4,5
20 freelancers están ofertando un promedio de $92 USD por este trabajo
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.
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.
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
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
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...
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.
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
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
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.
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