1 / 16

Spreadsheet

Spreadsheet. By Janice Ethapemi. sheet1. I put all my questions from my questionnaire onto the spreadsheet and recorded my answers from each person. I used a validation rule to make it easier to input my results. COUNTIF. I used countif to count how many times a criteria has been selected.

dillon-mcconnell
Download Presentation

Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet By Janice Ethapemi

  2. sheet1 I put all my questions from my questionnaire onto the spreadsheet and recorded my answers from each person. I used a validation rule to make it easier to input my results

  3. COUNTIF I used countif to count how many times a criteria has been selected

  4. Countif s I used countif S to bring multiple data together e.g gender and how often participants feel good

  5. gender I used count if to show how many males and females took part in my questionnaire

  6. age I used countif to calculate how many people were in each age range. There was an inconsistent formula in this calculation. I did the formula again and corrected the error

  7. 5 a day I used countif S to calculate what gender ate their 5 a day or not I used countif to see how many people ate their 5 a day I used a pie chart to show my results I used a pie chart to show my results

  8. Food preferences I used countif S to see what gender preferred a certain food type I used countif to see how many people liked a certain food type I used a pie chart to show my results I used a pie chart to display my results

  9. Sport preferences I used countif S to see what gender preferred a certain sport I used countif to show what see what the most preferred sport was I used a pie chart to show my results I used a pie chart to show my results

  10. Well being I used count if S to show what gender felt about what they needed to have an improved well being I used countif to see what would improve well being. Healthy eating and sport were the same I used a pie chart to show my results I used a pie chart to show my results

  11. Sport_ how often I used count if S to see what gender had did sport the most often I used countif to see how often people did sport I used a pie chart to show my results I used a pie chart to show my results

  12. How long I used countif S to see what gender did sport the longest. I used countif to see how long people did sport for I used a pie chart to show my results I used a pie chart to show my results

  13. Feeling good I used countif S to see what each gender thought they needed to do in order to feel good I used countif to what people needed to do in order to feel good I used a pie chart to show my results I used a pie chart to show my results

  14. Feeling good_ how often I used countif S to see how often each gender felt good I used countif to see how long the participants felt good altogether I used a pie chart to show my results I used a pie chart to show my results

  15. Order of preferences I used a pie chart to show my results I used countif to count what ranking each preference was placed in

  16. challenge I used count if to show how many people like to do the challenge alone and how many like to do the challenge with their friends I used countif S to see what gender preferred to do the challenge alone or with their friends I used a pie chart to display my results I used a pie chart to display my results

More Related