Excel Basics

Excel Basics

Author: Miguel Ramirez

Tutorials covering basic Excel concepts necessary for the Activity: Measuring Simulation of Nano-Circuits Dimensions using Geometry Software, and Data graphing and Analysis using MS-Excel

- Statistical Functions

- Graphics

- p-value, Hypothesis Testing, T-Distribution

- Linear Regression

- Non-Linear Correlations, Tend Lines

See More
Introduction to Psychology

Analyze this:
Our Intro to Psych Course is only $329.

Sophia college courses cost up to 80% less than traditional courses*. Start a free trial now.


How to calculate Standard Deviation, Mean, Variance Statistics, Excel by statisticsfun

Source: statisticsfun at YouTube: https://www.youtube.com/watch?v=efdRmGqCYBk

Excel 2013 Tutorial - Using Statistical Functions - Learn Excel Training Tutorial by Simon Sez IT

Source: Simon Sez IT at YouTube: https://www.youtube.com/watch?v=eXC11rVOamQ

Statistical Analysis Functions with Excel by Ralph Phillips

Source: Ralph Phillips at YouTube: https://www.youtube.com/watch?v=k7hh5X7-cFw

How to make a line graph in Excel (Scientific data) by Igines

Source: Igines at YouTube: https://www.youtube.com/watch?v=Xn7Sd5Uu42A

Excel 2010 Tutorial 13 - Line Chart by SchoolFreeware

Source: SchoolFreeware at YouTube: https://www.youtube.com/watch?v=ZzIEUeC4Vjk

Excel 2010 Scatter Diagram with Trendline by ijmcgrory

Source: ijmcgrory at YouTube: https://www.youtube.com/watch?v=iP_Ziu7RO4I

Scatterplot Graph with trendline and R^2 value on Excel 2011 by Chris Goff

Source: Chris Goff at YouTube: https://www.youtube.com/watch?v=OEc7niSuZnw

t-test in Microsoft Excel by Jim Grange

Source: Jim Grange at YouTube: https://www.youtube.com/watch?v=BlS11D2VL_U

Student t Test by Robert Winters

Source: Robert Winters at YouTube: https://www.youtube.com/watch?v=JlfLnx8sh-o

How to Calculate t test Using Excel for Unrelated Groups (Independent groups) by statisticsfun

Source: statisticsfun at YouTube: https://www.youtube.com/watch?v=38uuiUNLu0Q

How To... Perform Simple Linear Regression in Excel 2010 by Eugene O'Loughlin

Source: Eugene O'Loughlin at YouTube: https://www.youtube.com/watch?v=MkNubKibM0A

Simple Regression Basics by ProfTDub

Source: ProfTDub at YouTube: https://www.youtube.com/watch?v=8JOJ_7R_OWY

Log graphing in Excel by UrbanScienceVideos

Source: UrbanScienceVideos at YouTube: https://www.youtube.com/watch?v=_S75X4FsC0A

Excel Graphs of Logarithmic Functions by ccachemistryclub

Source: ccachemistryclub at YouTube: https://www.youtube.com/watch?v=gTp68eXSfGk