Difference between revisions of "Draft:DLC Spring 2018 Class Projects/Ruth Charles"

From WSU Technology Knowledge Base
Jump to navigation Jump to search
(46 intermediate revisions by 2 users not shown)
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 as a tool for statistical analysis in her class. The instructional guides provided here will show you how to use Excel for the purposes of this class. <br><br>
 
 
==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:mean_function.png|500px]] <br> <br>
 
3. The Function Arguments window below will appear. <br><br>
 
 
 
[[File:mean_function_window.png|500px]] <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>
 
 
 
5. Hit enter, and the mean of your data set will be output into the cell that you picked. <br><br>
 
 
 
[https://www.lynda.com/Excel-tutorials/Mean-its-properties/422098/459838-4.html VIDEO: Excel - Calculating Mean]
 
 
 
===Median===
 
===Mode===
 
  
==Variability==
+
[[File:CAC_PC.png|150px|link=DLC_Spring_2018_Class_Projects/Ruth_Charles/PC|PC Instructions]] [[DLC_Spring_2018_Class_Projects/Ruth_Charles/PC|PC Instructions]]
===Variance===
 
===Standard Deviation===
 
  
===
 
==DLC STARS/Presenter==
 
*Chad Kjorlien ???
 
  
==Resources/Helpful Links==
+
[[File:20110607lion_macbookair.png|150px|link=DLC_Spring_2018_Class_Projects/Ruth_Charles/Mac|Mac Instructions]] [[DLC_Spring_2018_Class_Projects/Ruth_Charles/Mac|Mac Instructions]]
'''text'''
 
  
 
==Other Resources==
 
==Other Resources==

Revision as of 21:08, 17 February 2018

Project Details

Float_Left Professor Charles is using Microsoft Excel as a tool for statistical analysis in her class. The instructional guides provided here will show you how to use Excel for the purposes of this class.

PC Instructions PC Instructions


Mac Instructions Mac Instructions

Other Resources

DLC Support

  • Phone: 507-457-2206
  • Email: dlc@winona.edu
  • 1:1 Support: Krueger Library #105