Scribd Logo
Upload

Welcome to Scribd!

  • 143 views

    How To Create Cobweb/staircase Diagrams in Excel: A. Creating The Iteration Data

    Uploaded by

    Asitha Kulasekera
    This document provides instructions for creating cobweb/staircase diagrams in Excel. It describes: 1) Creating iteration data by entering initial values in columns A and B and copying the formulas down the columns. 2) Creating data for the curve and line by entering x-values in column D and y-values for the curve in column E. 3) Plotting the data by selecting the range and creating an XY scatter plot, assigning the curve to Series 2 using columns D and E and the line to Series 3 using the repeated x-values in column D.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    How To Create Cobweb/staircase Diagrams in Excel: A. Creating The Iteration Data

    Uploaded by

    Asitha Kulasekera
    143 views3 pages
    This document provides instructions for creating cobweb/staircase diagrams in Excel. It describes: 1) Creating iteration data by entering initial values in columns A and B and copying the formulas down the columns. 2) Creating data for the curve and line by entering x-values in column D and y-values for the curve in column E. 3) Plotting the data by selecting the range and creating an XY scatter plot, assigning the curve to Series 2 using columns D and E and the line to Series 3 using the repeated x-values in column D.

    Original Description:

    Creating cobweb diagrams in excel

    Original Title

    Cobweb OHPs

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for creating cobweb/staircase diagrams in Excel. It describes: 1) Creating iteration data by entering initial values in columns A and B and copying the formulas down the columns. 2) Creating data for the curve and line by entering x-values in column D and y-values for the curve in column E. 3) Plotting the data by selecting the range and creating an XY scatter plot, assigning the curve to Series 2 using columns D and E and the line to Series 3 using the repeated x-values in column D.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    143 views3 pages

    How To Create Cobweb/staircase Diagrams in Excel: A. Creating The Iteration Data

    Uploaded by

    Asitha Kulasekera
    This document provides instructions for creating cobweb/staircase diagrams in Excel. It describes: 1) Creating iteration data by entering initial values in columns A and B and copying the formulas down the columns. 2) Creating data for the curve and line by entering x-values in column D and y-values for the curve in column E. 3) Plotting the data by selecting the range and creating an XY scatter plot, assigning the curve to Series 2 using columns D and E and the line to Series 3 using the repeated x-values in column D.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 3

    How to create cobweb/staircase diagrams in Excel

    A. Creating the iteration data


    1. In A1, enter your chosen value of a (e.g. 2.5).
    2. In B1, enter your chosen seed or starting value (e.g. 0.3).
    3. In B2, enter the formula

    =B1

    4. In B3, enter the formula

    =A$1*B1*(1-B1)

    5. Copy-and-paste cells B2, B3 into B4, B5.


    Copy-and-paste cells B2, B3 into B6, B7.

    Copy-and-paste cells B2, B3 into B30, B31.


    Column B now contains the x-coordinates we need.
    This step can be cleverly speeded up. How?
    6. In C1, enter the formula

    =B2

    7. Highlight cells C1:C30 and Fill Down (control-D).


    Column C now contains the y-coordinates we need.

    cobweb/staircase OHP

    page 1 of 3

    How to create cobweb/staircase diagrams in Excel


    B. Creating the data for the curve and the straight line
    1. In D1, enter 0.
    2. In D2, enter the formula

    =D1+0.05

    3. Highlight cells D2:D21 and Fill Down.


    Column D now contains the x-coordinates for the curve and the
    straight line.
    4. In E1, enter the formula

    =A$1*D1*(1-D1)

    5. Highlight cells E1:E21 and Fill Down.


    Column E now contains the y-coordinates for the curve. Weve
    already got the y-coordinates for the straight line. Where?

    cobweb/staircase OHP

    page 2 of 3

    How to create cobweb/staircase diagrams in Excel


    C. Plotting
    1. Click-drag, and highlight columns B:E, rows 1:30.
    2. Open the Chart Wizard (look for the bar chart icon on the toolbar:
    ).
    3. Select XY (Scatter)
    4. Select joined graph, no dots: the bottom right panel.

    Click Next>.
    5. Select the Series tab.
    6. Select Series2. Change X Values to
    =Sheet1!$D$1:$D$21
    Change Y Values to
    =Sheet1!$E$1:$E$21
    Series 2 now corresponds to the plot of the curve.
    7. Select Series3. Change X Values to
    =Sheet1!$D$1:$D$21
    Change Y Values to
    =Sheet1!$D$1:$D$21
    Series 3 now corresponds to the plot of the straight line.
    8. Finish.
    cobweb/staircase OHP

    page 3 of 3

    You might also like