# UMass Amherst KIN 460 - Lab 1 Fall 18 (5 pages)

Previewing pages*1, 2*of 5 page document

**View the full content.**## Lab 1 Fall 18

Previewing pages
*1, 2*
of
actual document.

**View the full content.**View Full Document

## Lab 1 Fall 18

0 0 75 views

- Pages:
- 5
- School:
- University of Massachusetts Amherst
- Course:
- Kin 460 - Motor Control

**Unformatted text preview:**

Excel 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 type Excel 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 A 350 300 Time ms 250 200 150 100 50 0 reflex time simple rt complex rt reflex time simple rt complex rt B 350 300 Time ms 250 200 150 100 50 0 Group Mean Subject 1 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 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 Excel 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 individual data points connected by smooth lines 3 Both graphs should have labeled axes x axis Center of Pressure ML y axis Center of Pressure AP 4 Graph 1 On subject one s graph change the x axis range to 0 032 to 0 022 and y axis range to 0 04 to 0 1 Make sure that the axes cross in the upper right corner of the graph 5 Graph 2 On subject two s graph change the x axis range to 0 26 to 0 268 and yaxis range to 22 to 235 a Make sure …

View Full Document