Statistics. Grade Point Average and Final Marks Coursework

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

Introduction

In this project, we are interested in determining if there is any relationship between the dependent variable (GPA) and the independent variables (final marks and the total). In this study, we will use the Pearson correlation coefficient and the Spearman rank correlation coefficient to determine if there is any relationship between the dependent variable and independent variable. We assume that the variables are normally distributed and are continuous. The association between the dependent variable and independent variables will be examined using the Pearson correlation and the spearman rank correlation.

Data description

In this project we are using a sample size of 105 and the data has 4 variables gender, GPA, final, and totally. The dependent variable is the GPA, the independent variables are; Final marks, and the total marks. The measurement of these variables is the ordinal and the sample size is 105. The variables GPA and final marks have continues variables.

Testing the assumption of normality

The assumptions of the correlation analysis are that the data are normally distributed. To access these assumptions, we conduct a normal probability plot and determine the kurtosis and skewness of the data.

Hypothesis

The null hypothesis; there is a relationship between the GPA and the final exam marks. The alternative hypothesis; there is no relationship between the GPA and the final exam marks.

The alpha is 0.01

Table 5: simple regression model

Model Summary
ModelRR SquareAdjusted R SquareStd. Error of the Estimate
1.089a.008-.012.28974
a. Predictors: (Constant), total, final

The value of R- square is 0.008. This implies that the regression model can be able to account for 0.08% of the errors in the regression model the adjusted R square is equal to -0.12 and the standard error of the estimate is equate to 0.28974.

The multiple regression model

Table 6: The multiple regression model

ANOVAa
ModelSum of SquaresDfMean SquareFSig.
1Regression.0682.034.403.669b
Residual8.563102.084
Total8.631104
a. Dependent Variable: gpa
b. Predictors: (Constant), total, final

From the analysis of variance we can observe that the value of the F-statistic is equal to 0.403 which have an F- statistic equal to 0.669 which is greater than the 0.05 level of confidence. Since the significant value is greater than the 0.05 level of confidence, we conclude that there is significant relationship between the GPA and the final marks of the students.

Simple regression

Table 8: the coefficient of regression

Coefficientsa
Unstandardized CoefficientsStandardized CoefficientstSig.
ModelBStd. ErrorBeta
1(Constant)1.577.1908.292.000
final.003.006.107.544.588
total-.003.004-.163-.829.409
a. Dependent Variable: gpa

From the above analysis of variance, the relationship between the gap, the final and the total marks is significant at 005 level of confidence. This is because the significance value is equal to 0.669 which is greater than the 0.05 level of confidence. For individual independent variables, the final and the total marks are significant to the gpa.

Results and analysis

In this section we will analyze the correlation coefficient of the pair of variables. In this we are determining if there is any relationship between the variables. The variables in this section are; the GPA, the total grade, and the final scores. A Pearson correlation coefficient will be used to determine if there is any relationship between the pairs of variables. A Spearman correlation coefficient will also be determined for every pair of variable.

Ppartial correlation vs non- partial correlation

Results of section 1 analysis

Table 9: partial correlation vs non- partial correlation

Correlations
gpafinaltotal
GpaPearson Correlation1-.034-.070
Sig. (2-tailed).730.475
N105105105
FinalPearson Correlation-.0341.865**
Sig. (2-tailed).730.000
N105105105
TotalPearson Correlation-.070.865**1
Sig. (2-tailed).475.000
N105105105
**. Correlation is significant at the 0.01 level (2-tailed).

From the above analysis, there is a relationship between GPA and the final grade. This is because the Pearson correlation coefficient is 0.865 and the significant value of 0.000. This implies that there is a relationship between the GPA and the final grade of the students. The value of the Pearson correlation between the GPA and the total marks is equal to 0.-0.07 which has a significant value of 0.475. There is no relationship between the GPA and the total student marks are not related since the significant value is greater than the 0.01 levels of significance.

Table 10: The spearman rank correlation

Correlations
gpafinalTotal
gpaCorrelation Coefficient1.000-.042-.053
Sig. (2-tailed)..674.589
N105105105
finalCorrelation Coefficient-.0421.000.875**
Sig. (2-tailed).674..000
N105105105
totalCorrelation Coefficient-.053.875**1.000
Sig. (2-tailed).589.000.
N105105105
**. Correlation is significant at the 0.01 level (2-tailed).

The value of the spearman rank correlation between the variable GPA and the final marks is -0.042 which have a two tailed significant value of 0.674 which is greater than the 0.05level of confidence. Since the two tailed significant value is greater than the 0.05 level of confidence, we can conclude that there is no significant evidence to conclude that the variable GPA and the final marks are significant. The value of the spearman correlation between the GPA and the total marks is -0.053 which have a two tailed significant value of 0.589 which is greater than the 0.05 level of confidence. Since the two tailed significant value is greater than the 0.05 level of confidence, we conclude that there is no sufficient evidence to conclude that the variable GPA and the total marks are significant at 95% confidence. The value of the spearman rank correlation is 0.875 which have a two tailed significant value of 0.000 which is less than the 0.05 level of confidence. Since the two tailed value is less than the 0.05 level of confidence, we conclude that there is sufficient evidence to conclude that there significant relationship between the total marks and the GPA.

Table 11: The descriptive statistics

Descriptive Statistics
NMeanStd. DeviationSkewnessKurtosis
StatisticStatisticStatisticStatisticStd. ErrorStatisticStd. Error
Gpa1051.4812.28808.146.236-1.310.467
Valid N (listwise)105

From above descriptive statistics, the skewness statistics value is 0.146 and a standard error of 0.236. The kurtosis statistics value is -1.310 and the standard error is 0.467.

The scatter plot

The scatter plot

From above scatter plot, there is only one outlier and thus the data is fairly good for analysis. From the output of section 2, there the data is normally distributed and the data is continues hence we can say that data on GPA and final has a satisfied the assumption of correlation.

Conclusions

From the above analysis, there is a relationship between GPA and the final grade. This is because the Pearson correlation coefficient is 0.875 and the significant value of 0.000. This implies that there is a relationship between the GPA and the final grade of the students. There is no relationship between the GPA and the total student marks are not related since the significant value is greater than the 0.01 levels of significance. From above scatter plot, there is only one outlier and thus the data is fairly good for analysis. From the output of section 2, there the data is normally distributed and the data is continues, hence we can say that data on GPA and final has a satisfied the assumption of correlation. Correlation analysis just indicates if the variables are related or not. In this case, it does the relationship between the variables and thus it’s advisable to use the regression analysis to obtain the nature of relationship between the variables.

Logistic regression

Variable description

The variables to be used in this logistic regression are the experience as the dependent variable, the occupation, and the companies worked for. The variables are all nominal and are continuous.

The dependent variable is the experience of the job while the independent variables are the occupation, and the companies worked for.

Model Fitting Information
ModelModel Fitting CriteriaLikelihood Ratio Tests
-2 Log LikelihoodChi-SquaredfSig.
Intercept Only444.475
Final252.949191.52660.000

From the above logistic regression, we can observe that the logistic regression model can be used to predict the work experience given the occupation and the companies worked for.

Likelihood Ratio Tests
EffectModel Fitting CriteriaLikelihood Ratio Tests
-2 Log Likelihood of Reduced ModelChi-SquaredfSig.
Intercept252.949a.0000.
Occupation343.65490.70542.000
CompaniesWorkedFor354.538101.58918.000
The chi-square statistic is the difference in -2 log-likelihoods between the final model and a reduced model. The reduced model is formed by omitting an effect from the final model. The null hypothesis is that all parameters of that effect are 0.
a. This reduced model is equivalent to the final model because omitting the effect does not increase the degrees of freedom.

From the coefficient of the logistic model, we can observe that the variables occupation and companies worked for are significant since the two tailed significant level are equal to 0.000 which is less than the 0.05 significant levels.

References

Kelle, G. (2014). Statistics for Management and Economics, (10thed.). New York: McGraw-Hill/Irwin.

Kutner, M., Nachtsheim, C., Neter, J., & Li, W. (2005). Applied Linear Statistical Models (5th ed.). New York: McGraw-Hill/Irwin.

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. (2022, January 24). Statistics. Grade Point Average and Final Marks. https://ivypanda.com/essays/statistics-grade-point-average-and-final-marks/

Work Cited

"Statistics. Grade Point Average and Final Marks." IvyPanda, 24 Jan. 2022, ivypanda.com/essays/statistics-grade-point-average-and-final-marks/.

References

IvyPanda. (2022) 'Statistics. Grade Point Average and Final Marks'. 24 January.

References

IvyPanda. 2022. "Statistics. Grade Point Average and Final Marks." January 24, 2022. https://ivypanda.com/essays/statistics-grade-point-average-and-final-marks/.

1. IvyPanda. "Statistics. Grade Point Average and Final Marks." January 24, 2022. https://ivypanda.com/essays/statistics-grade-point-average-and-final-marks/.


Bibliography


IvyPanda. "Statistics. Grade Point Average and Final Marks." January 24, 2022. https://ivypanda.com/essays/statistics-grade-point-average-and-final-marks/.

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