Data Regression with Excel

Main.ExcelDataRegression History

Hide minor edits - Show changes to output

August 13, 2020, at 01:02 PM by 136.36.211.159 -
Changed lines 23-25 from:
Both regression tutorials can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.
to:
Both regression tutorials can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.

There is additional information on regression in the [[https://apmonitor.github.io/data_science|Data Science online course]]
.
June 21, 2020, at 04:05 AM by 136.36.211.159 -
Changed lines 23-42 from:
Both regression tutorials can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.

----

(:html:)
 <div id="disqus_thread"></div>
    <script type="text/javascript">
        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
        var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

        /* * * DON'T EDIT BELOW THIS LINE * * */
        (function() {
            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
            dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';
            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
        })();
    </script>
    <noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)
to:
Both regression tutorials can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.
August 22, 2015, at 09:46 PM by 174.148.220.158 -
Changed line 20 from:
<iframe width="560" height="315" src="https://www.youtube.com/embed/ke8oVXsD4UM" frameborder="0" allowfullscreen></iframe>
to:
<iframe width="560" height="315" src="https://www.youtube.com/embed/DOCzyB8zj-8" frameborder="0" allowfullscreen></iframe>
August 22, 2015, at 03:47 AM by 174.148.85.243 -
Added lines 16-17:

* [[Attach:Excel_nonlinear_regression.zip|Excel Nonlinear Regression Example Spreadsheet]]
August 22, 2015, at 03:43 AM by 174.148.85.243 -
Added lines 9-10:
!!!!Linear and Polynomial Regression
Changed lines 15-21 from:
This regression tutorial can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.
to:
!!!!Nonlinear Regression

(:html:)
<iframe width="560" height="315" src="https://www.youtube.com/embed/ke8oVXsD4UM" frameborder="0" allowfullscreen></iframe>
(:htmlend:)

Both regression tutorials
can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.
August 21, 2015, at 01:30 AM by 10.10.146.39 -
Changed lines 5-6 from:
!!!!Python Data Regression
to:
!!!!Excel Data Regression
Changed line 10 from:
<iframe width="560" height="315" src="https://www.youtube.com/embed/ro5ftxuD6is" frameborder="0" allowfullscreen></iframe>
to:
<iframe width="560" height="315" src="https://www.youtube.com/embed/ke8oVXsD4UM" frameborder="0" allowfullscreen></iframe>
August 21, 2015, at 01:15 AM by 10.10.146.39 -
Added lines 1-32:
(:title Data Regression with Excel:)
(:keywords data regression, Excel, spreadsheet, nonlinear, polynomial, linear regression, university course:)
(:description Data Regression with Excel - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

!!!!Python Data Regression

A frequent activity for scientists and engineers is to develop correlations from data. By importing the data into Excel, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. This tutorial demonstrates how to create a linear or polynomial functions that best approximate the data trend, plot the results, and perform a basic statistical analysis.

(:html:)
<iframe width="560" height="315" src="https://www.youtube.com/embed/ro5ftxuD6is" frameborder="0" allowfullscreen></iframe>
(:htmlend:)

This regression tutorial can also be completed with [[Main/PythonDataRegression|Python]] and [[Main/MatlabDataRegression|Matlab]]. Click on the appropriate link for additional information.

----

(:html:)
 <div id="disqus_thread"></div>
    <script type="text/javascript">
        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
        var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

        /* * * DON'T EDIT BELOW THIS LINE * * */
        (function() {
            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
            dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';
            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
        })();
    </script>
    <noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)