Question: take a look at the data and help me make the graph pls using excel You are given the following data from a study comparing

take a look at the data and help me make the graph pls using excel

You are given the following data from a study comparing the length of leaves based on their exposure to sunlight. One set of data (Sun leaves) was gathered from leaves that were exposed to direct sunlight for at least 6 hours per day. The other set of data (Shade leaves) was gathered from leaves that were exposed to direct sunlight for less than 1 hour per day. Calculate the descriptive statistics (mean, variance, standard deviation) for each population and complete a t-test to compare the populations. Use this worksheet to guide your calculations. Sun leaves (7 = 10) Shade leaves (7 = 10) Measurements |4 (x x) Bo (xx)? Measurements (x x) (x x)? 10.5 10.5-11.58= LF 14.1 -0.4 0.16 -1.08 9.8 9.8-11.58= 3.17 15.5 1 1 -1.78 23 0.72 0.52 16.6 2.1 44] 11.8 0.22 0.05 15.6 1.1 1.21 Ly 0.12 0.014 13.8 0.7 0.49 11.2 -0.38 0.14 10.3 -4.2 17.64 113 -0.28 0.08 12.7 -1.8 3.24 12:2 0.62 0.38 15.8 13 1.69 8.8 -2.78 7.73 17.1 2.6 .76 16.2 4.62 21.34 135 -l 1 x: 11.58 =:34.6 X:14.5 37.6 Variance = 3.84 Variance = 4.18 Description of Columns: The columns are intermediate steps for calculating the variance. Remember that variance is a measure of dispersion of data, meanimg that it measures how close all measurements are to the mean of the sample or population. A. (xx) : This column is the difference between each measurement and the mean value. In essence, this is the basis of variance. However, because the average and sum of these values will always be zero, we cannot use these values as they are to give a picture of dispersion. This value has little value in characterizing the population but is an important intermediate step in calculating variance. B. (xx)?: After calculating the difference between each measurement and the mean of the population/sample, you will enter the square of the difference for each measurement in this column. This step allows us to characterize the difference between a measurement and the mean value regardless of ifthe measurement is large or smaller than the mean. C. : This is the sum of column B ((x x)?) and is called the sum of squares. This is the numerator in the equation to calculate variance of a sample /population

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!