Recent Question/Assignment
STATS1900 Business Statistics
Minor Assignment – 2nd Semester, 2014
Due: week 4
Total Marks: 30, Worth: 10% of final assessment
This assignment requires a considerable amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late. Each question carefully describes what you are required to do, so please follow the instructions carefully. Your answer to each question should begin with the number of the question.
In this assignment you will examine statistical data consisting of records of students who studied either an undergraduate subject (BUS100) or a postgraduate subject BUS600 in a university somewhere. The data collected students records from first, second and summer semesters in 2012 and 2013. Data was collected in a file called ‘StudentPerformanceData.xls’, the columns of which contain the following information:
Column Name Description
A Student ID Number Number to identify each student
B Student Gender 1= Male
2= Female
C Student Age Age (Years)
D Motivation A score between 0 and 100
E Attendance Rate Student attendance percentage (%) per semester.
F Student final mark Student mark out of maximum mark of 100
G Student Grade HD: High Distinction
D: Distinction
C: Credit
P: Pass
MF: Marginal Fail
F: Fail
H Program U= Undergraduate
P= Postgraduate
I Subject Code BUS100= Undergraduate Business Subject
BUS600= Postgraduate Business Subject
J Year 2012 or 2013
K Semester - First
- Second
- Summer
Before you begin any analysis you must take a random sample of 200 records from the 257 provided in the file StudentPerformanceData.xls. Use the Random Sample Generator, available on Moodle in the Lab Bundle, to do this. Your answers to the assignment tasks below are to be based on your sample of 200 records. Make sure you keep a safe copy of your sample, since you cannot use the Random Sample Generator to reproduce the first sample.
To prepare your data file ready for analysis, you must take the following steps:
1. Use the file Random Sample Generator_08, in the Lab Resources Bundle on Moodle, to generate a random sample of 200 records from the file.
2. Copy your sample to another spread sheet for working on your assignment and save it with another file name. Remember to save another copy of your sample under a different name as a backup.
Assignment Tasks
For each task below, you must answer all the questions in sequential order and submit all of the required printouts, graphs, tables and summaries required.
NB: Each graph and table should have a heading and each axis should have a label!!
1. Introduction, Variable List and Data: Give a brief introduction to your report. Using the variables listed in the table above, state for each variable whether it is qualitative or quantitative. If it is qualitative state whether it is nominal or ordinal, and if it is quantitative state whether it is discrete or continuous. Provide a printout of the data in your sample, sorted in ascending order based on student ID number.
[4 Marks]
2. Produce 2 Pareto Graphs showing the grade distribution of the BUS100 and BUS600 subjects. Provide your comments on the graph shape, and grade distribution.
[6 Marks]
3. Create histograms and side by side boxplots showing the distribution of students’ marks for BUS100 and BUS600. Comment on the shape of the distribution in each graph. In particular, is it symmetric? If it is not, is it positively or negatively skewed?
[6 Marks]
4. Produce the following Pivot Tables:
a) Create a pivot table to show the average student marks per semester for BUS100 & BUS600 in 2012 and 2013. Provide your comments on similarities or differences and any conclusions you can draw in each case.
b) Construct a pivot table that shows the number of student who succeeded per semester, per year for BUS100 and BUS600. Place subjects and semesters in the rows, years in the columns and a count of students in the body of the table.
c) Convert the above table in (b) into another table by converting the student numbers into relative frequencies ( % of success rates) in each case. Provide your comments and conclusions on the results.
[11 Marks]
5. Using the information obtained for your analyses write a short conclusion about what you found from the study above.
[3 marks]
Minor Assignment – 2nd Semester, 2014
Due: week 4
Total Marks: 30, Worth: 10% of final assessment
This assignment requires a considerable amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late. Each question carefully describes what you are required to do, so please follow the instructions carefully. Your answer to each question should begin with the number of the question.
In this assignment you will examine statistical data consisting of records of students who studied either an undergraduate subject (BUS100) or a postgraduate subject BUS600 in a university somewhere. The data collected students records from first, second and summer semesters in 2012 and 2013. Data was collected in a file called ‘StudentPerformanceData.xls’, the columns of which contain the following information:
Column Name Description
A Student ID Number Number to identify each student
B Student Gender 1= Male
2= Female
C Student Age Age (Years)
D Motivation A score between 0 and 100
E Attendance Rate Student attendance percentage (%) per semester.
F Student final mark Student mark out of maximum mark of 100
G Student Grade HD: High Distinction
D: Distinction
C: Credit
P: Pass
MF: Marginal Fail
F: Fail
H Program U= Undergraduate
P= Postgraduate
I Subject Code BUS100= Undergraduate Business Subject
BUS600= Postgraduate Business Subject
J Year 2012 or 2013
K Semester - First
- Second
- Summer
Before you begin any analysis you must take a random sample of 200 records from the 257 provided in the file StudentPerformanceData.xls. Use the Random Sample Generator, available on Moodle in the Lab Bundle, to do this. Your answers to the assignment tasks below are to be based on your sample of 200 records. Make sure you keep a safe copy of your sample, since you cannot use the Random Sample Generator to reproduce the first sample.
To prepare your data file ready for analysis, you must take the following steps:
1. Use the file Random Sample Generator_08, in the Lab Resources Bundle on Moodle, to generate a random sample of 200 records from the file.
2. Copy your sample to another spread sheet for working on your assignment and save it with another file name. Remember to save another copy of your sample under a different name as a backup.
Assignment Tasks
For each task below, you must answer all the questions in sequential order and submit all of the required printouts, graphs, tables and summaries required.
NB: Each graph and table should have a heading and each axis should have a label!!
1. Introduction, Variable List and Data: Give a brief introduction to your report. Using the variables listed in the table above, state for each variable whether it is qualitative or quantitative. If it is qualitative state whether it is nominal or ordinal, and if it is quantitative state whether it is discrete or continuous. Provide a printout of the data in your sample, sorted in ascending order based on student ID number.
[4 Marks]
2. Produce 2 Pareto Graphs showing the grade distribution of the BUS100 and BUS600 subjects. Provide your comments on the graph shape, and grade distribution.
[6 Marks]
3. Create histograms and side by side boxplots showing the distribution of students’ marks for BUS100 and BUS600. Comment on the shape of the distribution in each graph. In particular, is it symmetric? If it is not, is it positively or negatively skewed?
[6 Marks]
4. Produce the following Pivot Tables:
a) Create a pivot table to show the average student marks per semester for BUS100 & BUS600 in 2012 and 2013. Provide your comments on similarities or differences and any conclusions you can draw in each case.
b) Construct a pivot table that shows the number of student who succeeded per semester, per year for BUS100 and BUS600. Place subjects and semesters in the rows, years in the columns and a count of students in the body of the table.
c) Convert the above table in (b) into another table by converting the student numbers into relative frequencies ( % of success rates) in each case. Provide your comments and conclusions on the results.
[11 Marks]
5. Using the information obtained for your analyses write a short conclusion about what you found from the study above.
[3 marks]
Looking for answers ?
Recent Questions
Assessment 2: (20%) Case Study Presentation Due Date weeks 10This assessment builds on your theoretical knowledge and tests your ability to apply this knowledge to practice.you are required to formulate...Assessment 2Assessment 2Report: 30%Word count: 1400 – 1600 wordsDue date: Sunday of Week 8DescriptionYou are playing the role of a community service worker supporting a young adult son who is 18 years...1500-1800 wordsInstructions From TutorPlease download the eTask3 spreadsheet from Canvas and save the eTask spread as an Excel file. The main content of the force method is taught in Lectures 6,7&8.eTask3.1 is a...ASSIGNMENT INSTRUCTIONSAssessment Practical assessmentAssessment code: 011Academic Year: 2023/2024Trimester: 2Module Title: Critical Perspectives on Cross-Border BusinessModule Code: MOD009194Level: 6Module...Information Systems Analysis & DesignAssignmentDue date: Week 5 Friday (5 Apr 2024) 11:59 pm AESTWeighting: 30%Length: 1,200 to 1,500 words (penalty will apply if the length is outside this limit)Assessment...Problem:University of Technology Sydney 48353: CONCRETE DESIGN Autumn 2024 - Assignment 2 (13 Marks)The figure illustrates the cross-section of a reinforced concrete column with a hexagonal shape (equal...Show All Questions