How to use equation function to draw in Excel can first input a group of independent variables, and then get the function value through the formula. Just insert two lines of data into the icon as the data source, which is suitable for all functional equations that can write formulas. The specific steps are as follows:
1. Take the quadratic function Y = 0.5x 2+2x+3.5 as an example, write the coefficients A, B and C respectively for easy modification, and enter the value of the independent variable X, from-10 to10;
2. Enter the formula "= $ E $2 * B4 * B4+$ F $2 * $ B $4+G2" for the quadratic function in cell B5;
3. After the formula is entered, press Enter to get the calculation result;
4. Place the mouse in the lower right corner of B5 cell and drag the fill handle to get all the corresponding Y values;
5. select all the values in the x and y lines, click insert > scatter plot, and select scatter plot with smooth lines;
6. Get the quadratic function image directly, and the effect is as follows.
What good-looking mathematical function image software are there? Mathematical function image software;
1, origin
The official version of ORIGIN drawing software is a powerful function drawing tool, which can help users draw various function diagrams easily and make the teaching of functions easier.
2. Fax map
FXGraph official edition is a simple and practical professional function drawing software, which can help users draw mathematical function diagrams easily and help students understand and master the relationship between functions.
3. Cartographer and papermaker
GraphPaperMaker official edition is a functional drawing software with simple interface and convenient operation. Users can automatically generate images by inputting related functional diagrams, which can meet users' requirements for drawing various functions.