If you want to do a simulation with your chosen sources, all you do is add all the sine sources together. I used Vmag and Time in milliseconds to create the graph. it looked more wibbly wobbly then supposed to. so break this 1millisecond into 50 parts(arbitrary number) then use the first formula : Vsin(2(pi)ft) with "t" being each increment. The frequency of the fundamental is 1kHz. my lecturer was talking about creating each wave form, so the fundamental first, create a bunch of values that will show a sine wave. I have this formula: Vsin(2(pi)ft) + v/3sin(6(pi)ft) + v/5sin(10(pi)ft) and so on for about ten harmonics. I cant get this to export to my version of excel at the moment but it puts all the values into a spreadsheet.įrom there I have to create sine waves of the fundamental and odd harmonics to make up a square wave. Go to simulate > analysis > fourier and show the harmonics and values I have to use a circuit in multisim to create a square wave You can use the Layout and Design tools to tweak the labels and style of the graphic.I have another assignment for my course. Excel will generate a nice graph of f(x) over the specified domain.
(Step 8) Almost done! To make a graph with the x and f(x) data pairs, highlight all of the cells, click "Insert," choose the Scatter plot group, and then choose the graph style with curves. Watch as Excel magically populates Column B with the values of the function. Click on the tiny square in the lower right-hand corner of the highlight box, and drag it down the length of Column B, ending at cell B22. (Step 7) To apply this function to the rest of Column B, first highlight cell B2. If you click on another cell, the value of f(0) will appear in cell B2. For the function f(x) = e x/2 - 3x, enter "=EXP(x/2)-x*3" without the quotation marks. (Step 6) In cell B2, enter the function using Excel's syntax for math formulas. (The name "x" may already be filled in for you.) Click it, and enter "x" as the name in the dialog box. Look for the section called either "Define Name" or "Name Manager" (depending on your version of Excel).
(Step 5) Now highlight Column A and go to the Formulas tab. Excel's Autofill feature will supply the rest of the values. Click on the tiny square in the lower right-hand corner of the highlight box, and drag it down the length of Column A, stopping when you hit cell A22. Simply enter 0, 0.5, and 1 and then highlight the three cells. There is a shortcut alternative to typing all of these x values by hand. For our example, we would fill Column A with 0, 0.5, 1, 1.5. (Step 4) Fill in the rest of x values in Column A using the appropriate increment size. For the function f(x) = e x/2 - 3x, we can use an increment size of 0.5. If your step size is too coarse, the graph's shape will be inaccurate.įor instance, if you are plotting f(x) = sin(x) from 0 to pi, you should divide the interval into at least 10 pieces, that is, use an increment size of pi/10. Excel does not actually plot the true curve of a function, but rather interpolates curves between adjacent points. It is important to choose an increment size that is small enough to capture the important features of the graph. (Step 3) Now determine the increment size for the x values. For example, if you are graphing the function f(x) = e x/2 - 3x over the interval, you would enter 0 in cell A2. Enter the left endpoint of the domain in cell A2. (Step 2) Next, determine the domain of the function's graph, that is, the range of x values over which you will plot the function. These will serve as labels for the independent and dependent variables. (Step 1) Begin by opening up a new Excel workbook and entering "x" in cell A1 and "f(x)" in cell B1. Furthermore, Excel is a very common application, so sharing files with others is a breeze. Some graphing calculators don't even have ports for connecting to computers. For example, if you need to print the graph and you don't have Mathematica installed, it is easier to use Excel than to connect the graphing calculator to your computer.
However, in some cases it may be more convenient to graph equations of the form y = f(x) using MS Excel.
HOW TO PLOT A GRAPH IN EXCEL USING FORMULA SOFTWARE
The most popular tools for this purpose are the TI-83/84 calculators and the software program Mathematica. Most math students and scientists use either a graphing calculator or mathematical modeling program to plot graphs of functions.
0 kommentar(er)
