How do I graph the Sin of X on Excel?

Question

I also need help in finding the sin of 2x and 3x and 2/x and 4/x.
But I really need help in graphing and what commands to put in.

Answer 1

1) Open MS Exel
2) Type 1 in A1 and 2 in A2
3) Select A1 and A2
4) Click on the black square at the bottom right of the border
5) Drag down until you reach A360
6) Type =SIN(DEGREES(A1)) in B1
7) Type =SIN(DEGREES(A1*2)) in C1
8) Type =SIN(DEGREES(A1*3)) in D1
9) Type =SIN(DEGREES(2/A1)) in E1
10) Type =SIN(DEGREES(4/A1)) in F1
11) Select B1 to F1
12) Click on the black square at the bottom right of the border
13) Drag down until you reach F360
14) Select B1 to F360
15) Click on the Chart Wizard button on the Standard Toolbar
16) Select Line for Chart type
17) Select the most top left box for Chart sub-type
18) Click Next >
19) Click the Series tab
20) Label Series 1 as x
20) Label Series 2 as 2x
20) Label Series 3 as 3x
20) Label Series 4 as 2/x
20) Label Series 5 as 4/x
20) Type in =Sheet1!$A$1:$A$360 for Category (X) axis labels
21) Click Next >
22) Choose As a new sheet
23) Click Finish
24) Magnify the chart as desired by changing the percentage on the Standard Toolbar (max. 400%)

Answer 2

As you probably know, Excel calculates trig functions from radians only, so
Starting with 1 in cell A2, list integers up to any desired value, call it N. The higher your end value, the smoother your curve will be.
In B1 enter "x"
In B2, enter =2*pi()*A2/N
In C2, enter "sinx"
In C2, enter =sin(B2)
In D1, enter "sin2x
In D2, enter =sin(2*B2)
In E1, enter "sin3x
In E2, enter =sin(3*B2)
In F1, enter "sin(2/x)
In F2, enter =sin(2/B2)
In G1, enter "sin(4/x)
In G2, enter =sin(4/B2)
Select B2 through G2.
Move your cursor to the lower right-hand corner of G2. It will change to a ┼, and Fill will appear. Left-click and drag down until you have N rows.
If you want to display all the graphs at the same time, select B1 to G(N).
Click on the graph icon on the tool bar. The Chart Wizard will walk you through setting up the chart and show sample displays. When you click Finish (or Done) your chart will appear in a new window.

If you want individual graphs you will have to rearrange your columns so you have an x column and a function column.

Answer 3

try this: click on cell A1 and type pi
click on B1 and type =atan(1.0)*4
click on A2 and type x
on A3 and type 0
on A4 and type =A3+$B$1/32
on B3 and type sin(x)
on B4 and type sin(A4)

now you should be able to highlight cells A4 and B4 with your mouse and click and hold in the small square at the bottom right hand side of the selected cells. When you drag this square down the rest of your table is populated (drag it down to row 67). If you now select from the headings x and sin(x) down to row 67 then click on your graph icon and select xy scatter plot.

Should work.