Perform nonlinear regression analysis of a set - polynomial, Basic Statistics

Assignment Help:

This assignment is designed to compare performance between Matlab and Excel for performing nonlinear regression analysis of a set of data. There are two data sets in the accompanying Excel spreadsheet, the cell migration data, and a noisy sine wave.  The first set was collected by Dr. Cho, and represents the X and Y coordinates of a cell as it migrates across a substrate in culture.  Your job is to find an equation that describes the position of the cell as a function of time.  Use a polynomial of the lowest order possible such that R2(r squared)> 0.95.  Do this in Excel and in Matlab, and hand in both plots along with your equations and R2(r squared)values for each determination.

Also fit a polynomial to the noisy sine wave.  Find the polynomial of lowest order such that R2(r squared)> 0.95.  Do this with both Excel and Matlab.Hand in all four plots, all four equations, and all four R2values, on no more than two sheets of paper.


Related Discussions:- Perform nonlinear regression analysis of a set - polynomial

Discrete event simulation output analysis, 1. Name several entities, attrib...

1. Name several entities, attributes, activities, events, and state variables for the following systems: (a) A cafeteria (b) A grocery store (c) A laundromat (d) A fast

Standard deviation, how do i calculate standard deviation for a frequency d...

how do i calculate standard deviation for a frequency distribution

Budgeted accounts, Budgeted accounts Accounts that are theme to the misapp...

Budgeted accounts Accounts that are theme to the misappropriation or sometimes to appropriation and/or allotment process. Refer to APPROPRIATION and portion.

Bond calculation, Calculate the original price of the bond. Bonds were issu...

Calculate the original price of the bond. Bonds were issued at $200,000 of x% ten-year term bond at an effective annual interest rate (market rate) of x%. The bonds pay interest se

What is an irrevocable letter of credit?, What is an irrevocable letter of ...

What is an irrevocable letter of credit? A permanent mail of credit score is a financial instrument used by banks to guarantee a customer's obligations to a supplier. It is perm

Find the correlation coefficient, We find the correlation coefficient and p...

We find the correlation coefficient and plot the scatter plot using excel as follows:   Time in Waiting Room      Heart Rate

Characteristics , Mention the characteristics of Statistics. Explain any tw...

Mention the characteristics of Statistics. Explain any two applications of Statistics

Hedging , how to record a new hedging in your books

how to record a new hedging in your books

Cyclical variation, what is the basic difference between seasonal variation...

what is the basic difference between seasonal variation and cyclical variation

Cost accounting, To bring Mr. Kid to justie, the company must reconstruct i...

To bring Mr. Kid to justie, the company must reconstruct its activities for June. You have been assigned to perform the task of reconstruc*ion. After interviewing selected employee

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd