March 14 (3-14) is Pi day and we will take a look at some calculations with the PI and SQRTPI functions in Episode 715.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Friday March 14th, 3/14.
Episode 715 couple reminders, first of all tomorrow March 15th is the deadline for the contest we announced back in episode seven hundred.
Send me your name if you're in the US, a ZIP Code.
if you're elsewhere, a country in a postal code we talked about Microsoft MapPoint all entries by tomorrow have a chance to win a copy of Microsoft MapPoint will do that drawing on Mondays podcast you have to get that information in by Saturday though, Today March 14th 3/14 is Pi Day.
Pi is 3.14159 So, 3/14 is Pi Day.
Got a great calendar here this calendar the not so humble pie calendar it runs from March to March.
In honor a Pi Day want to send you out here to not so humble Pi, pi.com.
Great calendar this is illustrated by Bob D'Amico.
Bob is the guy who does the illustrations for the MrExcel books.
So, if you ever wonder, who does that cartoon it's a cartoon Bob and he illustrated this calendar for a math professor great hilarious calendar.
If you're a math guy, or just any kind of a technical person check out the calendar it not so humble pi.
They also have courses too late now at this point, but they have greeting cards so you can send out in honor of Pi Day.
3/14 last basketball fans Sunday of course is selection Sunday for the NCAA basketball tournament.
Once again we're going to get out the excel program and run a basketball pool completely in Excel on Monday or actually even Sunday night go to mrexcel.com/NCAA.html and you can download my spreadsheet enter your pics email it back you have a chance to win a couple of Excel books and it's just generally fun to to track that over the next Few weeks, the NCAA basketball tournament.
Completely free to play of course okay.
So, in today's podcast in honor of Pi Day.
We're gonna take a look at two functions in Excel that are related to Pi.
The first one is just simply the PI function equal Pi returns 3.14159 and this is great for figuring out the area of a circle.
So, if you have a 12-inch pizza, that's the diameter of course the radius is one half of that.
So, F4 divided by 2 and then to figure out the area of the circle you have =PI(), there's no arguments times the radius raised to the second power of course the shift 6 the carrot gives you the exponent there.
So, we see that a 12-inch pizza has 113 square inches.
16-inch Pizza has 201 square inches.
If you're really obsessing about the next office staff meeting, which pizza is the better deal you can use this to figure it out.
Now, back in special edition Using Excel 2007 I went through all 355 functions in Excel and when I got the square root of Pi this other function run to talk about I have to admit I could not figure out any use for it what so ever.
I talked about that on call for help up on Tech TV Canada and instantly someone wrote in with the answer.
They said well wait a second the square root of Pi function is useful for when you're trying to figure out what size square has the same number of square inches as a particular circle.
So, we have our 12-inch pizza here we know the radius is six you can use the square root of Pi function, =SQRTPI( and the argument is the radius squared and that gives us an answer of 10.63472.
Well, if you would go to the pizza store, and order a square pizza.
That was exactly 10.63472 inches on each side and then we square that to get the area it will have the exact same size.
I guess this is also useful for round tanks versus square tanks you can use the square root of Pi.
So in the book I theorize that there was nothing useful for square root of Pi.
That's not quite true.
Now, if you need to compare square pizzas to round pizzas you can very quickly use the square root of pie to figure that out. Well there you go Happy Pi Day.
Don't forget to, Don't forget to check out the cool calendar it not so humble pie. Just, pi.com great little novelty calendar for the Techie and all of us and check back on Monday at NCAA.html and enter our free college basketball pool, and we'll see who who's the best prognosticator out there.
Well, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Friday March 14th, 3/14.
Episode 715 couple reminders, first of all tomorrow March 15th is the deadline for the contest we announced back in episode seven hundred.
Send me your name if you're in the US, a ZIP Code.
if you're elsewhere, a country in a postal code we talked about Microsoft MapPoint all entries by tomorrow have a chance to win a copy of Microsoft MapPoint will do that drawing on Mondays podcast you have to get that information in by Saturday though, Today March 14th 3/14 is Pi Day.
Pi is 3.14159 So, 3/14 is Pi Day.
Got a great calendar here this calendar the not so humble pie calendar it runs from March to March.
In honor a Pi Day want to send you out here to not so humble Pi, pi.com.
Great calendar this is illustrated by Bob D'Amico.
Bob is the guy who does the illustrations for the MrExcel books.
So, if you ever wonder, who does that cartoon it's a cartoon Bob and he illustrated this calendar for a math professor great hilarious calendar.
If you're a math guy, or just any kind of a technical person check out the calendar it not so humble pi.
They also have courses too late now at this point, but they have greeting cards so you can send out in honor of Pi Day.
3/14 last basketball fans Sunday of course is selection Sunday for the NCAA basketball tournament.
Once again we're going to get out the excel program and run a basketball pool completely in Excel on Monday or actually even Sunday night go to mrexcel.com/NCAA.html and you can download my spreadsheet enter your pics email it back you have a chance to win a couple of Excel books and it's just generally fun to to track that over the next Few weeks, the NCAA basketball tournament.
Completely free to play of course okay.
So, in today's podcast in honor of Pi Day.
We're gonna take a look at two functions in Excel that are related to Pi.
The first one is just simply the PI function equal Pi returns 3.14159 and this is great for figuring out the area of a circle.
So, if you have a 12-inch pizza, that's the diameter of course the radius is one half of that.
So, F4 divided by 2 and then to figure out the area of the circle you have =PI(), there's no arguments times the radius raised to the second power of course the shift 6 the carrot gives you the exponent there.
So, we see that a 12-inch pizza has 113 square inches.
16-inch Pizza has 201 square inches.
If you're really obsessing about the next office staff meeting, which pizza is the better deal you can use this to figure it out.
Now, back in special edition Using Excel 2007 I went through all 355 functions in Excel and when I got the square root of Pi this other function run to talk about I have to admit I could not figure out any use for it what so ever.
I talked about that on call for help up on Tech TV Canada and instantly someone wrote in with the answer.
They said well wait a second the square root of Pi function is useful for when you're trying to figure out what size square has the same number of square inches as a particular circle.
So, we have our 12-inch pizza here we know the radius is six you can use the square root of Pi function, =SQRTPI( and the argument is the radius squared and that gives us an answer of 10.63472.
Well, if you would go to the pizza store, and order a square pizza.
That was exactly 10.63472 inches on each side and then we square that to get the area it will have the exact same size.
I guess this is also useful for round tanks versus square tanks you can use the square root of Pi.
So in the book I theorize that there was nothing useful for square root of Pi.
That's not quite true.
Now, if you need to compare square pizzas to round pizzas you can very quickly use the square root of pie to figure that out. Well there you go Happy Pi Day.
Don't forget to, Don't forget to check out the cool calendar it not so humble pie. Just, pi.com great little novelty calendar for the Techie and all of us and check back on Monday at NCAA.html and enter our free college basketball pool, and we'll see who who's the best prognosticator out there.
Well, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
