It's PI Day - 3/14 or 3.14 - and Pizza is typically round in the US, so today Bill has decided to dedicate today's Podcast to =PI()*Radius^2. Follow along with Episode #1666 to get a bit of PI/Pie humor and some Radial number crunching in Excel with MrExcel!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1666 Pizza PI Day Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Why is March 14th, Pi Day?
Now, let's format this number with a custom number format of M dot D.
So, modern way to write the date 3.14 and if we do equal PI.
It also, if we use the right number of decimal places is 3.14, as well.
All right, so see it's a math joke, math people love this.
I love this.
Let's see, if we can use PI to solve a real-life problem.
So, here we have Mo's Pizza Shop.
They have two sizes of pizza, that's small is a 10-inch pizza.
It's $6.99, now if we need 3 of those, for 20.97 or they have a large pizza,15 inch pizza, that's 10.49 and we figure might need two of those.
So, the price comes out about the same, right and if we just do simple math, 3 times 10 is 30, 2 times 15 is 30.
It sounds like it's a wash, right.
We could get either one and have the same amount of pizza.
Now, but let's figure it out area of a circle is PI times the radius squared, PI, R squared.
No pies around another math joke.
So, how do we say this in Excel, equal PI, open closed parenthesis, times the radius carat 2 (^2) that's how we square something.
So, we'll do area of one is equal to PI, open and closed parenthesis, times in parentheses, the diameter divided by 2, raised to the second power.
So, 78 square inches in a 10-inch pizza, will copy this down and 15 inch pizza has a 176 square inches.
So, total area is equal the area 1, times the quantity, 235 inches in the first one, 353 inches in the second one, clearly if you're looking for Mo Pizza, that's the one to choose because that's the best deal.
So, call Mo's Pizza Shop and say hey! what 2 larges, because it's the better deal.
All right all my math geek friends out there and all my friends want to wish you a Happy PI Day.
Enjoy a slice of pizza tonight or blueberry pie your call.
We'll see you next time for another net cast from MrExcel.
Learn Excel from MrExcel podcast, episode 1666 Pizza PI Day Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Why is March 14th, Pi Day?
Now, let's format this number with a custom number format of M dot D.
So, modern way to write the date 3.14 and if we do equal PI.
It also, if we use the right number of decimal places is 3.14, as well.
All right, so see it's a math joke, math people love this.
I love this.
Let's see, if we can use PI to solve a real-life problem.
So, here we have Mo's Pizza Shop.
They have two sizes of pizza, that's small is a 10-inch pizza.
It's $6.99, now if we need 3 of those, for 20.97 or they have a large pizza,15 inch pizza, that's 10.49 and we figure might need two of those.
So, the price comes out about the same, right and if we just do simple math, 3 times 10 is 30, 2 times 15 is 30.
It sounds like it's a wash, right.
We could get either one and have the same amount of pizza.
Now, but let's figure it out area of a circle is PI times the radius squared, PI, R squared.
No pies around another math joke.
So, how do we say this in Excel, equal PI, open closed parenthesis, times the radius carat 2 (^2) that's how we square something.
So, we'll do area of one is equal to PI, open and closed parenthesis, times in parentheses, the diameter divided by 2, raised to the second power.
So, 78 square inches in a 10-inch pizza, will copy this down and 15 inch pizza has a 176 square inches.
So, total area is equal the area 1, times the quantity, 235 inches in the first one, 353 inches in the second one, clearly if you're looking for Mo Pizza, that's the one to choose because that's the best deal.
So, call Mo's Pizza Shop and say hey! what 2 larges, because it's the better deal.
All right all my math geek friends out there and all my friends want to wish you a Happy PI Day.
Enjoy a slice of pizza tonight or blueberry pie your call.
We'll see you next time for another net cast from MrExcel.
