When Excel displays the Data Analysis dialog box, select the Regression tool from the Analysis Tools list and then click OK. To perform regression analysis by using the Data Analysis add-in, do the following: Tell Excel that you want to join the big leagues by clicking the Data Analysis command button on the Data tab. The 20 functions are: ANOVA: Single Factor. The App's Task Pane input fields and worksheet output will be very familiar to Excel Analysis ToolPak users. The App provides all 19 interactive functions included in the Excel Analysis ToolPak, plus a 20th function often requested by users, logistic regression.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |