Đã hoàn thành

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!

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Toán học, Statistics

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Woodside, United States

ID dự án: #19665215

Được trao cho:

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 trong 1 ngày
(27 Đánh Giá)
4.5

20 freelancer đang chào giá trung bình $92 cho công việc này

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 Thêm

$140 USD trong 7 ngày
(87 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(88 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(73 Nhận xét)
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 trong 1 ngày
(90 Nhận xét)
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 Thêm

$90 USD trong 2 ngày
(2 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(8 Nhận xét)
2.3
Rajdubey1189

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

$155 USD trong 3 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
Vignavel

Hi i think you need some to help you

$155 USD trong 3 ngày
(0 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
$155 USD trong 3 ngày
(0 Nhận xét)
0.0
S1220

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

$35 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$66 USD trong 4 ngày
(0 Nhận xét)
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 Thêm

$77 USD trong 2 ngày
(0 Nhận xét)
0.0
akm17011989

I have excellent work in my life

$155 USD trong 3 ngày
(0 Nhận xét)
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 trong 10 ngày
(0 Nhận xét)
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 Thêm

$77 USD trong 5 ngày
(0 Nhận xét)
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 trong 3 ngày
(0 Nhận xét)
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 Thêm

$166 USD trong 4 ngày
(0 Nhận xét)
0.0