"Pizza PI Day!" - from Learn Excel with MrExcel: Podcast #1666

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 14, 2013 .
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!
maxresdefault.jpg


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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,361
Messages
5,641,683
Members
417,229
Latest member
BODYCOTE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top