Excel and Statistics — Why It’s the Better Choice Over the TI-84

Every college student takes a course to learn the Microsoft package (Word, Excel, Access, etc.), yet the majority of us are still uncomfortable with using Excel at even an intermediate level.  When many students realize the same statistical tools can be done in their handy dandy calculator, it’s the obvious solution.  So why do some statistics courses encourage, and in many cases, force students to use Excel instead?

 

Practicality

While Excel may give you anxiety, it really is the prime tool to use for statistics.  The main advantage is the ability to simply input new data, and achieve results.  The primary advantage, and this applies to many different things in life, is that you only have to solve a statistics problem, or set up a personal budget, one time.  When you need it again, you simply enter in your new numbers and Excel pumps out the answer.  Gone are the days of having to redo a problem eight times despite the obvious similarities — Excel saves you time and effort.

 

Big Data

This might not apply to many of us in statistics classes, but realistically if you have more than ten data points, do you really want to sit and enter them into your calculator over and over?  Unfortunately, many people choose this as their solution because of their natural fear of Excel.  If you’re a business statistics student, then this is what should really apply to you.  Statistics is less about calculations and more about analysis of results.  Having a tool that can generate results in a few seconds has a million business applications.  While we deal with small sample sizes for conceptual understanding in any statistics class, you simply can’t make any significant conclusion off a small number of observations.  Mastering Excel allows you to really look at what behaviors your customers exhibit, but also to look at it from different perspectives.

Every major decision in the world is made based off statistics, and any professor worth their salt will attempt to have you do this in Excel.  From science to finance to engineering, statistical analysis dictates what is right/wrong, or what the right decision may be.  An understanding of statistics is useful, but being unable to generate the numbers can be crippling.

 

Colleges are sub par at best for showing you the true uses of Excel.  A statistics tutor can quickly and easily lead you to the conclusion, but also strengthen your Excel skills at the same time.

Statistics – Why Is It So Intimidating?

[et_pb_section admin_label=”section”]
[et_pb_row admin_label=”row”]
[et_pb_column type=”4_4″]
[et_pb_text admin_label=”Text”]
Statistics is a phrase that strikes fear into the greater part of the world, regardless of whether you’re a student or not.  The big question is why — why does statistics put the fear of God in even the average citizen?  Considering that the only “statistics” we see in our daily lives is “60% of Americans prefer milk over water after a slice of chocolate cake” what reason does it have to make us cower?

Statistics - Sample Standard Deviation

Does that picture scare you?  What if I told you that this is a formula formally taught within the first few weeks of an introductory statistics class?  It’s something called sample standard deviation, a measure of variance, or in more plain terms, a measure of how spread out numbers in a data set are.  Broken into its individual pieces, this formula isn’t intimidating and is actually on par with eighth grade arithmetic.  As you’ll see in many of my blog posts, the issue is with how it’s taught.

Statistics is mainly taught in Greek symbols, much like a majority of our more advanced math.  This in it of itself makes it more intimidating, but why should a few letters scare you away?  After all, we are in the modern day; the age where calculators are capable of taking the legwork out of any mathematical calculation.

Statistics in its truest form is simply the interpretation of the numbers derived from these kinds of computations.  It’s the analysis and conclusions made from these that actually composes the discipline.  As an educator myself, I hate to place blame on other educators, and perhaps the issue is deeper than that, but the way statistics is taught these days at the collegiate level inherently scares away anyone who might find even a modicum of interest.  As an aside, the amount of business statistics tutoring clients I’ve had that became intensely fascinated with this same discipline after a few lessons is astounding.  Taking a step away from it’s societal association with math, you end up with a pure science that has a lot to give people.  Many of my statistics tutoring students even after reaching their goals of simply passing, continue to take classes to explore the science itself.

The theory of statistics and it’s role in the world today (seriously, there isn’t a part of your everyday life that it isn’t involved in) is worth studying.  It’s far deeper than just equations, and even if it’s just a class for a semester, having a tutor alongside not only gets you to pass, but allows you to see this modern day role.
[/et_pb_text]
[/et_pb_column]
[/et_pb_row]
[/et_pb_section]

Why Are Online Math Classes So Difficult?

If you’ve ever tried to take a math class online, you’ve felt the feeling of helplessness that comes after the first few weeks.  Sociology, biology, humanities — none of them pose near as much trouble as online statistics or math.  So what makes them so difficult?   There’s many, many reasons for this.

 

Poor Study Materials

You ever wonder why you buy that crazy expensive math textbook even though you only end up doing homework from it?  Some professors might ask you to read a lesson or two, but overall you rely on in-person lecture to give you information.  It’s because these textbooks aren’t made for self-study, they’re meant to be a supplement to actual lecture.  Essentially, your professor teaches you the entire lecture (or what portions he wants you to learn) and you refer to the beginning of the chapter if/when you need help.

Online classes skip this lecture portion, often only providing a PowerPoint with examples.  The problem is they aren’t any different than those used in class, so the entire explanation by the professor is just.. missing.  Such minimal effort is put into these online classes that it’s made simply impossible to tackle on your own.  The best of online math professors will provide video examples, but again, without a lecture these are completely useless.  Even with years of math tutoring under our belts, they can even test our abilities.

 

Little to No Support

The biggest issue with online math classes is the process you’re expected to go through when you have trouble with a lesson.  Either you a) contact the professor through e-mail (good luck explaining your process or showing him the steps with a keyboard) or you b) visit an on-site tutoring center, defeating the purpose of an online class in the first place.  To boot, these centers are typically understaffed meaning what we might get done in an entire hour with you would take you four there.

 

The point of hiring a math tutor isn’t always to provide a personalized learning plan.  For many, it’s worth the extra cost to save the time.  You have to ask yourself in the midst of one of these classes: what is your time worth?  Can you afford four hours in a tutoring center to finish one assignment?  Or are those extra three hours worth shelling out the cash for a math tutor?

The problem here is systemic, and is an issue with many online classes as a whole, math just gets it the worst.  Until someone (whoever that might be) addresses the issue that is online schooling, an entirely independent math class might never exist.