Section outline

    • Session 5 Data Analysis with Excel

      In this session you will learn how to compute descriptive statistics, such as Average, Variance, Covariance, minimum and Maximum using two different techniques: Excel’s statistical functions and the Excel add-in Analysis ToolPak. 

      Moreover, you are going to see how to do a regression analysis in Excel.  


    • Students must
      Mark as done


      Watch this video for an introduction to Data Analysis techniques in Excel.



    • Topic 5: Excel Data Analysis Video Presentations Book
      Students must
      Mark as done

      Now you have been introduced to the topic of Data Analysis with Excel, watch these video presentations which demonstrate the application of Statistical Functions, the installation and use of Analysis Toolpak, how to perform and interpret a Regression Analysis, and an example applying the Data Analysis skills used in this section.

    • Students must
      Mark as done

      Topic 5 Review

      Now you have worked through this section, you should be able to: 

      • Use the main statistical functions in Excel

      • Perform an analysis using the Excel add-in Analysis ToolPak

      • Perform a regression analysis