IDEAS home Printed from https://ideas.repec.org/a/eee/enepol/v38y2010i11p7508-7511.html
   My bibliography  Save this article

Potential errors when fitting experience curves by means of spreadsheet software

Author

Listed:
  • van Sark, W.G.J.H.M.
  • Alsema, E.A.

Abstract

Progress ratios (PRs) are widely used in forecasting development of many technologies; they are derived from historical data represented in experience curves. Fitting the double logarithmic graphs is easily done with spreadsheet software like Microsoft Excel, by adding a trend line to the graph. However, it is unknown to many that these data are transformed to linear data before a fit is performed. This leads to erroneous results or a transformation bias in the PR, as we demonstrate using the experience curve for photovoltaic technology: logarithmic transformation leads to overestimates of progress ratios and underestimates of goodness of fit. Therefore, other graphing and analysis software is recommended.

Suggested Citation

  • van Sark, W.G.J.H.M. & Alsema, E.A., 2010. "Potential errors when fitting experience curves by means of spreadsheet software," Energy Policy, Elsevier, vol. 38(11), pages 7508-7511, November.
    • Handle: RePEc:eee:enepol:v:38:y:2010:i:11:p:7508-7511
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0301-4215(10)00517-3
    Download Restriction: Full text for ScienceDirect subscribers only
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. McDonald, Alan & Schrattenholzer, Leo, 2001. "Learning rates for energy technologies," Energy Policy, Elsevier, vol. 29(4), pages 255-261, March.
    2. Sagar, Ambuj D. & van der Zwaan, Bob, 2006. "Technological innovation in the energy sector: R&D, deployment, and learning-by-doing," Energy Policy, Elsevier, vol. 34(17), pages 2601-2608, November.
    3. Junginger, M. & Faaij, A. & Turkenburg, W. C., 2005. "Global experience curves for wind farms," Energy Policy, Elsevier, vol. 33(2), pages 133-150, January.
    4. Neij, L, 1999. "Cost dynamics of wind power," Energy, Elsevier, vol. 24(5), pages 375-389.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Kim, Dong Wook & Chang, Hyun Joon, 2012. "Experience curve analysis on South Korean nuclear technology and comparative analysis with South Korean renewable technologies," Energy Policy, Elsevier, vol. 40(C), pages 361-373.
    2. Reinhard Haas & Marlene Sayer & Amela Ajanovic & Hans Auer, 2023. "Technological learning: Lessons learned on energy technologies," Wiley Interdisciplinary Reviews: Energy and Environment, Wiley Blackwell, vol. 12(2), March.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Kahouli-Brahmi, Sondes, 2008. "Technological learning in energy-environment-economy modelling: A survey," Energy Policy, Elsevier, vol. 36(1), pages 138-162, January.
    2. Harborne, Paul & Hendry, Chris, 2009. "Pathways to commercial wind power in the US, Europe and Japan: The role of demonstration projects and field trials in the innovation process," Energy Policy, Elsevier, vol. 37(9), pages 3580-3595, September.
    3. Samadi, Sascha, 2018. "The experience curve theory and its application in the field of electricity generation technologies – A literature review," Renewable and Sustainable Energy Reviews, Elsevier, vol. 82(P3), pages 2346-2364.
    4. Kumbaroglu, Gürkan & Madlener, Reinhard & Demirel, Mustafa, 2008. "A real options evaluation model for the diffusion prospects of new renewable power generation technologies," Energy Economics, Elsevier, vol. 30(4), pages 1882-1908, July.
    5. Williams, Eric & Hittinger, Eric & Carvalho, Rexon & Williams, Ryan, 2017. "Wind power costs expected to decrease due to technological progress," Energy Policy, Elsevier, vol. 106(C), pages 427-435.
    6. Allan, Grant & Gilmartin, Michelle & McGregor, Peter & Swales, Kim, 2011. "Levelised costs of Wave and Tidal energy in the UK: Cost competitiveness and the importance of "banded" Renewables Obligation Certificates," Energy Policy, Elsevier, vol. 39(1), pages 23-39, January.
    7. Kahouli-Brahmi, Sondes, 2009. "Testing for the presence of some features of increasing returns to adoption factors in energy system dynamics: An analysis via the learning curve approach," Ecological Economics, Elsevier, vol. 68(4), pages 1195-1212, February.
    8. Reinhard Haas & Marlene Sayer & Amela Ajanovic & Hans Auer, 2023. "Technological learning: Lessons learned on energy technologies," Wiley Interdisciplinary Reviews: Energy and Environment, Wiley Blackwell, vol. 12(2), March.
    9. Lindman, Åsa & Söderholm, Patrik, 2012. "Wind power learning rates: A conceptual review and meta-analysis," Energy Economics, Elsevier, vol. 34(3), pages 754-761.
    10. Kahouli, Sondès, 2011. "Effects of technological learning and uranium price on nuclear cost: Preliminary insights from a multiple factors learning curve and uranium market modeling," Energy Economics, Elsevier, vol. 33(5), pages 840-852, September.
    11. Reichenbach, Johanna & Requate, Till, 2012. "Subsidies for renewable energies in the presence of learning effects and market power," Resource and Energy Economics, Elsevier, vol. 34(2), pages 236-254.
    12. Clas‐Otto Wene, 2016. "Future energy system development depends on past learning opportunities," Wiley Interdisciplinary Reviews: Energy and Environment, Wiley Blackwell, vol. 5(1), pages 16-32, January.
    13. Candelise, Chiara & Winskel, Mark & Gross, Robert J.K., 2013. "The dynamics of solar PV costs and prices as a challenge for technology forecasting," Renewable and Sustainable Energy Reviews, Elsevier, vol. 26(C), pages 96-107.
    14. Wu, X.D. & Yang, Q. & Chen, G.Q. & Hayat, T. & Alsaedi, A., 2016. "Progress and prospect of CCS in China: Using learning curve to assess the cost-viability of a 2×600MW retrofitted oxyfuel power plant as a case study," Renewable and Sustainable Energy Reviews, Elsevier, vol. 60(C), pages 1274-1285.
    15. Dalton, G.J. & Alcorn, R. & Lewis, T., 2012. "A 10 year installation program for wave energy in Ireland: A case study sensitivity analysis on financial returns," Renewable Energy, Elsevier, vol. 40(1), pages 80-89.
    16. Nakata, Toshihiko & Sato, Takemi & Wang, Hao & Kusunoki, Tomoya & Furubayashi, Takaaki, 2011. "Modeling technological learning and its application for clean coal technologies in Japan," Applied Energy, Elsevier, vol. 88(1), pages 330-336, January.
    17. Hayward, Jennifer A. & Graham, Paul W., 2013. "A global and local endogenous experience curve model for projecting future uptake and cost of electricity generation technologies," Energy Economics, Elsevier, vol. 40(C), pages 537-548.
    18. Singh, Anuraag & Triulzi, Giorgio & Magee, Christopher L., 2021. "Technological improvement rate predictions for all technologies: Use of patent data and an extended domain description," Research Policy, Elsevier, vol. 50(9).
    19. Kukkikatte Ramamurthy Rao, Harshadeep & Gemechu, Eskinder & Thakur, Ujwal & Shankar, Karthik & Kumar, Amit, 2021. "Techno-economic assessment of titanium dioxide nanorod-based perovskite solar cells: From lab-scale to large-scale manufacturing," Applied Energy, Elsevier, vol. 298(C).
    20. Bolinger, Mark & Wiser, Ryan, 2009. "Wind power price trends in the United States: Struggling to remain competitive in the face of strong growth," Energy Policy, Elsevier, vol. 37(3), pages 1061-1071, March.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:enepol:v:38:y:2010:i:11:p:7508-7511. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/enpol .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.