BSB123: Data Analysis - Statistical Literacy - Research Report Assessment Answers
Solution Code: 1FGI
Question: Data Analysis Report Writing
This assignment is related to “Data Analysis Report Writing” and experts at My Assignment Services AU successfully delivered HD quality work within the given deadline.
Data Analysis Report
Task
As the research officer of this study you have been asked to fully analyse the data, and prepare a report for the Assistant Dean (Learning and Teaching), detailing all important findings derived from the data and your recommendations to the Assistant Dean.
Hints: You are expected to apply appropriate techniques learnt from Lectures 6 to 10. When presenting your findings, you should use graphs and tables to help get across your messages. Use concise language when reporting findings from your data analysis. You do not have to include all Excel output (obtained for example from your hypothesis testing and regression analysis) in the body of your report; leave them in the appendices if appropriate.
As a research report your work should be presented in a professional manner and the report should be structured accordingly.
Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Solution:
-
Introduction:
Australian government has invested heavily about $9 billion in higher education and is looking for whether the investments have had their impact on the performance of students. For this concern, we have been asked to look into the factors that affect the performance of students in the total marks scored and also the relationship between the variables that affect the total marks and the grade. For this purpose, the sample data has been given on the performance scores of various students (703 students) who have different characteristics – there are both males and females, there are both Australian and international students; there are students who are enrolled for a double degree and those who have enrolled for a single degree. In this research report we analyse the various relationships between the variables that affect the total marks of the students.
-
Outliers
Outliers are data values that are recorded to be far apart from the average data values found in the sample data of a variable. For examining whether there are any outliers in the total marks, we use the standardize function in the excel with the mean and standard deviation to find the z-scores of the variables and if the max and min of the z-scores are above the +/- 3, then the data set to considered to have outliers (Kothari, 2011). For the total marks, we have the mean as 57.94 and the standard deviation as 15.78. (See appendix on descriptive statistics). The max z-score is at 2.47 and the min z-score value is at -2.53 and these values are in between +3 and -3, we can conclude that there are no outliers in the data set.
-
Distribution of Total Marks of Students:
There are 703 students in the sample and the frequency table of the total marks of the students and the histogram of the same is shown below.
Table 1: Frequency distribution of Total Marks
| Total Marks | Frequency of Students |
| 10-20 | 1 |
| 20-30 | 14 |
| 30-40 | 79 |
| 40-50 | 153 |
| 50-60 | 170 |
| 60-70 | 129 |
| 70-80 | 85 |
| 80-90 | 53 |
| 90-100 | 19 |
Figure 1: Histogram of Final Marks
From the above table and histogram we can see that the data set is symmetrical and the highest frequency is observed in the class interval of 50-60.
| TOTAL | |
| Mean | 57.94452 |
| Standard Error | 0.595258 |
| Median | 56 |
| Mode | 50 |
| Standard Deviation | 15.78275 |
| Sample Variance | 249.0952 |
| Kurtosis | -0.38823 |
| Skewness | 0.284536 |
| Range | 79 |
| Minimum | 18 |
| Maximum | 97 |
| Sum | 40735 |
| Count | 703 |
The average mean of the total marks as shown in the above descriptive statistics is at 57.94 and the median also lies in the same class interval at 56, and the mode is 50, which means that the data is distributed normally. The maximum score on the total marks is 97 and the minimum is 18, which gives the range of 79 as shown in the descriptive statistics. The standard deviation of the total marks is 15.78 which mean that the data values deviate +15.78 or -15.78 around the mean
-
Bi-variate analysis: t-tests
-
Total Marks and Gender:
Table 2: Frequency distribution of Total marks by gender
| Frequency of Males | Frequency of Females | |
| 10-20 | 1 | 0 |
| 20-30 | 8 | 6 |
| 30-40 | 51 | 28 |
| 40-50 | 76 | 77 |
| 50-60 | 72 | 98 |
| 60-70 | 60 | 69 |
| 70-80 | 43 | 42 |
| 80-90 | 22 | 31 |
| 90-100 | 7 | 12 |
Figure 2: Stacked Bar chart of total marks by gender
The pivot tables of total marks by gender (Table 2) and the stacked bar chart of exam results by gender, we can conclude that the number of females getting higher marks is higher in all the categories of marks, above 40-50 groups.
Conducting a t-test for the means of total marks by gender we have the following results found in the appendix.
Since the means of exam results of both gender males and the female students are different at 29.24 and 27.73, we might conclude that there is a difference between the gender in achieving the exam results, but since the p value 0.052 > 0.05 , we can conclude that there is no difference between the two genders in exam results (Refer appendix for t-test) The mean total marks for males is 56.43 and mean total marks for females is 59.36 and the p-value (two tailed) is at 0.01 which means that there is significant difference between the mean total marks of males and females.
-
Total Marks and nationality of students:
Similar t-test for Australian and International students (see the appendix) show that the total marks of International students are on an average (students from other countries) is equal to 60.15 and that of Australian students is at 57.91 and the p-value is at 0.48 which is < 0.05 and hence the mean total marks of the Australian and international students are different.
-
Total marks and double degree of students
Similar t-test for those students who are doing a double degree and those who are doing a single degree show the fact that the total marks of those students who are doing double degree are on an average is 62.145 and those who are doing a single degree have an mean total marks of 55.766 and the p value (two tailed ) is at 0.0099 which is lesser than 0.05 and hence the total marks of students who are doing a double degree is significantly higher than those who are doing a single degree.
-
Correlation Analysis:
The correlation table between total marks and various variables show a moderate degree of positive correlation between total marks and lecture attendance at 0.19 which is a low positive correlation. If the correlation lies between+/- 0.3 and +/- 0.7 then it is a moderate positive or negative correlation (Mathbits, 2015). If the correlation coefficient is less than +/- 0.3 then it is a weak correlation. IF the correlation is higher than +/- 0.7 then it is a strong correlation (Hair, Celsi, Money, & Michael, 2011).
The correlation between quiz and total result is strong and positive at 0.69 and correlation between total marks and report is moderate at 0.49, and that between exam and total marks is strong and positive at 0.959.
-
Regression between total marks and other variables is given as under.
Only three variables are efficient in explaining the changes in the total marks of students and they are the variables having t-stat above 2, (Zikmund, 1984)which are the quiz, report and exam. Writing the regression equation with these variables we have.
Total marks = 0.99 quiz +0.99 report and 0.99 Exam
Writing the regression equation with all the variables we have
Total marks = 0.279 +0.0007 lecture attendance +0.99 quiz +0.99 report and 0.99 Exam + 0.045 grade – 0.0036 gender – 0.03 Double degree + 0.046 country
Conclusion:
There are various variables that are influencing total marks of the students in the university. However, the three variables quiz, report and exam seem to affect the total marks than any other variables. The R-square value of the regression model is at 0.99 which means that 99% of the changes in the dependent variable is explained through the changes in the independent variables.
Find Solution for Marketing case study assignment by dropping us a mail at help@myassignmentservices.com.au along with the question’s URL. Get in Contact with our experts at My Assignment Services AU and get the solution as per your specification & University requirement.
