Q__DataAnalysis_StatisticsAssig_FINALCOPY.xlsx

Analysis

GPA Phone Usage (in mins per day)
3.98 60 Summary Statsistics (GPA) Summary Statistis -Phone Usage
3.92 90
2.61 300 Mean 3.1905 Mean 347.625
2.15 360 Standard Error 0.0970520281 Standard Error 30.2674973235
3.44 480 Median 3.245 Median 357.5
4 75 Mode 3.96 Mode 300
3.4 570 Standard Deviation 0.6138109205 Standard Deviation 191.4284612309
2.17 600 Sample Variance 0.3767638462 Sample Variance 36644.8557692308
2.67 240 Kurtosis -0.5501286649 Kurtosis -0.883919136
2.79 515 Skewness -0.3795528054 Skewness 0.0348694488
3.16 300 Range 2.37 Range 690
3.25 360 Minimum 1.83 Minimum 30
3.48 45 Maximum 4.2 Maximum 720
2.89 365 Sum 127.62 Sum 13905
1.83 720 Count 40 Count 40
3.73 330
3.24 410 Hypothesis Testing
3.96 30 Research Question Is there a significant correlation between the time spent on phone and their GPA?
3.72 660 i.).Hypotheses: H0:ρ=0 ,there is no significant correlation between the time spent on phone and their GPA?
4.1 120 H1:ρ≠0 ,there is significant correlation between the time spent on phone and their GPA?
3.1 450
2.88 690 ii.). Significance level,α = 0.05
2.56 300 ii.). Test and test statistic Two tailed Test statistic,t=[r*sqrt.(n-2)]/[sqrt.(1-r^2)]
3.29 480 r= -0.5797234269
3.14 150 n= 40
3.1 485 test statistic,t= -4.3858576168
3.46 305
2.65 510 iii.).Rejection Regions degrees of freedom,df = 38
2.76 400 Critical values t= -2.0243941639
3.7 135 t= 2.0243941639
1.98 600 Critical regions t<-2.02439164 <= rejection on the left
3.96 540 t>2.02439165 <= rejection on the right
2.35 360
3.3 315 iv.).Decission Test statistic< critical value=-2.02439164.The test statistic falls in the critical region.
3.78 135 Reject the null hypothesis ,H0
3.47 130
2.73 480 v.).Conclusion; At 5% significance level, we conclude that there is statistically significant correlation between the time spent on phone and their GPA
3.22 355
3.5 335
4.2 120

Scatterplot

60 90 300 360 480 75 570 600 240 515 300 360 45 365 720 330 410 30 660 120 450 690 300 480 150 485 305 510 400 135 600 540 360 315 135 130 480 355 335 120 3.98 3.92 2.61 2.15 3.44 4 3.4 2.17 2.67 2.79 3.16 3.25 3.48 2.89 1.83 3.73 3.24 3.96 3.72 4.0999999999999996 3.1 2.88 2.56 3.29 3.14 3.1 3.46 2.65 2.76 3.7 1.98 3.96 2.35 3.3 3.78 3.47 2.73 3.22 3.5 4.2

Phone Usage (in mins per day))

GPA

Data org.

GPA Phone Usage (in mins per day) Frequency Table (GPA) Frequency Table(Phone Usage)
3.98 60 Class Frequency Class Frequency
3.92 90 1.83-2.32 4 30-189 11
2.61 300 2.33-2.82 8 190-349 8
2.15 360 2.83-3.32 11 350-509 12
3.44 480 3.33-3.82 10 510-669 7
4 75 3.83-4.32 7 670-829 2
3.4 570
2.17 600
2.67 240
2.79 515
3.16 300
3.25 360
3.48 45
2.89 365
1.83 720
3.73 330
3.24 410
3.96 30
3.72 660
4.1 120
3.1 450
2.88 690
2.56 300
3.29 480
3.14 150
3.1 485
3.46 305
2.65 510
2.76 400
3.7 135
1.98 600
3.96 540
2.35 360
3.3 315
3.78 135
3.47 130
2.73 480
3.22 355
3.5 335
4.2 120

Histogram for Phonr Usage (mins)

30-189 190-349 350-509 510-669 670-829 11 8 12 7 2

Class

Frequency

Histogram for GPA

Frequency 1.83-2.32 2.33-2.82 2.83-3.32 3.33-3.82 3.83-4.32 4 8 11 10 7

Class

Frequency