Conditioning, sorting, coloring, and filtering data on Excel

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!

Om arbejdsgiveren:
( 5 bedømmelser ) Woodside, United States

Projekt ID: #19665215

Tildelt til:

Ramez125

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 på 1 dag
(27 bedømmelser)
4.5

20 freelancere byder i gennemsnit \$92 på dette job

polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. This is Excel /VBA result which I 've done This is what i have done i Flere

\$140 USD in 7 dage
(87 bedømmelser)
6.6
lightingdavid

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 carefull Flere

\$155 USD in 3 dage
(88 bedømmelser)
5.8
aimefx

Hi, I am an expert in Excel, Access VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time Flere

\$30 USD på 1 dag
(73 bedømmelser)
5.9
nvchien94

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 på 1 dag
(90 bedømmelser)
5.3
romanapanovich

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 Experienc Flere

\$90 USD in 2 dage
(2 bedømmelser)
3.5
razvancotofana

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 an Flere

\$30 USD på 1 dag
(8 bedømmelser)
2.3
Rajdubey1189

Sir please give me this opportunity, I will not let you down. Thank You.☺

\$155 USD in 3 dage
(0 bedømmelser)
0.0
shobhikaarukia

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 på 1 dag
(0 bedømmelser)
0.0
Vignavel

\$155 USD in 3 dage
(0 bedømmelser)
0.0
DerStatistician

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 Flere

\$30 USD på 1 dag
(0 bedømmelser)
0.0
\$155 USD in 3 dage
(0 bedømmelser)
0.0
S1220

Good work on time with good quality...want to only one chance....

\$35 USD på 1 dag
(0 bedømmelser)
0.0
amarbhardwaj1809

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 exce Flere

\$66 USD in 4 dage
(0 bedømmelser)
0.0
rublejoseph

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 intelligen Flere

\$77 USD in 2 dage
(0 bedømmelser)
0.0
akm17011989

I have excellent work in my life

\$155 USD in 3 dage
(0 bedømmelser)
0.0
rrathod833

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 dage
(0 bedømmelser)
0.0
paytminfotech

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 Flere

\$77 USD in 5 dage
(0 bedømmelser)
0.0
salmann32769

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 dage
(0 bedømmelser)
0.0
Saurabhjns

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 Experie Flere

\$166 USD in 4 dage
(0 bedømmelser)
0.0