![frontline solver linear regression frontline solver linear regression](https://utw11041.utweb.utexas.edu/ORMM/computation/unit/mp_add/subunits/lp_add/lp_add.img/jensen_sol.jpg)
For example, using linear regression, the crime rate of a state can be explained as a function of demographic factors such as population, education, or male-to-female ratio.
#Frontline solver linear regression generator#
The Add-on's Random Number Generation function uses the well-known Mersenne Twister algorithm, also used in Excel's RAND built-in function the Excel Analysis ToolPak uses an older random number generator algorithm. Multiple Linear Regression is performed on a data set either to predict the response variable based on the predictor variable, or to study the relationship between the response variable and predictor variables. Once the Add-on is downloaded into your browser, it doesn't communicate with other servers. The XLMiner Analysis ToolPak Add-on works entirely within your browser on your PC or other device, reading data you select in your Excel workbook, and writing statistical summaries and drawing charts that appear only in your workbook.
![frontline solver linear regression frontline solver linear regression](https://ars.els-cdn.com/content/image/1-s2.0-S0169743917305956-gr2.jpg)
t-Test: Two-Sample Assuming Unequal Variances.t-Test: Two-Sample Assuming Equal Variances.Results will generally match the Excel Analysis ToolPak, as seen in many textbooks, screen images and videos. The Add-on's Task Pane input fields and worksheet output will be very familiar to Excel Analysis ToolPak users. The information in this dataset was gathered by the US Census Bureau from census tracts within the Boston area. The example dataset below was taken from the well-known Boston housing dataset. The Add-on provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression. Linear regression creates a statistical model that can be used to predict the value of a dependent variable based on the value(s) of one more independent variables.
![frontline solver linear regression frontline solver linear regression](https://slidetodoc.com/presentation_image_h/cdd5f15fffca8a8b3b0a6f0fa06f7d3e/image-59.jpg)
With the XLMiner Analysis ToolPak Add-on, you can perform statistical analyses of the same types available in the Analysis ToolPak in desktop Microsoft Excel.