1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12 2222 4 3 12 2 12 1 12 0.1 12 0.01 8 12 0.001 9 12 0.0001 10 12 0.00001 11 12 0.000001 12 12 0.0000001 D Quotient (calculator) Quotient (Excel) 2. Find the Quotient for each row using a calculator and type the result in the third column. Recall that to find the Quotient, you take the Dividend and divide by the Divisor. Dividend + Divisor = Quotient 3. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 4. Based on the pattern of the Quotient, do your best to explain what happens when 12 is divided by 0? 5. What happens if you enter the expression 12 + 0 on a calculator? 6. Now, conduct this activity using Excel. Enter the following expression into cell D2: =A2/B2 and hit the enter key. Repeat this step for cells D3 through D12. Note that it is important to type the equal sign first. This tells Excel that what follows is a mathematical formula to be computed rather than text. 7. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 8. Page 21 of your textbook says that "a 0 is undefined for any number a. Any number divided by zero is undefined." That means that the Quotient is undefined for any number when divided by zero; the Quotient does not have meaning. Why do you think the Quotient does not have meaning? 9. Now, switch the number values in column A with column B, so that the Dividend ranges from 4 to 0.0000001 and the Divisor is consistent at 12. Now what is happening to the Quotient? 10. What patterns do you notice? 11. What is one question about algebraic expressions or division by zero that you are wondering about? 12. Now, create two new patterns for the Dividend and/or the Divisor, for your classmates to investigate what happens to the Quotient. 13. For your initial post, post pictures of your excel work but you don't have to attach the actual excel document. You also need to post the instructions addressing all of the prompts and questions, showing your work, and explaining your solutions or answers to all of the questions. Make sure to also post the two new patterns for the Dividend and/or the Divisor for your classmates to investigate what happens to the Quotient. 1. Enter the following text in Excel: A B 1 Dividend Divisor 2 12 34569 12 2222 4 3 12 2 12 1 12 0.1 12 0.01 8 12 0.001 9 12 0.0001 10 12 0.00001 11 12 0.000001 12 12 0.0000001 D Quotient (calculator) Quotient (Excel) 2. Find the Quotient for each row using a calculator and type the result in the third column. Recall that to find the Quotient, you take the Dividend and divide by the Divisor. Dividend + Divisor = Quotient 3. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 4. Based on the pattern of the Quotient, do your best to explain what happens when 12 is divided by 0? 5. What happens if you enter the expression 12 + 0 on a calculator? 6. Now, conduct this activity using Excel. Enter the following expression into cell D2: =A2/B2 and hit the enter key. Repeat this step for cells D3 through D12. Note that it is important to type the equal sign first. This tells Excel that what follows is a mathematical formula to be computed rather than text. 7. As the Divisor gets smaller (approaches zero) what is happening to the Quotient? 8. Page 21 of your textbook says that "a 0 is undefined for any number a. Any number divided by zero is undefined." That means that the Quotient is undefined for any number when divided by zero; the Quotient does not have meaning. Why do you think the Quotient does not have meaning? 9. Now, switch the number values in column A with column B, so that the Dividend ranges from 4 to 0.0000001 and the Divisor is consistent at 12. Now what is happening to the Quotient? 10. What patterns do you notice? 11. What is one question about algebraic expressions or division by zero that you are wondering about? 12. Now, create two new patterns for the Dividend and/or the Divisor, for your classmates to investigate what happens to the Quotient. 13. For your initial post, post pictures of your excel work but you don't have to attach the actual excel document. You also need to post the instructions addressing all of the prompts and questions, showing your work, and explaining your solutions or answers to all of the questions. Make sure to also post the two new patterns for the Dividend and/or the Divisor for your classmates to investigate what happens to the Quotient.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these mathematics questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
Since graduation from college, your friend William has become a highly paid and successful financial advisor. His list of clients is long, and his advice is sought by many. Discuss the merits of the...
-
Calculate the flux of F = xi + yj + 3 k across the sphere x2 + y2 + z2 = 1?
-
Sketch the graph of the set. {(x, y) | x 2 + y 2 . 4}
-
Two conspirators, Timothy Carpenter and Timothy Sanders, were charged with aiding and abetting a robbery affecting interstate commerce and the use or carriage of a firearm. At trial, the FBI...
-
On December 21, 2012, Zurich Company provided you with the following information regarding its trading investments. During 2013, Carolina Company shares were sold for $9,500. The fair value of the...
-
The downward acceleration of a 50-kg stuntwoman near the end of a fall from a very high building is 5.8 m/s2 . What resistive force does the air exert on her body at that point.
-
Which of the following is not a function of the nasal conchae? They increase the flow of air through the nasal cavity. They moisten the air. They help warm the air. They help trap particulates in the...
-
Sweaters sell for $20 at the crafts fair. Allie knits sweaters and her marginal costs are given in the table below. Allies marginal costs increase with each additional sweater. If Allie is behaving...
-
If logx 2 = 1 . 2 a and logx 3 = 1 . 5 a , find logx 1 2 . In terms of a .
-
Task 1 - a set of numbers between 10 and 20 - another set of numbers between 5 and 15 -Output to screen the difference of the two sets -Output to screen the common numbers of the two sets -Iterate...
-
Research a company's annual report. Prepare a video summary of the firm's financial ratios and financial statements. During the video summary, annotate the annual report and share relevant...
-
Consider the following function that is intended to swap the values in the n1 and n2 variables. void swapShells(int &n1, int &n2) { n1 = n2; n2 = } n1; It does not work as intended. Why?
-
Implement a class intlist which a list that stores only integers. You MUST subclass list. Please note the following: constructor can be passed a list of ints, or, by default constructs an empty...
-
In your audit of Garza Company, you find that a physical inventory on December 31, 2012, showed merchandise with a cost of $441,000 was on hand at that date. You also discover the following items...
-
Cumulative Normal distribution \(\Phi_{(\mu, \sigma)}\) and probability (a) \(X \sim \phi_{(0,1)}\); what is \(P(X \leq 1.43)\) ? (b) \(X \sim \phi_{(0,1)}\); what is \(P(X>1.43)\) ? (c) \(X \sim...
-
Inverse cumulative Normal distribution \(z\) (a) Find \(z_{0.05}\). (b) Find \(z_{0.95}\). (c) Let \(X \sim \phi_{(2,1)}\). Find \(a\) such that \(P(X \leq a)=0.05\). (d) Let \(X \sim \phi_{(2,1)}\)....
-
The Normal approximation (a) A discrete stochastic variable \(X\) has expected value \(\mu_{X}=3\) and \(\sigma_{X}=1.2\). Use the Normal approximation to find \(P(X \leq 4)\). (b) A continuous...
Study smarter with the SolutionInn App