|
|
| Line 1: |
Line 1: |
| − | | + | ==Project Details== |
| − | | |
| − | ==Project Details (PC Users)== | |
| | {{TOC_Float_Right}} | | {{TOC_Float_Right}} |
| | [[File:Excel.png|50px|Float_Left]] | | [[File:Excel.png|50px|Float_Left]] |
| | 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. | | 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. |
| | + | ==PC== |
| | + | [[DLC_Spring_2018_Class_Projects/Ruth_Charles/PC]] |
| | + | ==Mac== |
| | | | |
| − | ==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.
| |
| − |
| |
| − | [[File:CellSelectionUniv.JPG|400px|Float]]
| |
| − |
| |
| − | ==Central Tendency==
| |
| − | ===Mean===
| |
| − | 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>
| |
| − | [[File:meanStep1.png|1000px]] <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|1000px]] <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|1000px]] <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|1000px]] <br><br>
| |
| − |
| |
| − | [https://www.lynda.com/Excel-tutorials/Mean-its-properties/422098/459838-4.html VIDEO: Excel - Calculating Mean]
| |
| − |
| |
| − | ===Median===
| |
| − | 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>
| |
| − | [[File:medianStep1.png|1000px]] <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|1000px]] <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|1000px]] <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|1000px]] <br><br>
| |
| − |
| |
| − | [https://www.lynda.com/Excel-tutorials/Median/422098/459839-4.html?autoplay=true VIDEO: Excel - Calculating Median]
| |
| − |
| |
| − | ===Mode===
| |
| − | 1. Select the cell(s) where you would like the mode value(s) to be output. <br>
| |
| − | Note: It is important to select an excess of output cells, as data sets may have more than one mode value.<br>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'''. <br> <br>
| |
| − | [[File:modeStep1.png|1000px]] <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|1000px]] <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|1000px]] <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|1000px]] <br><br>
| |
| − |
| |
| − | [https://www.lynda.com/Excel-tutorials/Mode/422098/459840-4.html?autoplay=true VIDEO: Excel - Calculating Mode]
| |
| − |
| |
| − | ==Variability==
| |
| − | ===Variance===
| |
| − | ===Standard Deviation===
| |
| | | | |
| − | ===
| |
| | ==DLC STARS/Presenter== | | ==DLC STARS/Presenter== |
| | *Chad Kjorlien ??? | | *Chad Kjorlien ??? |
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.