Difference between revisions of "Draft:DLC Spring 2018 Class Projects/Ruth Charles/PC"
| Line 31: | Line 31: | ||
1. Select the cell where you would like the mean value to be output. <br> | 1. Select the cell where you would like the mean value to be output. <br> | ||
2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''AVERAGE'''. <br> <br> | 2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''AVERAGE'''. <br> <br> | ||
| − | [[File:meanStep1.png| | + | [[File:meanStep1.png|800px]] <br> <br> |
3. The Function Arguments window below will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | 3. The Function Arguments window below will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | ||
| − | [[File:meanStep2.png| | + | [[File:meanStep2.png|800px]] <br><br> |
4. Now, click on the first cell of your data set (behind the Function Arguments window); then, while holding down the shift key, click on the final cell of your data set. <br><br> | 4. Now, click on the first cell of your data set (behind the Function Arguments window); then, while holding down the shift key, click on the final cell of your data set. <br><br> | ||
| − | [[File:meanStep3.png| | + | [[File:meanStep3.png|800px]] <br><br> |
5. Hit enter, and the mean of your data set will be output into the cell that you picked. <br><br> | 5. Hit enter, and the mean of your data set will be output into the cell that you picked. <br><br> | ||
| − | [[File:meanStep4.png| | + | [[File:meanStep4.png|800px]] <br><br> |
[https://www.lynda.com/Excel-tutorials/Mean-its-properties/422098/459838-4.html VIDEO: Excel - Calculating Mean] | [https://www.lynda.com/Excel-tutorials/Mean-its-properties/422098/459838-4.html VIDEO: Excel - Calculating Mean] | ||
| Line 49: | Line 49: | ||
1. Select the cell where you would like the median value to be output. <br> | 1. Select the cell where you would like the median value to be output. <br> | ||
2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''MEDIAN'''. <br> <br> | 2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''MEDIAN'''. <br> <br> | ||
| − | [[File:medianStep1.png| | + | [[File:medianStep1.png|800px]] <br> <br> |
3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | 3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | ||
| − | [[File:medianStep2.png| | + | [[File:medianStep2.png|800px]] <br><br> |
4. Now, click behind this window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data. <br><br> | 4. Now, click behind this window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data. <br><br> | ||
| − | [[File:medianStep3.png| | + | [[File:medianStep3.png|800px]] <br><br> |
5. Hit enter, and the median of your data set will be output into the cell that you picked. <br><br> | 5. Hit enter, and the median of your data set will be output into the cell that you picked. <br><br> | ||
| − | [[File:medianStep4.png| | + | [[File:medianStep4.png|800px]] <br><br> |
[https://www.lynda.com/Excel-tutorials/Median/422098/459839-4.html?autoplay=true VIDEO: Excel - Calculating Median] | [https://www.lynda.com/Excel-tutorials/Median/422098/459839-4.html?autoplay=true VIDEO: Excel - Calculating Median] | ||
| Line 69: | Line 69: | ||
2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''MODE.MULT'''. <br> <br> | 2. Navigate to the '''Formulas''' tab in the Menu bar ==> '''More Functions''' ==> '''Statistical''' ==> '''MODE.MULT'''. <br> <br> | ||
| − | [[File:modeStep1.png| | + | [[File:modeStep1.png|800px]] <br> <br> |
3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | 3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step. <br><br> | ||
| − | [[File:modeStep2.png| | + | [[File:modeStep2.png|800px]] <br><br> |
4. Click behind the Function Arguments window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data. <br><br> | 4. Click behind the Function Arguments window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data. <br><br> | ||
| − | [[File:modeStep3.png| | + | [[File:modeStep3.png|800px]] <br><br> |
5. CAUTION: after selecting the cells of your data set, do NOT hit enter and do NOT click OK; instead hit '''ctrl+fn+enter'''. This will output he mode(s) of your data set into the cell(s) that you picked. Cells that do not receive a mode value will receive an "#N/A". <br><br> | 5. CAUTION: after selecting the cells of your data set, do NOT hit enter and do NOT click OK; instead hit '''ctrl+fn+enter'''. This will output he mode(s) of your data set into the cell(s) that you picked. Cells that do not receive a mode value will receive an "#N/A". <br><br> | ||
| − | [[File:modeStep4.png| | + | [[File:modeStep4.png|800px]] <br><br> |
[https://www.lynda.com/Excel-tutorials/Mode/422098/459840-4.html?autoplay=true VIDEO: Excel - Calculating Mode] | [https://www.lynda.com/Excel-tutorials/Mode/422098/459840-4.html?autoplay=true VIDEO: Excel - Calculating Mode] | ||
Revision as of 21:47, 27 December 2017
Project Details (PC Users)
Professor Charles is using Microsoft Excel for statistical analyses in her class. This page is a resource for PC users to help you to understand how to use a variety of Excel's basic statistical functionality.
Hardware/Software
- Microsoft Excel for PC
What We Will Cover
- Selecting cells within an Excel file
- Using built-in functions for central tendency and variability
- Using the Analysis ToolPak Add-in
Cell Selection
- Enter: go to row below the current row
- Shift+Enter: go to row above the current row
- Tab: go to the column right of the current column
- Shift+Tab: go to the column left of the current column
- Control+Click: hold down control while clicking new cells to select as many individual cells as desired.
- Shift+Click: selects all cells between the currently selected cell to the desired cell being clicked. Works across rows and columns.
Central Tendency
Mean
1. Select the cell where you would like the mean value to be output.
2. Navigate to the Formulas tab in the Menu bar ==> More Functions ==> Statistical ==> AVERAGE.
3. The Function Arguments window below will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step.
4. Now, click on the first cell of your data set (behind the Function Arguments window); then, while holding down the shift key, click on the final cell of your data set.
5. Hit enter, and the mean of your data set will be output into the cell that you picked.
VIDEO: Excel - Calculating Mean
Median
1. Select the cell where you would like the median value to be output.
2. Navigate to the Formulas tab in the Menu bar ==> More Functions ==> Statistical ==> MEDIAN.
3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step.
4. Now, click behind this window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data.
5. Hit enter, and the median of your data set will be output into the cell that you picked.
VIDEO: Excel - Calculating Median
Mode
1. Select the cell(s) where you would like the mode value(s) to be output.
Note: It is important to select an excess of output cells, as data sets may have more than one mode value.
Too few output cells will result in receiving only a portion of the mode values for a data set.
2. Navigate to the Formulas tab in the Menu bar ==> More Functions ==> Statistical ==> MODE.MULT.
3. The Function Arguments window will appear, as seen below. Excel will attempt to guess your data set, but this can be manually selected with the next step.
4. Click behind the Function Arguments window on the first cell of your data; then, while holding down the shift key, click on the final cell of your data.
5. CAUTION: after selecting the cells of your data set, do NOT hit enter and do NOT click OK; instead hit ctrl+fn+enter. This will output he mode(s) of your data set into the cell(s) that you picked. Cells that do not receive a mode value will receive an "#N/A".
VIDEO: Excel - Calculating Mode
Variability
Variance
Standard Deviation
Analysis ToolPak
Installation
1. Open Excel. Click on the File tab in the Excel Menu Bar
2. Click on Options in the lower left side of the screen.
3. Select Add-ins from the Excel Options Menu, and click on Analysis ToolPak located in the Inactivated Add-ins section.
4. In the Add-ins menu, check the Analysis ToolPak checkbox, and then hit OK to install the Analysis ToolPak.
Using the ToolPak
1. Open Excel. Click on the Data tab in the Excel Menu Bar
2. Click on Options in the lower left side of the screen.
3. Select Add-ins from the Excel Options Menu, and click on Analysis ToolPak located in the Inactivated Add-ins section.
4. In the Add-ins menu, check the Analysis ToolPak checkbox, and then hit OK to install the Analysis ToolPak.
DLC STARS/Presenter
- Chad Kjorlien ???
Resources/Helpful Links
text
Other Resources
DLC Support
- Phone: 507-457-2206
- Email: dlc@winona.edu
- 1:1 Support: Krueger Library #105