How do you perform curve-fitting in Excel?
What will be an ideal response?
Use the following procedure to complete a curve-fit with Excel:
1. Right-click on any of the plotted data points on a graph to bring up a menu.
2. Select the Add Trendline option from the menu.
3. The next menu will bring up six different function-type options to fit the data: (i) Linear, (ii) Logarithmic, (iii) Polynomial, (iv) Power, (v) Exponential, and (vi) Moving Average. Choose one function type and any additional functional information (like the order of the polynomial).
4. In the Options menu, choose to Display the equation and/or the R2 quality factor of the fit on the graph.
You might also like to view...
What is the purpose of a breaker?
What will be an ideal response?
The dairy breed that produces milk with the highest fat content is the _____
a. Jersey c. Brown Swiss b. Guernsey d. Holstein
The points a, b, c, d, and e on the 60 percent component B line, give some temperatures through which a slowly cooled alloy containing 60 percent B, will pass on freezing from a liquid to a solid. Identify the phase or phases, and the amount of each that should exist in the microstructure at each indicated point.
A standard respirator with a HEPA filter can be used for very short exposure to fumes from welding _____
a. zinc or copper b. stainless steel c. high-carbon steel d. titanium