Buisness Statistics
Bishalmandal
3 years ago
10
files (2)AnalysisReport.docx
- G2072.csv
AnalysisReport.docx
Analysis Report
Date Due: Week 11 (5pm, 29th of September 2023)
Total Marks: 30 marks Worth: 30% of final assessment
You need to prepare a group analysis report (using Microsoft Word), which requires an amount of computer work and written comment. Do not leave things until too late!! Each task describes what you are required to do, so please follow these carefully!
In this report, you will analyse a survey dataset. It has three variables, namely gender (the categories are male and female), prog (Type of program, with categories: general, academic, and vocational), write (Standardized writing score).
Task 1: Teamwork and Report Submission (5 Marks)
Work as a team to prepare a report. The report should be written in Word (one file) showing steps of working and rounding numbers with three decimal places. List all group members’ name and student number on the Front sheet of the report (excluding the ones who did not contribute). Select one person to submit the report in Canvas on time (it means that a group needs only to submit one report).
Task 2: Analyse the variable write (15 Marks)
a. Construct a boxplot for the variable write (including vertical axis title). (4 Marks)
b. Describe the shape of the distribution of the variable write. (1 Mark)
c. Calculate sum of the variable write values and sum of variable write values square and then use them to calculate sample mean and sample standard deviation of the variable write. (4 Marks)
d. Calculate the 99% of the confidence interval. (4 Marks)
The following table can be used for this part of Task 2:
e. Give a practical interpretation of the confidence interval constructed in part (d). (2 Mark)
[Hints: refer to Lecture 2 ("Measures of Central Tendency"), slides 8, 17 to 20 for the calculation of sample mean. Also, see slide 10 in Lecture 3 (Measures of dispersion) for the calculation of sample standard deviation. Regarding the calculation of t-interval, refer to Lecture 8, slide 21]
Task 3: Analyse the variables gender and prog (10 Marks)
a. Create a contingency table of the variable gender by the variable prog as shown below: (5 Marks)
|
gender |
Type of program (prog) |
|||
|
|
academic |
general |
vocational |
Total |
|
female |
|
|
|
|
|
male |
|
|
|
|
|
Total |
|
|
|
|
b. Calculate the percentage of female student studying in each type of program. (3 Marks)
c. Comment on the percentages obtained in part b. (2 Marks)
image1.emf
AnalysisReport.docx
Analysis Report
Date Due: Week 11 (5pm, 29th of September 2023)
Total Marks: 30 marks Worth: 30% of final assessment
You need to prepare a group analysis report (using Microsoft Word), which requires an amount of computer work and written comment. Do not leave things until too late!! Each task describes what you are required to do, so please follow these carefully!
In this report, you will analyse a survey dataset. It has three variables, namely gender (the categories are male and female), prog (Type of program, with categories: general, academic, and vocational), write (Standardized writing score).
Task 1: Teamwork and Report Submission (5 Marks)
Work as a team to prepare a report. The report should be written in Word (one file) showing steps of working and rounding numbers with three decimal places. List all group members’ name and student number on the Front sheet of the report (excluding the ones who did not contribute). Select one person to submit the report in Canvas on time (it means that a group needs only to submit one report).
Task 2: Analyse the variable write (15 Marks)
a. Construct a boxplot for the variable write (including vertical axis title). (4 Marks)
b. Describe the shape of the distribution of the variable write. (1 Mark)
c. Calculate sum of the variable write values and sum of variable write values square and then use them to calculate sample mean and sample standard deviation of the variable write. (4 Marks)
d. Calculate the 99% of the confidence interval. (4 Marks)
The following table can be used for this part of Task 2:
e. Give a practical interpretation of the confidence interval constructed in part (d). (2 Mark)
[Hints: refer to Lecture 2 ("Measures of Central Tendency"), slides 8, 17 to 20 for the calculation of sample mean. Also, see slide 10 in Lecture 3 (Measures of dispersion) for the calculation of sample standard deviation. Regarding the calculation of t-interval, refer to Lecture 8, slide 21]
Task 3: Analyse the variables gender and prog (10 Marks)
a. Create a contingency table of the variable gender by the variable prog as shown below: (5 Marks)
|
gender |
Type of program (prog) |
|||
|
|
academic |
general |
vocational |
Total |
|
female |
|
|
|
|
|
male |
|
|
|
|
|
Total |
|
|
|
|
b. Calculate the percentage of female student studying in each type of program. (3 Marks)
c. Comment on the percentages obtained in part b. (2 Marks)
