Завершено

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!

Квалификация: Ввод данных, Обработка данных, Excel, Математика, Статистика

Показать больше transfer data excel multiple sheet access table, data excel sheet macro, transfer data excel word, when might you want to sort data in an excel spreadsheet when would you want to filter data, sorting in excel example, sort by color in excel, sort by conditional formatting google sheets, sort by conditional formatting color, conditional formatting after filter, how to filter by color in excel, excel filter by color not working, fetch data excel files, export jsp data excel javascript, perl script retrieve data excel, export data excel database java, convert pdf data excel sheet, filtering jtable data excel, filtering data excel, excel vba filtering data, sorting and filtering in excel 2013

О работодателе:
( 4 отзыв(-а, -ов) ) Woodside, United States

ID проекта: #19665215

Поручен:

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 за 1 день
(26 отзывов(-а))
4.5

21 фрилансеров(-а) в среднем готовы выполнить эту работу за $89

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 Больше

$140 USD за 7 дней(-я)
(83 отзывов(-а))
6.6
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 Больше

$30 USD за 1 день
(69 отзывов(-а))
5.8
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 Больше

$155 USD за 3 дней(-я)
(64 отзывов(-а))
5.7
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 за 1 день
(77 отзывов(-а))
5.1
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 Больше

$90 USD за 2 дней(-я)
(2 отзывов(-а))
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 Больше

$30 USD за 1 день
(3 отзывов(-а))
1.6
parthog47

I have good experience in bulk data handling, processing and filtering using excel. This should prove useful in your task.

$30 USD за 1 день
(1 отзыв)
0.7
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 за 1 день
(0 отзывов(-а))
0.0
Vignavel

Hi i think you need some to help you

$155 USD за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$30 USD за 1 день
(0 отзывов(-а))
0.0
Rajdubey1189

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

$155 USD за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$66 USD за 4 дней(-я)
(0 отзывов(-а))
0.0
S1220

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

$35 USD за 1 день
(0 отзывов(-а))
0.0
$155 USD за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$77 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
akm17011989

I have excellent work in my life

$155 USD за 3 дней(-я)
(0 отзывов(-а))
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 за 10 дней(-я)
(0 отзывов(-а))
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 Больше

$77 USD за 5 дней(-я)
(0 отзывов(-а))
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 за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$166 USD за 4 дней(-я)
(0 отзывов(-а))
0.0