Team Activities

    Share with your partner the information and progress you have made thus far.

    Together, use Excel to organize your data. Find the mean, median, mode, and range. Use the Chart Wizard to graph your data in an appropriate type of graph (i.e. pie graph, bar graph, etc.) Make sure you title your axes and your graph!

    The links below can help you work with Excel.

    Excel Formulas Creating Graphs & Charts in Excel
    AutoSum Formulas Using Formulas

     

    Use your data and graph to make at least three observations and conclusions about your topic. Look for intriguing patterns and other notable characteristics of the dataset. What conclusions can you draw from your graph? What decisions and ideas can be justified by your data?

    Think about your presentation: How will use your data to support your ideas and persuade your audience? What side will you and your partner be focusing on?

    Work together to create a PowerPoint "news story", which will combine the information you found, your data analysis and your findings.

    Include the following: The mean, median, mode, range, and graph of your data set.

    An explanation of at least three observations/conclusions that you found and how your data supports them.

    Address how your data could be interpreted differenty? Could you use the same dataset to support a different view?

    Extra websites to help you!

    Statistics terms and definitions
    Mean, median, mode and range
    Create a Graph

    Conclusion