Lesson Abstact

Excel has the ability to formulate equations and create graphs to help users evaluate the data they want to use. The lesson will be about how to apply those functions to analyze the input value. Using these data to have many different graphs. Those lesson will be more specific for Stat students, who are looking for how to deal with Excel functions.

Lesson Objectives/Outcomes

Evaluate data using formulas for a desired output Create graphs using given data to have a visual representation

Materials

Excel will be required for this lesson

Overview

Using and understanding Microsoft Excel for Statistics students

Lesson Steps/Components [as many as needed]

SUM in Excel

How to Make a Totaling Column Formula in Excel

Histogram

Creating a Histogram in Microsoft Excel

Pie Chart

Creating a Pie Chart

Cluster column and Stack Column in Excel

Clustered Stacked Bar Chart In Excel