Close
  • Latest News
  • 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
Logo
  • Latest News
  • 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
    Home Latest News

      The Statistics Do Not Lie

      By
      Scot Petersen
      -
      February 4, 2002
      Share
      Facebook
      Twitter
      Linkedin

        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 scot_petersen@ziffdavis.com.

        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. No investment advice is offered in his blog. All duties are disclaimed. Scot works for a private investment firm, which may at any time invest in companies whose products are discussed in this blog, and no disclosure of securities transactions will be made.

        MOST POPULAR ARTICLES

        Big Data and Analytics

        Alteryx’s Suresh Vittal on the Democratization of...

        James Maguire - May 31, 2022 0
        I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
        Read more
        Cybersecurity

        Visa’s Michael Jabbara on Cybersecurity and Digital...

        James Maguire - May 17, 2022 0
        I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
        Read more
        Applications

        Cisco’s Thimaya Subaiya on Customer Experience in...

        James Maguire - May 10, 2022 0
        I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
        Read more
        Big Data and Analytics

        GoodData CEO Roman Stanek on Business Intelligence...

        James Maguire - May 4, 2022 0
        I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
        Read more
        Cloud

        Yotascale CEO Asim Razzaq on Controlling Multicloud...

        James Maguire - May 5, 2022 0
        Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
        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.
        © 2021 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.

        ×