There are four different answers to the mathematical question: 3 + 2 * 3^2 = ?
This is because the answer is dependent on the order of precedence. In this discussion, you will consider the order of precedence and how it affects mathematical calculations in Excel. The four answers are below.
1. ((3 + 2) * 3)^2 = 225
2. (3 + 2) * (3^2) = 45
3. 3 + ((2 * 3)^2) = 39 and
4. 3 +( 2 * (3^2)) = 21
Include answers to the following questions in a single Word document (written in APA format):
1. a) How many different answers can you get to 5 + 3 * 4^2 - 2 = ? and what are they?
b) How did you arrive at these answers?
c) What is the "order of precedence?"
d) Which is the correct answer to using the "order of precedence" and why?
e) What answer does your calculator give? (Try several calculators if possible. The answers may differ!)
f) How did your calculator arrive at this answer?
g) What does Excel give?
2. Do you think there should be one "Correct" answer to this? If so, which one and why?
Create an order of precedence problem of your own, first without any parentheses and then with parentheses, showing the differences in answers and the correct answer in your problem.