I do not have the descriptive statistics option

Courtney Long 0 Reputation points
2026-09-18T19:22:27.94+00:00

I am completing a school assignment. There is no descriptive statics options. There is no where to add it in.

Microsoft 365 and Office | Excel | For education | MacOS
0 comments

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 437.7K Reputation points
    2026-09-18T19:52:55.9033333+00:00

    User's image

    If the Data Analysis tool isn't there click the Analysis Tools button in that same group then check the box for Analysis ToolPak, OK.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-09-18T19:22:39.14+00:00

    Descriptive Statistics is part of the Analysis ToolPak. If that option is missing, the ToolPak is not available or not enabled.

    For Excel for Mac:

    1. Open Excel.
    2. Go to Tools > Excel Add-ins.
    3. Select Analysis ToolPak.
    4. Select OK.
    5. Then go to the Data tab and look for Data Analysis.
    6. Inside Data Analysis, select Descriptive Statistics.

    If Data Analysis still does not appear:

    • Make sure Analysis ToolPak is checked in Tools > Excel Add-ins.
    • If prompted to install it, select Yes.

    Important limitation:

    • In Excel for the web, the Analysis ToolPak is not available.
    • On devices that only use the web version, such as a Chromebook, the ToolPak and its Descriptive Statistics option are unavailable.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.