Automated Data Analysis Using Excel by Bissett Brian D.;

Author:Bissett, Brian D.;
Language: eng
Format: epub
Publisher: CRC Press LLC
Published: 2020-07-26T16:00:00+00:00

A linear regression tool within Excel is a must for any serious researcher. Ideally such a tool would have a GUI which would allow the user to specify the dependent (y) and independent (x) variables. The tool should produce a line graph which contains both the original data and the linearly fitted data as shown in Figure 5.35. The fitted equation and R2 value should be placed on the graph, as well as labels for the title and axes. Finally, a dataset should be generated for the fitted line with the number of points in the generated dataset specified by the user.

Some thought needs to be given as to what the functionality of this new tool should be. The tool should allow multiple fitting sessions. When multiple fitting sessions occur, the graphs and generated datasets should appear on separate and uniquely named Worksheets and charts. The user should be able to specify the following information for the fitting session:

The Ranges of the independent X and dependent Y data to be fitted.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.