From Section 1.4 Graphing Functions in a Spreadsheet

Skip to main content

\(\newcommand{\Volume}{\mathrm{Volume}} \newcommand{\xLow}{\mathrm{xLow}} \newcommand{\xHigh}{\mathrm{xHigh}} \newcommand{\Mcost}{\operatorname{Marginal Cost}} \newcommand{\cost}{\operatorname{Cost}} \newcommand{\Mrev}{\operatorname{Marginal Revenue}} \newcommand{\revenue}{\operatorname{Revenue}} \newcommand{\profit}{\operatorname{Profit}} \newcommand{\Mprofit}{\operatorname{Marginal Profit}} \newcommand{\Pprofit}{\operatorname{Predicted Profit}} \newcommand{\price}{\operatorname{Price}} \newcommand{\Dprice}{\operatorname{Demand Price}} \newcommand{\Pprice}{\operatorname{Purchase Price}} \newcommand{\Sprice}{\operatorname{Supply Price}} \newcommand{\marginal}{\operatorname{Marginal}\,} \newcommand{\linear}{\operatorname{Linear}\,} \newcommand{\abs}[1]{\left\lvert #1\right\rvert} \newcommand{\quantity}{\mathrm{Quantity}} \newcommand{\AnnualCost}{\operatorname{Annual Cost}} \newcommand{\AnnualExpense}{\operatorname{Annual Expense}} \newcommand{\RepairFactor}{\mathrm{Repair Factor}} \newcommand{\Sales}{\operatorname{Sales}} \newcommand{\prediction}{\operatorname{prediction}} \newcommand{\FutureValue}{\operatorname{Future Value}} \newcommand{\demand}{\operatorname{Demand}} \newcommand{\val}{\operatorname{Value}} \newcommand{\raw}{\mathrm{raw}} \newcommand{\gizmos}{\operatorname{gizmos}} \newcommand{\intermediate}{\mathrm{intermediate}} \newcommand{\tax}{\operatorname{tax}} \newcommand{\FaceValue}{\operatorname{Face Value}} \newcommand{\rate}{\mathrm{rate}} \newcommand{\years}{\mathrm{years}} \newcommand{\expense}{\operatorname{expense}} \newcommand{\FutureAmount}{\operatorname{FutureAmount}} \newcommand{\InitialDeposit}{\mathrm{InitialDeposit}} \newcommand{\ppy}{\mathrm{ppy}} \newcommand{\PresentAmount}{\operatorname{PresentAmount}} \newcommand{\PriceGizmo}{\mathrm{PriceGizmos}} \newcommand{\QuantityGizmo}{\mathrm{QuantityGizmos}} \newcommand{\QuantityGadget}{\mathrm{QuantityGadgets}} \newcommand{\QuantityWidget}{\mathrm{QuantityWidgets}} \newcommand{\PriceWidget}{\mathrm{PriceWidgets}} \newcommand{\PriceGadget}{\mathrm{PriceGadgets}} \newcommand{\QW}{\mathrm{QW}} \newcommand{\QG}{\mathrm{QG}} \newcommand{\PW}{\mathrm{PW}} \newcommand{\PG}{\mathrm{PG}} \newcommand{\Production}{\operatorname{Production}} \newcommand{\Labor}{\mathrm{Labor}} \newcommand{\Capital}{\mathrm{Capital}} \newcommand{\Linear}{\operatorname{Linear}\,} \newcommand{\PriceX}{\mathrm{PriceX}} \newcommand{\PriceY}{\mathrm{PriceY}} \newcommand{\predicted}{\operatorname{predicted}} \newcommand{\Time}{\mathrm{time}} \newcommand{\TotalAmount}{\operatorname{TotalAmount}} \newcommand{\TotalValue}{\operatorname{TotalValue}} \newcommand{\CashAmount}{\mathrm{CashAmount}} \newcommand{\DepositAmount}{\mathrm{DepositAmount}} \newcommand{\AvailableTrees}{\operatorname{AvailableTrees}} \newcommand{\Capacity}{\mathrm{Capacity}} \newcommand{\Amount}{\operatorname{Amount}} \newcommand{\InitialAmount}{\mathrm{InitialAmount}} \newcommand{\InvestmentAmount}{\mathrm{InvestmentAmount}} \newcommand{\Return}{\operatorname{Return}} \newcommand{\SD}{\mathrm{SD}} \newcommand{\Antideriv}{\operatorname{Antideriv}} \newcommand{\MC}{\operatorname{MC}} \newcommand{\MP}{\operatorname{MP}} \newcommand{\MR}{\operatorname{MR}} \newcommand{\CDFf}{\operatorname{CDFf}} \newcommand{\Principal}{\operatorname{Principal}} \newcommand{\ProducerSurplus}{\mathrm{ProducerSurplus}} \newcommand{\ConsumerSurplus}{\mathrm{ConsumerSurplus}} \newcommand{\TotalSocialGain}{\mathrm{TotalSocialGain}} \newcommand{\Elasticity}{\operatorname{Elasticity}} \newcommand{\lt}{<} \newcommand{\gt}{>} \newcommand{\amp}{&} \definecolor{fillinmathshade}{gray}{0.9} \newcommand{\fillinmath}[1]{\mathchoice{\colorbox{fillinmathshade}{$\displaystyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\textstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptscriptstyle\phantom{\,#1\,}$}}} \)

Section A.2 From Section 1.4 Graphing Functions in a Spreadsheet

Graph a function We graph a function in Excel by first making a table of input and output values. We then select the values for both the x and y values, then select the button to insert a scatter plot. The most common error is to only selct the output, in which case Excel assumes the sequence 1, 2, 3, ... is the input. A screencast of the production of a graph of a simple function. 1.4.1 An image of the table with selections made. 1.4.3
Graph multiple functions Two graph multiple functions we start with a chart that has the input and the output of the multiple functions, Select the column for the input and the outputs to be graphed and then insett a scatterplot. If the input variable is not included, Excel will interpret the first output varaiable as the input and give a very different graoph. If the input and functions are not next to each other in the table, you need to right click (control-click on a Mac) to select cells that are not adjacent. A screencast of the production of a graph of with several function. 1.4.7 An image of the table with multiple functions selection made. 1.4.8
Use a secondary axis. If the scales of the graphs are noticably differnt we want to use a secondary axis for one of the graphs. For example is we are graphung \(f(x)=x^2\) and \(g(x)=x^5\) for the interval \([-10,10]\text{,}\) the scale of \(g(x)\) is so large that we cannot see what happens fith \(f(x)\text{.}\) To use a secondary axis, double click a point and then select secondary axis from the axes tab. An image of two functions and secondary axes. 1.4.9
Formatting a chart. 1.4.5 Excel gives you the ability to format your chart. Clciking on a chart brings up the "Chart Design" tab. There are menus for "Add Chart Element", "Quick Layout", and "Change Chart Type".
Graph functions with parameters in the definition. We can add parameters to the table we are creating to either look at a variety of curves or to change the domain of the graph. Parameters and values that will be used throguhout the table are written as absolute references. A screencast of producing a graph with parameters. 1.4.4 An image of the table with selections made. 1.4.5