Learning to use excel
  • Blog
  • Contact
  • Office 365 Tips
  • Archive

Index-Match - alternative to vlookup

10/16/2017

0 Comments

 
Index.match is an alternative to the traditional vlookup or hlookup. The formula differs in that it can return values in cells both vertically and horizontally as well not needing to be based on the left-most column of a spreadsheet like vlookup. Index-Match works by having Excel scan a table to find a specific cell based on a lookup value that you designate. In one of my examples I use the formula to select a student and a standard and Excel returns the score of that particular standard. 
0 Comments

How to create a Normal Distribution curve (bell curve) in Excel

10/10/2017

0 Comments

 
Normal Distribution is an important statistical measure because it allows you to easily work with large amounts of variables and model the observed frequency of events. In the example I use over 2000 ACT scores are analyzed to show that the majority of test takers fall within the standard normal distribution of scores. To put it in easy to understand terms, 68% of testers fall within the average range. In the video I show you how to calculate the data needed to created a normal distribution graph and explain the concept of standard deviation.
0 Comments

    Jason Sloan

    Instructional Technology Coach at Oakland High School and general Tech Geek

    Picture
    Picture

    Archives

    January 2018
    October 2017
    September 2017
    November 2016
    September 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016

    RSS Feed

      Subscribe

    Subscribe to Blog
    Download Excel File
    Tweets by @OHSTechnology
Powered by Create your own unique website with customizable templates.
  • Blog
  • Contact
  • Office 365 Tips
  • Archive