Create a new Microsoft Excel database in which you will be able to enter the following variables:Subject identification (ID) numberAgeSexHeightYear in collegeName each variable in the datafile. All data to be manipulated (everything except the participant ID number) must be entered as numeric values.Create data for forty hypothetical students who are undergraduates in college, making sure you have five males and five females in each year (freshman, sophomore, junior, and senior):Subject ID number (You will be required to provide this yourself. For example, subject 1 is P1; subject 2 is P2, and so forth. This should be entered as alphanumeric in your database since it is not a variable we will use in any of our data analyses).Age: Be sure to get variability in your data. Not all students in any given year are of the same age. Be realistic with your data.Sex: Assign a number for each of Male and Female and provide clarification as to what each number refers to as demonstrated in your lectures.Height (convert to inches; 5 feet 3 inches = [12 * 5] + 3 = 63). Enter the number 63, not the formula.Year in college (freshman, sophomore, junior, or senior). Assign a number for each year and provide clarification as to what each number refers to as demonstrated in your lectures.Enter the complete dataset into the Microsoft Excel worksheetI am female I am 5’3 I am 28I am a junior I lost my id so you can make up an ID number

Instructions:Your initial post will include five screen shots and four sentences (one sentence for each of the last four screen shots).Screenshot #1Flip a coin. Your flip will determine the trigonometric function you will be working with for your initial post.Heads = use sineTails = use cosineFor example, if I flipped a tail, my initial post would focus on the trigonometric function cosine.Graph your function and take a screen shot of the graph.You can use any program you like. Here is one option: Illuminations: Trigonometric Graphing.Please refer to the discussion board on how to take screen shots.Graph  y=cos(x) ory=sin(x) Your subject line will be cos(x) or sin(x) depending on your flip.Screenshot #2Now, consider this equation. The equation used will depend on your original coin toss.y=Acos(B(x−C))+D y=Asin(B(x−C))+DUsing the Illuminations: Trigonometric Graphing site, figure out what happens when you make A larger (try 1, 2, 3, and 4).Explain in one sentence what happens as you make A larger and tell us what this transformation is called.Then pick an interesting large number (something larger than 1), and graph y=Acos(x)  or  y=Asin(x)The equation used will depend on your original coin toss.Take a screen shot of your graph and post the equation.Screenshot #3Using the Illuminations: Trigonometric Graphing site, figure out what happens when you make B larger (try 1, 2, 3, and 4) and tell us what this transformation is called.Explain in one sentence what happens as you make B larger.Then pick an interesting large number (something larger than 1), and graph y=cos(Bx)  or  y=sin(Bx)The equation used will depend on your original coin toss.Take a screen shot of your graph and post the equation.Screenshot #4Using the Illuminations: Trigonometric Graphing site, figure out what happens when you make C larger (try 0, 30 degrees, 45 degrees, and 60 degrees) and tell us what this transformation is called.Explain in one sentence what happens as you make C larger.Then pick an interesting large number (something larger than 0), and graph y=cos(x+C) y=sin(x+C)The equation used will depend on your original coin toss.Take a screen shot of your graph and post the equation.Screenshot #5Using the Illuminations: Trigonometric Graphing site, figure out what happens when you make D larger (try 0, 1, 2, and 3) and tell us what this transformation is called.Explain in one sentence what happens as you make D largerThen pick an interesting large number (something larger than 0), and graph y=cos(x)+D or y=sin(x)+DThe equation used will depend on your original coin toss.Take a screen shot of your graph and post the equation.Response Post:Pick another student’s post who flipped their coin opposite of you.For my example, I would pick someone who flipped heads, or has sin(x) in their subject line.Review the other student’s post.Does each of their answers make sense to you?Explain in at least two sentences why or why not their post makes sense.Please be respectful of other students’ work.Pick two of their transformations (meaning A, B, C, or D and the corresponding graph).What happens when you change the transformation from a positive value to a negative value? For example, if you picked A and D, what happens when you change equations to: y=−Acos(x)  or y=−Asin(x)Remember, find the Trig function opposite of yours.What happens when you change the equation to: y=cos(x)−D  or y=sin(x)−DPost a screen shot of both transformations together: y=−Acos(x)−D  or  y=−Asin(x)−D