How to get the Excel curve fitting

Source: Internet
Author: User

Enter the experimental data into Excel, two variables of the best two vertical rows.

Select all the data and be careful not to select the text too.

In the menu bar, click Insert, and then select the Drop-down menu under scatter chart.

Choose the type you want from the menu, generally select both the data point and the smooth curve of the scatter plot.

The discovery generated graphics, but there are some problems, such as no axis names, no ticks, and so on.

Open the design in the menu, click the Drop-down menu in the layout of the icon.

You will see icons with many layout types and choose what you need. For example, the layout selected in the figure is a common title, an axis name.

In addition, if linear fitting is needed, the layout shown in the direct selection diagram will give the function expression and relative error directly.

The axes also need to be set: Click on the area near the axis with the mouse, right-click, select Format axis.

This can be set in detail here.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.