Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Subscribe
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Subscribe
    Home Latest News

      The Statistics Do Not Lie

      Written by

      Scot Petersen
      Published February 4, 2002
      Share
      Facebook
      Twitter
      Linkedin

        eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

        Fellow columnist Peter Coffee commiserated with us recently on how hard it is to form any opinion these days that doesnt involve Microsoft. Hes right. Whether we are taking the company to task or, less often, praising it, the fact is that Microsofts reach is so extensive that its difficult to find substantive IT issues that dont involve Redmond directly or indirectly.

        In truth, its difficult to avoid crossing paths with Microsoft even outside the office. Turn on the TV, theres MSNBC; play computer games with your kids, theres Windows. Go to your night class, as I do, and run smack into another Microsoft predicament.

        Im taking quantitative analysis, aka statistics, as part of a business program. The required textbook bundles Minitab Statistical Software, a spreadsheet developed in the 1970s at Penn State University that grew into an international business. But my professor said, “Dont use Minitab, use Excel, because its the program you will most likely encounter in the workplace, and you should become used to working with it.”

        Heres the punch line: While having five-point summaries, box plots and histograms demonstrated for us, we realized—as did the professor (much to his chagrin)—that Minitab blows away Excel when it comes to statistical analysis.

        First, Excel by default doesnt feature statistical functions. You have to use the Analysis ToolPak Add-In. Once thats installed, you have to jump through hoops to get much of the information, while Minitab includes a menu item for each function we needed. Finally, we learned, Excel doesnt do histograms correctly: Microsofts histograms look more like bar graphs, with gaps between the data points. By the end of class, we got the professor to allow us to use Minitab for our project. “You can use either one,” he said.

        Excel is certainly more robust than Minitab, which has a 5,000-cell data limit, and, of course, theres Microsoft Offices famous seamless integration. But the question is, Why is the leading spreadsheet on the market so lacking in these important functions? Answer: Because it can get away with it. Its not the first time Microsoft shortchanged its customers, and it wont be the last. And in a way, this negligence is a blessing, which allows a specialized niche product to survive, if not thrive.

        In search of non-Microsoft topics? Write to me at [email protected].

        Scot Petersen
        Scot Petersen
        Scot Petersen is a technology analyst at Ziff Brothers Investments, a private investment firm. Prior to joining Ziff Brothers, Scot was the editorial director, Business Applications & Architecture, at TechTarget. Before that, he was the director, Editorial Operations, at Ziff Davis Enterprise, While at Ziff Davis Media, he was a writer and editor at eWEEK.

        Get the Free Newsletter!

        Subscribe to Daily Tech Insider for top news, trends & analysis

        Get the Free Newsletter!

        Subscribe to Daily Tech Insider for top news, trends & analysis

        MOST POPULAR ARTICLES

        Artificial Intelligence

        9 Best AI 3D Generators You Need...

        Sam Rinko - June 25, 2024 0
        AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
        Read more
        Cloud

        RingCentral Expands Its Collaboration Platform

        Zeus Kerravala - November 22, 2023 0
        RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
        Read more
        Artificial Intelligence

        8 Best AI Data Analytics Software &...

        Aminu Abdullahi - January 18, 2024 0
        Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
        Read more
        Latest News

        Zeus Kerravala on Networking: Multicloud, 5G, and...

        James Maguire - December 16, 2022 0
        I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
        Read more
        Video

        Datadog President Amit Agarwal on Trends in...

        James Maguire - November 11, 2022 0
        I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
        Read more
        Logo

        eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

        Facebook
        Linkedin
        RSS
        Twitter
        Youtube

        Advertisers

        Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

        Advertise with Us

        Menu

        • About eWeek
        • Subscribe to our Newsletter
        • Latest News

        Our Brands

        • Privacy Policy
        • Terms
        • About
        • Contact
        • Advertise
        • Sitemap
        • California – Do Not Sell My Information

        Property of TechnologyAdvice.
        © 2024 TechnologyAdvice. All Rights Reserved

        Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

        ×