Statistics tutorial

MULTIPLE REGRESSION ANALYSIS Question: Along the elevational gradient we surveyed, what factor most limits the growth of ponderosa pines? 1. State the three hypotheses your group tested. Include with your lab report 2. Using Microsoft Excel, provide descriptive statistics (mean, variance, standard deviation) for the dependent variable (growth rate) and the three independent variables we examined (density, DBH, and elevation). Use standard standard deviation for mean variance deviation regression Ponderosa growth rate Ponderosa density DBH Elevation Calculate these values and include them with your lab report To calculate descriptive statistics in Excel: a. Click the View tab. Verify the following are checked: 1) Toolbars: Standard and Formatting. 2) Formula Bar. 3) Status Bar. b. Highlight a cell below the data. c. On the Standard toolbar, click f . xd. In the Paste Function menu, choose Statistical: AVERAGE and highlight the cells that contain the data. Alternatively, in a cell below the data type the following: =AVERAGE(data range). Repeat for variance (VAR), standard deviation (STDEV), and sample size (COUNT). e. Standard error (SE) is a useful statistic that can be used to compare sampling error between variables, populations, data sets, etc. However, Excel doesn’t have a function that allows you to calculate standard error directly. To calculate SE type the following in a cell below the data: ...