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

  • Status: Closed
  • Prêmio: $50
  • Inscrições Recebidas: 10
  • Vencedor: audreysur

Síntese do concurso

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.

Habilidades Recomendadas

Winner
Concurso em Destaque
Lance um Concurso Como Este

Feedback do Empregador

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

Foto do perfil ghanim2311, Saudi Arabia.

Principais inscrições deste concurso

Ver Mais Inscrições

Painel de Comentários

  • EmadOwaida
    EmadOwaida
    • 1 semana atrás

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

    • 1 semana atrás
  • RicardoZL79
    RicardoZL79
    • 1 semana atrás

    Thanks for your rating!

    • 1 semana atrás
  • ghanim2311
    Proprietário do Concurso
    • 1 semana atrás

    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 semana atrás
    1. EmadOwaida
      EmadOwaida
      • 1 semana atrás

      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 semana atrás
  • Arshad1978
    Arshad1978
    • 1 semana atrás

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

    • 1 semana atrás
  • Ben479
    Ben479
    • 1 semana atrás

    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 semana atrás
  • AdeenaLiaqat
    AdeenaLiaqat
    • 1 semana atrás

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

    • 1 semana atrás
    1. AdeenaLiaqat
      AdeenaLiaqat
      • 1 semana atrás

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

      • 1 semana atrás
  • ghanim2311
    Proprietário do Concurso
    • 1 semana atrás

    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 semana atrás
    Ver mais 2 mensagens Processando...
    1. EmadOwaida
      EmadOwaida
      • 1 semana atrás

      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 semana atrás
    2. EmadOwaida
      EmadOwaida
      • 1 semana atrás

      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 semana atrás
  • Arshad1978
    Arshad1978
    • 1 semana atrás

    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 semana atrás
  • ghanim2311
    Proprietário do Concurso
    • 1 semana atrás

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

    • 1 semana atrás
  • ghanim2311
    Proprietário do Concurso
    • 1 semana atrás

    I need a real example using my data

    • 1 semana atrás

Mostrar mais comentários

Como começar com concursos

  • Publique seu concurso

    Publique seu Concurso Rápido e fácil

  • Receba muitas inscrições

    Obtenha Toneladas de Inscrições De todo o mundo

  • Premie a melhor inscrição

    Premie a melhor inscrição Baixe os arquivos, é fácil!

Poste um Concurso ou Junte-se a nós Hoje!