Menu
Histogram and Bar Graph Lab
Directions
Histogram and Bar Graph Lab Spread Sheet Download
** When you open the document, go to "file" -> Save as google sheets
** When you open the document, go to "file" -> Save as google sheets
Creating a Histogram in Google Sheets
|
|
Histogram and Bar Graph Lab Spread Sheet Download
Directions: Follow each step to be able to complete the Histogram Lab. Work with a partner if you like or work independently. If you work with a partner, you each need to turn in your own individual work. ALL of the pages should have either a histogram or a bar graph on it to recieve full credit.
Histogram
Download the Spread Sheet for the Histogram and bar Graph Lab
Start on sheet one
Highlight all of the data (so that it all has a "blue highlight")
Click into the first square (cell) with data
Press "ctrl" "shift" "down arrow" all at the same time
Go to "insert"
Select "chart"
Under "chart type" choose "Histogram Chart"
Choose "customize"
Open the "chart & axis titles" drop down
Under "Title Text" Name the Histogram (related to the prompt)
Click “chart title” and change it to “Horizontal axis title”
This is the x-axis. Label the axis appropriately
Click “Horizontal axis title” and change it to “vertical axis title”
This is the y-axis. Label the axis appropriately
Finding Standard Deviation
Click in an open cell
Type in “=stdev”
Highlight all the data and press enter
***Try Sheet Two on your own***
Bar Graph
Select sheet Three
***Try your own on sheet four***
If you complete before class ends open a NEW google sheet (blank, fresh sheet) and begin entering your numerical data from your survey in one sheet. Create a new sheet and enter your categorical data. (**your data needs to be in a list**). Then create the histogram and a bar graph for your survey project.
Directions: Follow each step to be able to complete the Histogram Lab. Work with a partner if you like or work independently. If you work with a partner, you each need to turn in your own individual work. ALL of the pages should have either a histogram or a bar graph on it to recieve full credit.
Histogram
Download the Spread Sheet for the Histogram and bar Graph Lab
Start on sheet one
Highlight all of the data (so that it all has a "blue highlight")
Click into the first square (cell) with data
Press "ctrl" "shift" "down arrow" all at the same time
Go to "insert"
Select "chart"
Under "chart type" choose "Histogram Chart"
Choose "customize"
Open the "chart & axis titles" drop down
Under "Title Text" Name the Histogram (related to the prompt)
Click “chart title” and change it to “Horizontal axis title”
This is the x-axis. Label the axis appropriately
Click “Horizontal axis title” and change it to “vertical axis title”
This is the y-axis. Label the axis appropriately
Finding Standard Deviation
Click in an open cell
Type in “=stdev”
Highlight all the data and press enter
***Try Sheet Two on your own***
Bar Graph
Select sheet Three
- Highlight all the data (so that it all has a “blue” highlight)
- Click into the first square with data
- Press “ctrl” “shift” “down arrow” at the same time
- Go to “Insert”
- Select “chart
- Choose “customize”
- Open the “chart & axis titles” drop down
- Under “Title Text” Name the histogram (related to the prompt)
- Click “chart title” and change it to “Horizontal axis title”
- This is the x-axis. Label the axis appropriately
- Click “Horizontal axis title” and change it to “vertical axis title”
- This is the y-axis. Label the axis appropriately
***Try your own on sheet four***
If you complete before class ends open a NEW google sheet (blank, fresh sheet) and begin entering your numerical data from your survey in one sheet. Create a new sheet and enter your categorical data. (**your data needs to be in a list**). Then create the histogram and a bar graph for your survey project.