LAB 1: Creating graphs in Microsoft excelIntroductionInstructionsGraphingFigure 1: Reflex and Reaction Time MethodsThe first data set consist of reflex and reaction times for 10 subjects.Figure 2: Center-of-pressure MethodsKinematic Data MethodsABA BExcel graphing KIN 460 – Motor Control Lab Lab 1 LAB 1: Creating graphs in Microsoft excel Introduction In this course you will be required to collect and process large amounts of data, typically in three forms; data that can be expressed using statistics, kinetic data, and kinematic data. Due to the amount of data collected the use of a computer is required. For your lab write-ups you’ll collect, process and graph your data. Your collected data can be processed and graphed using a spreadsheet program (for example Microsoft Excel). For this lab you’ll be given data to graph in Excel. Your write-up will consist of 5 graphs. If you don’t finish all your graphs during lab you can find help for how to create graphs online (use Google). The purpose of a graph is to convey a message: you have something to say that the graph shows. A graph consists of either information or noise. Your message is contained in the graph’s information (such as data points). Noise are objects in the graph that hold no information (such as gridlines) or obscure information. When you create your graph you should always maximize the information (such as choosing an appropriate axis scaling) and reduce noise (remove objects that hold no information). Pointers to improve your overall graphing experience and lab grade when making excel graphs 1. Never use a screen shot of your excel graph in your document. a. Just use copy/paste into word – this enables you to continue to edit the graph in excel b. Hint: make a text box in Word first, then past the graph into the text box for easier placement within the document. 2. Always ensure error bars represent your data a. To do this, you must ensure you are following the proper steps to use the standard deviations you calculated to make your error bars instead of allowing Excel to determine their magnitude 3. Minimize empty space on your graphs a. You will have to adjust your x-axis and sometimes possibly your y-axis limits in order to minimize useless space on the graph 4. Graph TITLES should reflect the overall question of the experiment and/or the relationship that is being demonstrated a. Ex: Your experiment may be testing two-point discrimination with a discrimagon ® tool. The title of the graph should be either “two-point discrimination” or “Mechanosensation – two-point discrimination” and NOT “Discrimagon” 5. Always double check to make sure y-axis and x-axis units and labels match and are appropriate 6. Continuous variables on the x-axis should start at zero and progress in reasonable increments a. Hint: many times if you made a graph in excel and it starts at 1 or another number, you probably used the wrong graph typeExcel graphing KIN 460 – Motor Control Lab Lab 1 b. Hint: you can manually adjust the range and increments to make the graph more readable 7. Minimize the use of grid-lines. Excel automatically puts them in. You rarely need them as they don’t offer much to the information you are conveying (see NOISE comment above) 8. Your axis labels should never be covered by lines or data points 9. Be sure to edit line or marker thickness and color to improve clarity 10. When making and editing your graphs in Word, please be sure to adjust the size and position of the graphs to maximize clarity and minimize wasted space. a. This includes graphs that are either too big or too small 11. NEVER submit your lab reports to Moodle as a Word document. ALWAYS save as a PDF first, check to ensure no formatting has changed, then submit. Otherwise formatting will likely change and it will be difficult to read your graphs and you will lose points. Instructions Please split up into small groups and work on this assignment together. I will be here to answer questions, but before you ask me anything, please go to the internet and try and solve the problem as a team. You’ll use three different data sets for your write-up. Graphing Figure 1: Reflex and Reaction Time Methods The first data set consist of reflex and reaction times for 10 subjects. Create two graphs: Graph A - Column graph: Graph the mean reflex and reaction times with error bars that represents standard deviations. This data represents the timing of a reflex, simple reaction time and complex reaction time test. 1. Go to the Reflex/RT tab in Excel. 2. Calculate the average and standard deviation for each column of data. 3. Plot the data using a column graph with the x-axis labeled according to the appropriate categories (reflex time, simple reaction time and complex reaction time) and the y-axis labeled time (ms). 4. Place error bars over each bar representing the standard deviation (both directions, with caps). 5. Your figure should look exactly like the one below. 6. Make your figure colors in dark grey and light grey variations so they can be printed in black and white and still be discernable. Graph B - Cluster Column Graph: Graph mean and standard deviation reflex and reaction times compared to the times for a single subject. 1. Repeat the process from graph 1 to re-create your figure (you will need both graphs to turn in) and add data from any single subject you choose as the clustered data. 2. Your figure should look exactly the same as the one below.Excel graphing KIN 460 – Motor Control Lab Lab 1 Figure 2: Center-of-pressure Methods The second data set is center-of-pressure data collected from two subjects while they were standing quietly on a force plate. The data are recorded for 10 seconds at 100 Hz giving 1000 data points. The data are organized in an x-direction and a y-direction. Kinetic COP data represents the net location of all the pressures on the bottom of the feet. A B Figure 1: Reflex and reaction time (A): Group means, N = 10. Error bars are standard deviation. Reflex and reaction time – Cluster data (B): Same as A with a single subject as a comparison. 050100150200250300350reflex time simple rt complex rtTime (ms)050100150200250300350reflex time simple rt complex rtTime (ms)Group Mean Subject 1Excel graphing KIN 460 – Motor Control Lab Lab 1 Graphs A & B: 1. Go to the Kinetic tab in Excel. 2. Graph both data sets as separate scatterplots with the