plug in for regression analysis excel mac

This frees up intellectual resources for analyzing the results, rather than agonizing over who and how processed the data, and if any mistakes were made in the process.

StatPlus comes with Excel add-in (StatFi) that transforms Excel into a statistical software package.

Version 5 includes own chart engine (histograms, bars, areas, point-graphs, pies, statistical charts, control charts) and reads StatSoft Statistica documents.

StatPlus allows to perform various forms of analysis - from data transformation and sampling to complex analysis, including as non-parametric and regression analysis, survival analysis, and a wide variety of other methods.

Both versions include standalone spreadsheet and Excel add-in.

Save learning time and costs for your mixed PC and Mac environment.

LD values (LD50ED50 and others), cumulative coefficient calculation.

Report includes: AUC (with confidence intervals), curve coordinates, performance indicators - sensitivity and specificity (with confidence intervals), accuracy, positive and negative predictive values, Youdens J (Youdens index), Precision-Recall plot.

The big question is: is there a relation between Quantity Sold (Output) and Price and Advertising (Input).

In other words: can we predict Quantity Sold if we know Price and Advertising.

These are the explanatory variables (also called independent variables).

The closer to 1, the better the regression line (read on) fits the data.

Delete a variable with a high P-value (greater than 0.05) and rerun the regression until Significance F drops below 0.05.

For example, if price equals 4 and Advertising equals 3000, you might be able to achieve a Quantity Sold of 8536.214 -835.722 4 0.592 3000 6970.

Using the equation, the predicted data point equals 8536.214 -835.722 2 0.592 2800 8523.009, giving a residual of 8500 - 8523.009 -23.009.

Plug In For Regression Analysis Excel Mac