Wednesday, January 12, 2011

Excel Model Building - Experts vs. Non-Experts

Excel Model Building -

Experts vs. Non-experts



What makes a great Excel modeler? There actually are identifiable skills and problem-solving tendencies that expert Excel modelers seem to possess in greater abundance than the average Excel modeler.

A brief study was done by Dartmouth Professors Stephen Powell and Kenneth Baker, authors of the best book ever written about quantitative Excel modeling: Management Science – The Art of Modeling With Spreadsheets. (If you are interested, I've reviewed the book on this page. It is the 4th Internet marketing book review on the web page)

Professors Powell and Baker audiotaped 28 of their MBA students work through 4 ill-structured modeling problems. The focus of the test was not to observe the students create a spreadsheet for a well-defined problem but rather to craft the right Excel modeling approach to a problem that had not been well thought-out and structured in advance. This situation much more closely approximates the real life faced by a consultant or business decision-maker.

Major Differences Between Expert and Non-Expert Model Builders

Professors Powell and Baker listed the following conclusions of their study in their well-respected book:

1) The expert model builders would build the model first and then ask for data later. Non-experts would immediately focus on the data. Non-experts appeared to exhibit a much stronger reliance for the data at hand.

2) Experts would create and evaluate a number of solutions before narrowing their efforts on just one. Non-experts tended to select an overall direction after significantly less evaluation or creation of other alternatives. Non-experts sometimes had a tendency to try and avoid the model-building process altogether and propose solutions such as: “Let’s call an expert” or “Let’s do market research.”

3) Expert modelers as a whole are stronger in math than non-experts.

4) Expert modelers would think more in terms of variables and relationships in the early stages of problem solving. Non-experts would often use concrete numbers right away.

5) Experts tended to stop much more often during the model-building process and re-evaluate their current progress and direction.

6) Experts initially framed problems in ways that could be translated to a model quickly. Non-experts tended to be much more unstructured in their early attempts to create an overall plan. Their attempts at early organization seemed to resemble brainstorming sessions.

7) Expert model builders solved the problems by working backward from what the solution was supposed to provide. Non-experts did not use this approach as much.

Conclusions

Practical Excel model-building advice based upon the modeling approaches of experts would be the following:

1) Don’t expect data to answer the problem.

2) Don’t be in a rush to find the quick answer.

3) Try to see the forest through the trees. Always keep in focus what the overall goal of the model is.

4) Try to create and evaluate a number of different approaches before deciding on the overall direction that your model will take.

5) Regularly re-evaluate your progress toward your model’s completion and the direction that you are currently taking.


Here are some other blog entries related to this article:

Correctable Reasons Why Your Data Is Not Normally Distributed

22 Big Statistical Mistakes You Don't Want To Make

Logistic Regression in Excel To Predict If a Prospect Will Buy

How To Build a Better Split-Tester in Excel Than the Google Web Site Optimizer

Using the Normal Distribution in Excel To Find Your Daily Range of Sales

If you would like to create a link to this blog article, here is the link to copy for your convenience: Modeling in Excel - Experts vs. Non-experts

Excel Model Building - Experts vs. Non-Experts
Please post any comments you have on this article. Your opinion is highly valued!

If You Like This, Then Share It...
Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts Excel Model Building - Experts vs. Non-Experts

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

8 comments:

  1. Part of the reason why some people still struggle with what it means to be a Business Analyst is because it is a very diverse career by definition. Business Analysis is defined very clearly in the IIBA (R) BABOK (R) guide, and yet, if you read this guide, you will agree that there is enormous scope for a Business Analyst to do a wide variety of things with their careers. So let's look at some of the aspects that make our careers so diverse and interesting. 출장마사지

    ReplyDelete
  2. The dream of business ownership is alive and well these days, especially in Colorado. As of 2015, the state is home to nearly 600,000 small businesses which employ almost 1,000,000 people! Every day you hear about a new start up being launched or a company taking its headquarters to Colorado. Business is good! So for today's discussion, we thought it would be important to address the benefits of buying an established business over starting a business bookkeeping and accounting

    ReplyDelete
  3. Basically, eCommerce alludes to business exchanges led on the web. This implies at whatever point you purchase and offer something utilizing the Internet, you're engaged with eCommerce. It was August 11, and it was 1994. SHOPIFY WEBSITE DESIGN AGENCY

    ReplyDelete
  4. Overview: Becoming a self-employed businessman is a great reputation in the society but the problems faced by the entrepreneurs from the day one of their business is enormous. It is a great challenge for a person to overcome all obstacles to become a successful businessman. The numerous problem faced by all is finance. Even great entrepreneurs of various industries have struggled a lot of financial crisis for setting up their business and to run their daily business operations. Thus finance plays a major role in the life of business people. Great ideas require the necessary financial support to bloom into a successful business. singapore

    ReplyDelete
  5. สล็อต Treasures of Aztec เกมสล็อตคนป่าล่าสุด เกมสล็อตpg สล็อตทำเงินใหม่ล่าสุด เเตกง่าย เเตกไวทุกช่วงเวลา ภาพสวยคมชัด สีสันสวยงาม เอฟเฟ็กปัง มีฟีเจอร์ทำเงินครบครัน ทำเงินได้ง่าย เบทน้อย กำไรไวที่สุด เหมาะสำหรับการทำเงินมากที่สุด สล็อตไม่มีขั้นต่ำ ถอนไม่อั้น ฝาก-ถอน AUTO เพียง 10 วินาทีเท่านั้น.

    ReplyDelete
  6. thanks for one’s
    온카맨검증커뮤니티

    ReplyDelete
  7. along side everything assed her predicted consequences. I appreciate you for presenting the useful, safe, explanatory as well as cool hints approximately this subject matter to mary. 토스타

    ReplyDelete