14
Mar
Author: ABG // Category:
Math
[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]
For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.
I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.
Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.

Popularity: 9%
04
Feb
Author: ABG // Category:
Math
I was never a big fan of these types of problems on standardized tests when I was younger but the more you analyze the problems, the better your reasonable skills should eventually become.
Take this problem for example this image below. Can you determine which one is the odd one out?

The answer is after the fold.
Read more…
Popularity: 10%
09
Jan
Author: ABG // Category:
Math

The proof seems so obvious now.
Source: Abstruse Goose
Popularity: 10%
05
Jan
Author: ABG // Category:
Math
It is no shocking news that the ability of children all across the country to perform lower level mathematics has been significantly dropping year after year. By lower level math I mean things like division with decimals, multiplication with exponents, scientific notation as well as basic geometry, algebra and trigonometry.
The test that I am going to attach below and hopefully something that you will all take just to see how much you simple math you still remember to be able to do. Out of the 13 problems on that exam, I had problems with (1e) for some unexplainable reason but I guess that is me being rusty. I did well there not to embarrass at least myself but it certainly would not surprise me if those people who have done little to no math since high school that they would struggle exam. It is not a trend that I like but it is only a matter of fact nowadays.
This was a test (UW – Math Test) was conducted by a professor at the University of Washington who teaches Atmospheric Sciences 101, which is supposedly a large lecture with a diverse population of students from different majors I would assume. The results that the professor got from the simple test were rather appalling due to the lack of abilities of the incoming freshmen year after year.
The professor went on to write:
The results were stunning, in a very depressing way. This was an easy test, including elementary and middle school math problems. And these are students attending a science class at the State’s flagship university–these should be the creme of the crop of our high school graduates with highGPAs. And yet most of them can’t do essential basic math–operations needed for even the most essential problem solving.
Consider these embarrassing statistics from the exam:
The overall grade was 58%
43% did not know the formula for the area of a circle
86% could not do a simple algebra problem (problem 4b)
75% could not do a simple scientific notation problem (1e)
52% could not deal with a negative exponent (2 to the -2)
43% could not do simple long division problem with no remainder!
47% did not know what a cosine was.
Take The Test Here: UW – Math Test
Answer Key (Take Test First!): UW – Math Test Answers

Popularity: 13%