Excel Statistical Analysis & Pie Chart Visualization, histograms, comparisons. eack worksheet collored like a heatmap - 09/05/2024 10:10 EDT

Tình trạng: Closed
Giải thưởng: $50
Các bài thi đã nhận: 10
Người chiến thắng: audreysur

Winner

Tóm tắt cuộc thi

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations.

To get specific, the scope of work involves:

- Converting my Excel sheet data into meaningful insights via statistical analysis
- there is 12 workbook, represent date palm trees five varites.
- each tree has branches which is recorded in the cell.
-some trees did not produce
- need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN.
- NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK
- BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AND THE TOTAL OF ALL

NEED TO PRINT EACH WORKBOOK AS IMAGE IN A3 AFTER COLORING CELLS
- Applying frequency distribution in order to derive significant trends from the data
- Creating pie charts that effectively visualize the results and insights gathered from the analysis.

The ideal candidate would have experience in advanced Excel functions, statistical analysis, and data visualization. Familiarity with frequency distribution and the ability to convert these results into visually attractive and easy-to-understand pie charts is paramount.

Please include examples of similar projects you have worked on in your bid. I am looking forward to your proposals.

Các kĩ năng yêu cầu

Winner

Đăng cuộc thi giống như cuộc thi này

Phản hồi của người thuê

“Audrey has done a very excellent data analysis work for me. Audrey understand the scope in a very short time. it was a contest that she won, the difference between her proposal and others is huge. i really appreciated the quality of the work. creating a scenario models on excel that made it easy for every one to visualize results and make decision. i will work again with her , every time i have a similar task. ”

ghanim2311, Saudi Arabia.

Những bài dự thi tốt nhất dự cuộc thi này

rupinderhanda India

0
RicardoZL79 Mexico

0
Arshad1978 Pakistan

0
Arshad1978 Pakistan

1
karim0725 Bangladesh

0
EmadOwaida Saudi Arabia

0
rupinderhanda India

0

Xem thêm bài dự thi

Bảng thông báo công khai

EmadOwaida
- cách đây 1 tuần
You missed my Entry #17 (6 Screenshots with explanation on each)
I just Hope if you take a look :(
- cách đây 1 tuần
RicardoZL79
- cách đây 1 tuần
Thanks for your rating!
- cách đây 1 tuần
Chủ cuộc thi
- cách đây 1 tuần
for colors , i suggest empty cells or 0 be red, 1,2,3, lighter degree of red. trees that have 4 branches or more shall be degree of green, for example the bigger the number of branches the darker the green, so 4 branches is very light green, 5 branches little darker than 4, 6 branches little darker than 5. ten branches and more are very dark green.
- cách đây 1 tuần
1. EmadOwaida
  - cách đây 1 tuần
  Hold on #ContestHolder , Your First File (that will allow you to update any new Data is Ready) , but I am at the moment finalizing the second file that will include all of your related Calculation , Trees types Analysis / Counting / and Charts .
  
  within 1 hours I will finish and submit my Entry inshallah
  - cách đây 1 tuần
Arshad1978
- cách đây 1 tuần
Hello Ghanim! Please view my latest #13 byArshad A.
- cách đây 1 tuần
Ben479
- cách đây 1 tuần
Dear Client, I just need clarification on what the columns within each sheet represent. I'm guessing that each column within a given sheet represents a location at which trees of the sheet's type were sampled, and the individual numbers going down the column represent the number of branches on each of the different trees sampled at that location? So, for example, on sheet "1-ajwa", what do the column headings "1" to "35" represent? Thank you!!
- cách đây 1 tuần
AdeenaLiaqat
- cách đây 1 tuần
Hello there! I will be posting an entry soon. Thank you :)
- cách đây 1 tuần
1. AdeenaLiaqat
  - cách đây 1 tuần
  #7 - I have posted my entry. Please have a look!^^
  - cách đây 1 tuần
Chủ cuộc thi
- cách đây 1 tuần
please note that color scheme shall be in good presentation for example if you chose 0 and empty cells to be red the no 2 will be a lighter red in degree, 3 will be lighter...and so on.
- cách đây 1 tuần
Xem thêm 2 tin nhắn nữa
1. EmadOwaida
  - cách đây 1 tuần
  And in Parallel I will simply built for you my Magical tool that will read (Automatically) from fist file and analyze your original file in full with total kilogram/ each Palm tree type , and with small dashboard including Pei chart you required .
  but to do this amazing insightful tool/chart , I need you to finalize the following :
  A- Changing sheets name later will cause my tool stuck and corrected , so please provide me with your final 12 Sheets names , that you will never change again later.
  B- I see that ; most of your sheets having maximum 40 Column (it is critical for my solution) can you confirm that Max number of column will be 40 ?!
  - cách đây 1 tuần
2. EmadOwaida
  - cách đây 1 tuần
  C- number of rows not a problem , you can add whatever you want.
  D- And Last , I assume that current Empty cell should be neglected (in Counting and in Averaging Analysis ) unless you added some new tree result (0-10). ! Right ?
  E- I think; mistakenly you added some letters instead of number of fruity branches (for Example, in "1-ajwa" sheet cell#Q2 & S2) , I believe , there should be numbers instead of letters.
  
  Appreciate, if you please answer my above question ASAP
  - cách đây 1 tuần
Arshad1978
- cách đây 1 tuần
Hi Client! Before starting working over on this project, I need to be more precise. Lets Discuss "1-ajwa" tab. The Fisrt Row is Representing Numbers from 1 to 40, Is this Representing Column Number & beneath every column number it is representing branches number?
- cách đây 1 tuần
Chủ cuộc thi
- cách đây 1 tuần
please note that raw no one is raw number it is not branches to do not add it to the total
- cách đây 1 tuần
Chủ cuộc thi
- cách đây 1 tuần
I need a real example using my data
- cách đây 1 tuần