Statistical Analysis of the Relationship Between the Two Variables Report

Exclusively available on Available only on IvyPanda® Made by Human No AI

Abstract

In the measurement of any relationship between variables, it is essential to use a correlation statistic to determine the strength of relationship between them. A data from three studies carried out on a given sample of population was obtained and analyzed by using both SPSS and Excel.

The mean, standard deviation, range and F-test were obtained from three groups of samples in order to analyze the two variables X and Y. A one sample t-test was obtained at a 95% confidence interval after which the results were interpreted. ANOVA was also conducted in order to provide the value of F-score for interpretation purposes. The results had shown a lower standard deviation for a large sample size implying that a large sample size should be used to test the relationship between variables since it affects reduces variability of data.

Introduction

This report is aimed at obtaining a statistical analysis of the relationship between the two variables X and Y before determining the effect of changing sample size on variability. The X variable was the independent variable and the Y variable was the dependent variable.

It will also explain the significance of F-score as obtained by ANOVA using SPSS. Three groups have been obtained from different sample sizes to ensure validity and reliability of results obtained in making a conclusion. The experiment involved the selection of various random variables in groups of 30 members for appropriate description and presentation of results.

To determine the measurements for variability, the measures of range, standard deviation, variance and median were used to provide useful information for interpretation.

Methods

The experiment was been performed on random variables of X and Y obtained from a certain population. First, a sample size of 15 variables was obtained and recorded as group 1, second was group 2 with sample size of 60 and lastly group 3 with sample size of 90. The correlation for 30 variables of each group of sample was recorded for the study.

In total, three groups of samples were obtained in order to ensure reliability of the results. Correlation was then calculated for each group to determine the relationship between X and Y. The correlation coefficient obtained from each group was then recorded for analysis.

ANOVA was also conducted to evaluate whether the average score was equal or different between the means of groups (Adivia, 2010, par.3).

Results

Degree of Freedom

For each the studies carried out, the number of data entries n is equal to 30.Therefore it means that the degree of freedom DF=n-1 is DF = 30-1 = 29

Critical Values

Correlation #1

One-Sample Statistics

NMeanStd. DeviationStd. Error Mean
X3052.2730.0075.478
Y3047.2330.6025.587

One-Sample Test

Test Value = 0
TdfSig. (2-tailed)Mean Difference95% Confidence Interval of the Difference
LowerUpper
X9.54029.00052.2741.0663.47
Y8.45429.00047.2335.8158.66

Correlation #2

One-Sample Statistics

NMeanStd. DeviationStd. Error Mean
X3058.1327.4745.016
Y3049.6728.7795.254

One-Sample Test

Test Value = 0
TdfSig. (2-tailed)Mean Difference95% Confidence Interval of the Difference
LowerUpper
X11.59029.00058.1347.8768.39
Y9.45329.00049.6738.9260.41

Correlation #3 One-Sample Statistics

NMeanStd. DeviationStd. Error Mean
X3041.5727.8595.086
Y3067.1723.9154.366

One-Sample Test

Test Value = 0
TdfSig. (2-tailed)Mean Difference95% Confidence Interval of the Difference
LowerUpper
X8.17229.00041.5731.1651.97
Y15.38329.00067.1758.2476.10

Using SPSS, one-tail and critical two-tail t values were obtained using a one sample t test for each study and the results were as follows:

Study Group #1: 9.540 and 8.454

Study Group #2: 11.590 and 9.453

Study Group #3: 8.172 and 15.383

Standard Deviation

In SPSS the standard deviation for each study was obtained using one sample t test and the results were as follows:

σ1: 30.602

σ2: 28.779

σ3: 23.915

Range of Variation

Using SPS, the range of variation was obtained by using Analyze>Descriptive Statistics>Descriptives>Range

Descriptive Statistics
NRangeMinimumMaximum
Group 13096298
Group 23092395
Group 33081119

Correlation Mean

In SPSS the mean correlation for each study was obtained using one sample t test and the results were provided as follows:

Group #1=0.022

Group #2=0.122

Group #3= -0.128

ANOVA Results Group 1 ANOVA Y

Sum of SquaresDfMean SquareFSig.
Between Groups24368.36725974.7351.398.411
Within Groups2789.0004697.250
Total27157.36729

From the results obtained in the above ANOVA table, the F-score of 1.398 is greater than the significance value of the F test in the Group 1 ANOVA table which is 0.411. We reject the null hypothesis and conclude that average assessment score differs across the groups of variable X and Y.

Group 2 ANOVA Y

Sum of SquaresDfMean SquareFSig.
Between Groups22209.66723965.6383.203.076
Within Groups1809.0006301.500
Total24018.66729

From the results obtained in the Group 2 ANOVA table, the F-score 3.203 is less than significance value of the F test in the table which is 0.76. We reject the null hypothesis and conclude that average assessment score is different across the groups of variable X and Y

Group 3 ANOVA Y

Sum of SquaresDfMean SquareFSig.
Between Groups14144.16726544.006.668.761
Within Groups2442.0003814.000
Total16586.16729

From the results obtained in the Group 3 ANOVA table, the F-score 0.668 is less than significance value of the F test in the Group 3 ANOVA table which is 0.761. We accept the null hypothesis and conclude that average assessment is equal across the groups of variable X and Y

Affects of Changes Sample Size on Variability

When the sample size was small as given by Group #1, the standard deviation was 30.602, while Group #2 and #3 had 28.779 and 23.915 respectively. This shows that the standard deviation decreases with the increase in sample size.

The sample size selected for any population affects the confidence interval of the data. If the sampling size is increased, the required confidence interval will also increase. The reason why the confidence interval increases is because of many variables that reduce the variance from one variable to another (Ramsey, 2009, par. 2).

From the results obtained earlier in the ANOVA table, it is clear that Group #1 which had started with a smaller sample size had shown the average assessment scores was different across the groups within the significance value of 0.411. As the samples size was increased, there was a no much difference in scores between the variables X and Y as shown by Group #2 and #3.

The correlation mean obtained for the three groups increased with the increase in sample size. For example, Group # 1 had 0.022 while group #3 had -0.128. The strength of relationship between the two variables decreases with increase in sample size.

Conclusion

Based on the results obtained above, it can be concluded that a change in the sample size has a significant effect on the variability of data. Therefore, it is good to choose a larger sample size in order to correctly obtain good results for in data analysis.

References

Adivia, J. (2010). One-way ANOVA using SPSS. Retrieved from

Ramseh, G. (2009). Introduction to confidence intervals. Web.

More related papers Related Essay Examples
Cite This paper
You're welcome to use this sample in your assignment. Be sure to cite it correctly

Reference

IvyPanda. (2019, April 9). Statistical Analysis of the Relationship Between the Two Variables. https://ivypanda.com/essays/anova-report/

Work Cited

"Statistical Analysis of the Relationship Between the Two Variables." IvyPanda, 9 Apr. 2019, ivypanda.com/essays/anova-report/.

References

IvyPanda. (2019) 'Statistical Analysis of the Relationship Between the Two Variables'. 9 April.

References

IvyPanda. 2019. "Statistical Analysis of the Relationship Between the Two Variables." April 9, 2019. https://ivypanda.com/essays/anova-report/.

1. IvyPanda. "Statistical Analysis of the Relationship Between the Two Variables." April 9, 2019. https://ivypanda.com/essays/anova-report/.


Bibliography


IvyPanda. "Statistical Analysis of the Relationship Between the Two Variables." April 9, 2019. https://ivypanda.com/essays/anova-report/.

If, for any reason, you believe that this content should not be published on our website, please request its removal.
Updated:
This academic paper example has been carefully picked, checked and refined by our editorial team.
No AI was involved: only quilified experts contributed.
You are free to use it for the following purposes:
  • To find inspiration for your paper and overcome writer’s block
  • As a source of information (ensure proper referencing)
  • As a template for you assignment
1 / 1