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

  • Status: Closed
  • Prize: $50
  • Entries Received: 10
  • Winner: audreysur

Contest Brief

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.

Recommended Skills

Winner
Featured Contest
Post a Contest Like This

Employer Feedback

“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. ”

Profile image ghanim2311, Saudi Arabia.

Top entries from this contest

View More Entries

Public Clarification Board

  • EmadOwaida
    EmadOwaida
    • 1 week ago

    You missed my Entry #17 (6 Screenshots with explanation on each)
    I just Hope if you take a look :(

    • 1 week ago
  • RicardoZL79
    RicardoZL79
    • 1 week ago

    Thanks for your rating!

    • 1 week ago
  • ghanim2311
    Contest Holder
    • 1 week ago

    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.

    • 1 week ago
    1. EmadOwaida
      EmadOwaida
      • 1 week ago

      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

      • 1 week ago
  • Arshad1978
    Arshad1978
    • 1 week ago

    Hello Ghanim! Please view my latest #13 byArshad A.

    • 1 week ago
  • Ben479
    Ben479
    • 1 week ago

    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!!

    • 1 week ago
  • AdeenaLiaqat
    AdeenaLiaqat
    • 1 week ago

    Hello there! I will be posting an entry soon. Thank you :)

    • 1 week ago
    1. AdeenaLiaqat
      AdeenaLiaqat
      • 1 week ago

      #7 - I have posted my entry. Please have a look!^^

      • 1 week ago
  • ghanim2311
    Contest Holder
    • 1 week ago

    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.

    • 1 week ago
    View 2 more messages Processing...
    1. EmadOwaida
      EmadOwaida
      • 1 week ago

      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 ?!

      • 1 week ago
    2. EmadOwaida
      EmadOwaida
      • 1 week ago

      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

      • 1 week ago
  • Arshad1978
    Arshad1978
    • 1 week ago

    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?

    • 1 week ago
  • ghanim2311
    Contest Holder
    • 1 week ago

    please note that raw no one is raw number it is not branches to do not add it to the total

    • 1 week ago
  • ghanim2311
    Contest Holder
    • 1 week ago

    I need a real example using my data

    • 1 week ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!