Data Analysis Overview - Project GUTS数据分析概述项目的勇气.pptVIP

Plotting Data – Activity in Excel Select Data Range Highlight data to be plotted Plotting Data – Activity in Excel Label each data series NEXT - Label Graph and Axis Plotting Data – Activity in Excel Choose where you want the graph to be Get your graph Plotting Data – Extracting from Netlogo Two ways 1st Way: Write code to extract the data you want – see File Output Example in the Code Examples Open file in setup procedure Create a write-to-file procedure Plotting Data – Extracting from Netlogo 2nd way: Extract data from Netlogo graphs Have Netlogo generate graph on Interface page (example on later slide) Create a setup-plot procedure and a do-plot procedure Call the setup-plot procedure in setup procedure Call do-plot procedure in go procedure Plotting Data – Extracting from Netlogo Run model until sufficient data obtained (PC) Right Click on Graph/ (Mac) Control Click on Graph Select Export Choose location and File name - select save Excel File is created – Next Slide Contains all the information in the plot and input parameters used. Contains excess information about the plot (color, pen down, mode, interval…) LET’S DO IT – Open Rabbits Grass Weeds Plotting Data – Extracting from Netlogo This is what You need Statistics Statistics help you Summarize data Describe data Analyze data Hard to describe the difference Between the two data sets Now it is easy to summarize, describe and analyze the data…. The blue and the pink data have the Same AVERAGE value (mean) but the blue data is “NOISIER” (greater standard deviation). Therefore… Statistics – How to Calculate in Excel +,-,*,/ used for addition, subtraction, multiplication and division. Each cell has a label based on the column and row. Use cells to perform calculations instead of numbers. Example : =(A4+B4)/C4 Perform calculations on an entire column - copy and paste the equation .Warning : this changes the cell number for each line. Fix a specific cell - use the $ symbol, example (A4+B4