Forum Discussion

caitlinab's avatar
caitlinab
Copper Contributor
Feb 01, 2024

Excel Data Analysis Toolpak

Can the data analysis toolpak run t-tests with non-integer degrees of freedom? Is there a setting I could use to enable that? It seems to round to a whole number whenever I use it for analysis, and that's useful sometimes but I'd like to know if I can change this with a setting.

BI & Data Analysis
excel
Excel on Mac
Formulas and Functions
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    Excel's Data Analysis Toolpak does not support non-integer degrees of freedom and rounds to whole numbers.
    Manual calculations or using Excel’s statistical functions (like T.DIST.2T) can be a workaround.
    Consider using advanced statistical software or programming languages like R or Python for handling non-integer degrees of freedom.

Resources