Excel in Excel®!. Issue 5 (1st May 2017)

• Record Type: Journal Article
• Authors: Ayer, Ganesh
• Is Part Of: Energy engineering. Volume 114:Issue 5(2017)
• Page Start: 8
• Page End: 17
• Publication Date: 2017-05-01
• Subjects: Power (Mechanics) -- Periodicals; 621.04205
• DOI: 10.1080/01998595.2017.11882306
• Languages: English
• ISSNs: 0199-8595

Abstract

ABSTRACT: Regression analysis is a statistical technique that can be used to identify and analyze the relationship between one or more independent variables and a dependent variable. In plain language, regression basically answers the following two questions: Can we get an equation that relates the variables? Can we assess the strength of the relationship? In short, the goal in regression analysis is to identify a function of the independent variables that adequately accounts for the behavior of the dependent variable. In this article, we will learn about the tools and methods available in Excel for performing regression analysis. We will confine our discussion to linear regression as this is what you will frequently see in energy engineering calculations.