{"id":96286,"date":"2022-04-28T21:21:37","date_gmt":"2022-04-28T21:21:37","guid":{"rendered":"https:\/\/papersspot.com\/blog\/2022\/04\/28\/data-handling-a-below-is-the-data-view-of-the-dataset-b\/"},"modified":"2022-04-28T21:21:37","modified_gmt":"2022-04-28T21:21:37","slug":"data-handling-a-below-is-the-data-view-of-the-dataset-b","status":"publish","type":"post","link":"https:\/\/papersspot.com\/blog\/2022\/04\/28\/data-handling-a-below-is-the-data-view-of-the-dataset-b\/","title":{"rendered":"Data handling a. Below is the data view of the dataset b."},"content":{"rendered":"<p>Data handling <\/p>\n<p> a. Below is the data view of the dataset<\/p>\n<p> b. Shown below is the variable view of the dataset<\/p>\n<p> 2. Descriptive statistics<\/p>\n<p> The process and results of obtaining descriptive statistics of continuous variables are as below. The mean \u00b1 standard deviation of age, exam marks, assignment marks, and IQ are 20.50 \u00b1 1.842, 82.79 \u00b1 12.594, 81.88 \u00b1 10.695, 105.17 \u00b1 16.282 respectively<\/p>\n<p> Descriptive Statistics<\/p>\n<p> N<\/p>\n<p> Minimum<\/p>\n<p> Maximum<\/p>\n<p> Mean<\/p>\n<p> Std. Deviation<\/p>\n<p> Age<\/p>\n<p> 24<\/p>\n<p> 18<\/p>\n<p> 24<\/p>\n<p> 20.50<\/p>\n<p> 1.842<\/p>\n<p> Exam Marks (for a maximum of 100)<\/p>\n<p> 24<\/p>\n<p> 55<\/p>\n<p> 99<\/p>\n<p> 82.79<\/p>\n<p> 12.594<\/p>\n<p> Assignment Marks (for a maximum of 100)<\/p>\n<p> 24<\/p>\n<p> 55<\/p>\n<p> 95<\/p>\n<p> 81.88<\/p>\n<p> 10.695<\/p>\n<p> intelligence quotient<\/p>\n<p> 24<\/p>\n<p> 72<\/p>\n<p> 136<\/p>\n<p> 105.17<\/p>\n<p> 16.282<\/p>\n<p> Valid N (listwise)<\/p>\n<p> 24<\/p>\n<p> The chart below shows gender is coded as 0 or 1<\/p>\n<p> The following are the process and results of descriptive statistics for categorical variables. There were more females (58.3) than males. (41.7). Observe from the table that juniors (33) had the most frequency followed closely by a sophomore (29) while seniors (8) had the least frequency.<\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> Frequency<\/p>\n<p> Per cent<\/p>\n<p> Valid Percent<\/p>\n<p> Cumulative Percent<\/p>\n<p> Valid<\/p>\n<p> Male<\/p>\n<p> 10<\/p>\n<p> 41.7<\/p>\n<p> 41.7<\/p>\n<p> 41.7<\/p>\n<p> Female<\/p>\n<p> 14<\/p>\n<p> 58.3<\/p>\n<p> 58.3<\/p>\n<p> 100.0<\/p>\n<p> Total<\/p>\n<p> 24<\/p>\n<p> 100.0<\/p>\n<p> 100.0<\/p>\n<p> Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4=Senior)<\/p>\n<p> Frequency<\/p>\n<p> Percent<\/p>\n<p> Valid Percent<\/p>\n<p> Cumulative Percent<\/p>\n<p> Valid<\/p>\n<p> Freshman<\/p>\n<p> 5<\/p>\n<p> 20.8<\/p>\n<p> 20.8<\/p>\n<p> 20.8<\/p>\n<p> Sophomore<\/p>\n<p> 7<\/p>\n<p> 29.2<\/p>\n<p> 29.2<\/p>\n<p> 50.0<\/p>\n<p> Junior<\/p>\n<p> 8<\/p>\n<p> 33.3<\/p>\n<p> 33.3<\/p>\n<p> 83.3<\/p>\n<p> Senior<\/p>\n<p> 2<\/p>\n<p> 8.3<\/p>\n<p> 8.3<\/p>\n<p> 91.7<\/p>\n<p> 20<\/p>\n<p> 1<\/p>\n<p> 4.2<\/p>\n<p> 4.2<\/p>\n<p> 95.8<\/p>\n<p> 30<\/p>\n<p> 1<\/p>\n<p> 4.2<\/p>\n<p> 4.2<\/p>\n<p> 100.0<\/p>\n<p> Total<\/p>\n<p> 24<\/p>\n<p> 100.0<\/p>\n<p> 100.0<\/p>\n<p> The pie chart below shows the distribution for years in College. <\/p>\n<p> The histogram for IQ is created as below. The data follows the normal distribution. <\/p>\n<p> The scatter plot of exam marks versus IQ below shows a linear association between the two. <\/p>\n<p> The scatter plot of IQ versus sex is shown below. The IQ of females is distributed higher those that of males. <\/p>\n<p> h. The difference in the mean IQ per gender is as below. Males have a lower mean IQ (94.5) than their female (112.79) counterparts. <\/p>\n<p> Mean IQ for each gender<\/p>\n<p> Mean <\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> intelligence quotient<\/p>\n<p> Male<\/p>\n<p> 94.50<\/p>\n<p> Female<\/p>\n<p> 112.79<\/p>\n<p> Total<\/p>\n<p> 105.17<\/p>\n<p> Data analysis<\/p>\n<p> The analysis and result of the One-Sample T-test are shown below.<\/p>\n<p> Null hypothesis: exam marks are not significantly larger than 75<\/p>\n<p> The p-value (.006) is less than a 5% significance level therefore the null is rejected. Hence exam marks are significantly larger than 75<\/p>\n<p> One-Sample Statistics<\/p>\n<p> N<\/p>\n<p> Mean<\/p>\n<p> Std. Deviation<\/p>\n<p> Std. Error Mean<\/p>\n<p> Exam Marks<\/p>\n<p> 24<\/p>\n<p> 82.79<\/p>\n<p> 12.594<\/p>\n<p> 2.571<\/p>\n<p> One-Sample Test<\/p>\n<p> Test Value = 75<\/p>\n<p> t<\/p>\n<p> df<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> Mean Difference<\/p>\n<p> 95% Confidence Interval of the Difference<\/p>\n<p> Lower<\/p>\n<p> Upper<\/p>\n<p> Exam Marks<\/p>\n<p> 3.031<\/p>\n<p> 23<\/p>\n<p> .006<\/p>\n<p> 7.792<\/p>\n<p> 2.47<\/p>\n<p> 13.11<\/p>\n<p> The following is the analysis and result of the Independent samples t-test <\/p>\n<p> Null hypothesis: There are no significant differences in the exam marks between men and women. The p-value (.001) is less than a 5% significance level therefore the null is rejected. Hence there are significant differences in the exam marks between men and women.<\/p>\n<p> Group Statistics<\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> N<\/p>\n<p> Mean<\/p>\n<p> Std. Deviation<\/p>\n<p> Std. Error Mean<\/p>\n<p> Exam Marks (for a maximum of 100)<\/p>\n<p> Male<\/p>\n<p> 10<\/p>\n<p> 72.90<\/p>\n<p> 13.153<\/p>\n<p> 4.159<\/p>\n<p> Female<\/p>\n<p> 14<\/p>\n<p> 89.86<\/p>\n<p> 5.641<\/p>\n<p> 1.508<\/p>\n<p> Independent Samples Test<\/p>\n<p> Levene&#8217;s Test for Equality of Variances<\/p>\n<p> t-test for Equality of Means<\/p>\n<p> F<\/p>\n<p> Sig.<\/p>\n<p> t<\/p>\n<p> df<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> Mean Difference<\/p>\n<p> Std. Error Difference<\/p>\n<p> 95% Confidence Interval of the Difference<\/p>\n<p> Lower<\/p>\n<p> Upper<\/p>\n<p> Exam Marks <\/p>\n<p> Equal variances assumed<\/p>\n<p> 14.459<\/p>\n<p> .001<\/p>\n<p> -4.327<\/p>\n<p> 22<\/p>\n<p> .000<\/p>\n<p> -16.957<\/p>\n<p> 3.919<\/p>\n<p> -25.084<\/p>\n<p> -8.830<\/p>\n<p> Equal variances not assumed<\/p>\n<p> -3.833<\/p>\n<p> 11.385<\/p>\n<p> .003<\/p>\n<p> -16.957<\/p>\n<p> 4.424<\/p>\n<p> -26.654<\/p>\n<p> -7.260<\/p>\n<p> Shown below is the process and result obtained from running a paired samples t-test. <\/p>\n<p> Null hypothesis: There is no significant difference between the exam marks and the assignment marks. The p-value (.659) is greater than the 5% significance level therefore the null is not rejected. Hence there is no significant difference between the exam marks and the assignment marks.<\/p>\n<p> Paired Samples Statistics<\/p>\n<p> Mean<\/p>\n<p> N<\/p>\n<p> Std. Deviation<\/p>\n<p> Std. Error Mean<\/p>\n<p> Pair 1<\/p>\n<p> Exam Marks<\/p>\n<p> 82.79<\/p>\n<p> 24<\/p>\n<p> 12.594<\/p>\n<p> 2.571<\/p>\n<p> Assignment Marks<\/p>\n<p> 81.88<\/p>\n<p> 24<\/p>\n<p> 10.695<\/p>\n<p> 2.183<\/p>\n<p> Paired Samples Correlations<\/p>\n<p> N<\/p>\n<p> Correlation<\/p>\n<p> Sig.<\/p>\n<p> Pair 1<\/p>\n<p> Exam Marks &amp; Assignment Marks <\/p>\n<p> 24<\/p>\n<p> .638<\/p>\n<p> .001<\/p>\n<p> Paired Samples Test<\/p>\n<p> Paired Differences<\/p>\n<p> t<\/p>\n<p> df<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> Mean<\/p>\n<p> Std. Deviation<\/p>\n<p> Std. Error Mean<\/p>\n<p> 95% Confidence Interval of the Difference<\/p>\n<p> Lower<\/p>\n<p> Upper<\/p>\n<p> Pair 1<\/p>\n<p> Exam Marks &#8211; Assignment Marks<\/p>\n<p> .917<\/p>\n<p> 10.056<\/p>\n<p> 2.053<\/p>\n<p> -3.330<\/p>\n<p> 5.163<\/p>\n<p> .447<\/p>\n<p> 23<\/p>\n<p> .659<\/p>\n<p> d. The correlation analysis and result between gender, IQ, exam and assignment marks are as below. All the correlations are significant at a 5% significance level. Exam marks are positively and highly correlated to assignment marks and sex but moderately correlated to IQ. Similarly, assignment marks are positively and highly correlated to IQ but moderately correlated to sex.<\/p>\n<p> Correlations<\/p>\n<p> Exam Marks (for a maximum of 100)<\/p>\n<p> Assignment Marks (for a maximum of 100)<\/p>\n<p> intelligence quotient<\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> Exam Marks (for a maximum of 100)<\/p>\n<p> Pearson Correlation<\/p>\n<p> 1<\/p>\n<p> .638**<\/p>\n<p> .461*<\/p>\n<p> .678**<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> .001<\/p>\n<p> .023<\/p>\n<p> .000<\/p>\n<p> N<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> Assignment Marks (for a maximum of 100)<\/p>\n<p> Pearson Correlation<\/p>\n<p> .638**<\/p>\n<p> 1<\/p>\n<p> .768**<\/p>\n<p> .450*<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> .001<\/p>\n<p> .000<\/p>\n<p> .027<\/p>\n<p> N<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> intelligence quotient<\/p>\n<p> Pearson Correlation<\/p>\n<p> .461*<\/p>\n<p> .768**<\/p>\n<p> 1<\/p>\n<p> .566**<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> .023<\/p>\n<p> .000<\/p>\n<p> .004<\/p>\n<p> N<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> Pearson Correlation<\/p>\n<p> .678**<\/p>\n<p> .450*<\/p>\n<p> .566**<\/p>\n<p> 1<\/p>\n<p> Sig. (2-tailed)<\/p>\n<p> .000<\/p>\n<p> .027<\/p>\n<p> .004<\/p>\n<p> N<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> 24<\/p>\n<p> **. Correlation is significant at the 0.01 level (2-tailed).<\/p>\n<p> *. Correlation is significant at the 0.05 level (2-tailed).<\/p>\n<p> The dummy coding for IQ is implemented as below. IQ lower than 105 is 0 while IQ higher than 105 is 1.<\/p>\n<p> Do a multiple regression analysis to explain the variance in assignment marks using the independent variables of age; sex; and IQ (dummy coded) and interpret the results. <\/p>\n<p> The following is the ANOVA for the regression. <\/p>\n<p> Null hypothesis: The model is not significant.<\/p>\n<p> The p-value (.005) is less than a 5% significance level therefore the null is rejected. Hence the model is significant. <\/p>\n<p> ANOVA<\/p>\n<p> Model<\/p>\n<p> Sum of Squares<\/p>\n<p> df<\/p>\n<p> Mean Square<\/p>\n<p> F<\/p>\n<p> Sig.<\/p>\n<p> 1<\/p>\n<p> Regression<\/p>\n<p> 1212.291<\/p>\n<p> 3<\/p>\n<p> 404.097<\/p>\n<p> 5.698<\/p>\n<p> .005b<\/p>\n<p> Residual<\/p>\n<p> 1418.334<\/p>\n<p> 20<\/p>\n<p> 70.917<\/p>\n<p> Total<\/p>\n<p> 2630.625<\/p>\n<p> 23<\/p>\n<p> a. Dependent Variable: Assignment Marks (for a maximum of 100)<\/p>\n<p> b. Predictors: (Constant), Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4=Senior), iQ(Dummy coded), Sex (M=Male, F=Female)<\/p>\n<p> The coefficients table for the analysis is shown below.<\/p>\n<p> Null hypothesis: The respective model coefficients are not significant in the model. Only the constant and IQ coefficients are significant in the model. Their p-values were 0.00 and 0.017 respectively warranting the rejection of their respective null hypotheses. <\/p>\n<p> Coefficients<\/p>\n<p> Model<\/p>\n<p> Unstandardized Coefficients<\/p>\n<p> Standardized Coefficients<\/p>\n<p> t<\/p>\n<p> Sig.<\/p>\n<p> B<\/p>\n<p> Std. Error<\/p>\n<p> Beta<\/p>\n<p> 1<\/p>\n<p> (Constant)<\/p>\n<p> 78.149<\/p>\n<p> 3.321<\/p>\n<p> 23.534<\/p>\n<p> .000<\/p>\n<p> iQ(Dummy coded)<\/p>\n<p> 12.125<\/p>\n<p> 4.669<\/p>\n<p> .579<\/p>\n<p> 2.597<\/p>\n<p> .017<\/p>\n<p> Sex (M=Male, F=Female)<\/p>\n<p> -.757<\/p>\n<p> 4.869<\/p>\n<p> -.036<\/p>\n<p> -.156<\/p>\n<p> .878<\/p>\n<p> Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4=Senior)<\/p>\n<p> -.450<\/p>\n<p> .281<\/p>\n<p> -.279<\/p>\n<p> -1.600<\/p>\n<p> .125<\/p>\n<p> a. Dependent Variable: Assignment Marks (for a maximum of 100)<\/p>\n<p> The r-squared shows that 67.9% of the variations of assignment marks are explained in the model.<\/p>\n<p> Model Summary<\/p>\n<p> Model<\/p>\n<p> R<\/p>\n<p> R Square<\/p>\n<p> Adjusted R Square<\/p>\n<p> Std. Error of the Estimate<\/p>\n<p> 1<\/p>\n<p> .679a<\/p>\n<p> .461<\/p>\n<p> .380<\/p>\n<p> 8.421<\/p>\n<p> a. Predictors: (Constant), Year in College (1=Freshman; 2=Sophomore; 3=Junior; 4=Senior), iQ(Dummy coded), Sex (M=Male, F=Female)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data handling a. Below is the data view of the dataset b. Shown below is the variable view of the dataset 2. Descriptive statistics The process and results of obtaining descriptive statistics of continuous variables are as below. The mean \u00b1 standard deviation of age, exam marks, assignment marks, and IQ are 20.50 \u00b1 1.842, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-96286","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/96286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=96286"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/96286\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=96286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=96286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=96286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}