Note: It has not yet been possible to test if this solution works for Office Online and versions of Excel prior to 2003.ĭETERMINING THE MEAN WITH ITS ASSOCIATED 95% CONFIDENCE LEVEL However there is an alternative means of performing the core Descriptive Statistics and Regression Analyses (with associated error treatment) which can be performed on almost any version of Excel.
Regression - Used to determine the line of best fit (for a set of x and data), including evaluating the associated 95% Confidence Limits for the fitted parameters.Ī simplistic solution is to find a computer running a version of Excel that does have the Analysis ToolPak installed.Descriptive Statistics - Used to determine the Mean and 95% Confidence Level for a set of readings.Having a version/copy of Excel that is missing the Analysis ToolPak is potentially problematic in that it contains two Data Analysis Tools that will commonly be used for the analysis of data from practicals performed in the Level 4 Lab. You are using a version of Excel which does support the Analysis ToolPak however this option was not selected during the original installation - This can be fixed by updating the installation, although this process often requires you to have the original Office installation disk.
#HOW TO ADD ANALYSIS TOOLPAK IN EXCEL 2013 FOR MAC FOR MAC#
0 kommentar(er)
