SOAN Research Experience

SOAN Research Experience – Data Analysis Excel Q.1 I chose this chart as I saw it best suited to represent the data and show their relationships. Part-time Not employed Full-time 0 50 100 150 200 250 300 350 305 247 126 Employment Condition Q.2 I chose sleep as my second variable for this question as I believe sleep does have a direct impact on your mood, so I thought it would be best to run an analysis on it. Column 1 Column 2 Column 1 1 Column 2 0.02985 4 1 Q.3 The mean, median, and mode represent various important pieces of data such as the average. Understanding these points of data is crucial to understanding descriptive stats. Mean 6.75796 5 Mean 4.36651 9 Standard Error 0.06689 5 Standard Error 0.07898 Median 7 Median 4 Mode 7 Mode 4 Standard Deviation 1.74183 8 Standard Deviation 2.05650 2 Sample Variance 3.03399 9 Sample Variance 4.22920 2 Kurtosis 0.47945 2 Kurtosis 31.9755 3 Skewness -0.12279 Skewness 4.04727 4 Range 12 Range 26 Minimum 1 Minimum 1 Maximum 13 Maximum 27 Sum 4581.9 Sum 2960.5 Count 678 Count 678

Q. 4.a The variables used for this question were the best suited to find correlations between as sleep and amount of courses being taken have a direct relationship in my own world. Anova: Single Factor SUMMARY Groups Count Sum Average Varianc e sleep 679 4583.9 6.75095 7 3.06286 4 courses 679 2967.5 4.37039 8 4.23317 8 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 1923.96 8 1 1923.96 8 527.400 5 7.5E-99 3.84832 6 Within Groups 4946.71 7 1356 3.64802 1 Q4.b ttest 1.73596E- 98 Q4.c Column 1 Column 2 Column 3 Column 1 1 Column 2 0.02985 4 1 Column 3 -0.0262 - 0.0056 7 1

Q6 I watched several videos and could not find any ways to incorporate 3 variables as it only worked using 2 on my excel, so I used 2 variables not three. SUMMARY OUTPUT Regression Statistics Multiple R 0.029854 R Square 0.000891 Adjusted R Square -0.00058 Standard Error 1.750615 Observation s 679 ANOVA df SS MS F Significan ce F Regression 1 1.850849 1.85084 9 0.60393 4 0.437352 Residual 677 2074.771 3.06465 4 Total 678 2076.622 Coefficien ts Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 6.639974 0.157825 42.0718 2 4.5E- 191 6.330089 6.94985 9 6.33008 9 6.94985 9 X Variable 1 0.025394 0.032677 0.77713 2 0.43735 2 -0.03877 0.08955 5 - 0.03877 0.08955 5