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

Try Our College Algebra Course. For FREE.

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to many different colleges and universities.*

Begin Free Trial
No credit card required

28 Sophia partners guarantee credit transfer.

281 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 25 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


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