MAT10251 STATISTICAL ANALYSIS PROJECT
This project leads you through a statistical analysis using a random sample of historical birth data.
The data for this project was obtained from a case study exercise undertaken in a particular Local Health District (LHD) in 2002.
Part A covers parts of Topic 1, Part B parts of Topics 5 and 6 and Part C parts of Topics 7 to 9.
It is suggested that you work on this project throughout Session 3.
Project Data
The data for this project can be accessed from the MySCU site for MAT10251 in Project under Assessment.
The data set provided contains 10 randomly chosen samples of size 116.
To obtain your data
(1) Click on the 'Project Data' file. This will download an Excel file.
(2) Select the 6 columns (bwt to smoke) of data for the sample specified by the last digit of your student ID number.
(3) Copy this into a new Excel file.
There are 10 sample data sets each of 6 columns (bwt to smoke)
Your sample number matches the last digit of your SCU student ID number. For example, if your student ID number ends in 1 your sample is Sample 1 and you will be analysing the birth data in columns H to M.
Project Situation
Assume that you are a research assistant engaged to investigate and report on the particulars and circumstances of new-borns.
You will be required to use your sample of 116 births to answer several questions relating to the sample or population. For this project, you will assume that the 116 births surveyed were randomly selected from the population of all births in your particular LHD in 2002.
In each part of the project you are required to analyse your sample data in response to given questions and provide a written answer. You can assume that the written answers are components of a longer report on the birth particulars of children born in the LHD.
To give your written task a context you should construct a scenario for the report.
Each written answer should be a word document into which your Excel, or similar, output has been copied.
Project Preparation
You are expected to use Excel, or another spreadsheet or statistical package, when completing the project.
Your written answers presenting findings and conclusions should be considered as a part of a longer report. Each written answer should be a word document into which your Excel, or similar, output has been copied
In addition, your statistical workings for Parts B and C should appear as appendices to your written answers. These should include all necessary steps and appropriate Excel output.
The written answers, with appendices for Parts B and C, should each be submitted as a single word document.
In preparing your appendices you may use one of the following formats:
• Word with Excel output added.
• Handwritten with Excel output added. This will then need to be scanned and added to your word document.
Notes
• You should not need to read beyond the study guide and textbook to complete the project.
• You probably will not need to reference, but if you do, use any consistent referencing style.
Project Submission
• Each part of the project should be presented as a SINGLE Word file with Excel output added.
• The given cover sheets should be included as the first pages of your submitted project and are not part of the page limit.
• DO NOT submit your appendices, which are not part of the page limit, for either part B or C as separate files.
• Also, ensure that the page setup of your submitted document is A4 Portrait, with an appropriate format so that it is easily readable if printed
• Please name your file
• “Family Name_First Name_Part_A/B/C_Campus”
• For example; Wagner_Liam_Part_A_Distance
Penalties For Incorrect Sample
• If you use a sample that does not correspond to the last digit of your student ID number, to be entered on the cover sheet, a maximum of two marks may be deducted, as this causes the marker extra work and frustration.
Incorrect Format
• If the page setup of your submitted Word file is not as required (that is, A4 Portrait, with appropriate format so that it is easily readable if printed) or your project is not submitted as a single Word document a maximum of two marks may be deducted, as this causes the marker extra work and frustration
• In addition, if your file is not named as requested or the required cover sheets are not included or correctly completed, a maximum of two marks may also be deducted, as this can cause the marker extra work and frustration.
MAT10251 STATISTICAL ANALYSIS
Data Analysis Project – Part A
(Marked out of 10 but worth 5% of final assessment)
Due Week 3 Tuesday 22nd November 2016
If you are a late enrolment in MAT10251, email Liam Wagner liam.wagner@scu.edu.au with the date you enrolled in MAT10251 for a revised due date
Value: 5%
Objectives: 2 to 5
Topic: 1
Purpose: To
• introduce you to the project data, questions and Excel • use Excel to graph data and calculate summary statistics
• interpret and communicate Excel results.
Full marks for Part A will be given for successful submission of an acceptable attempt.
Part A Question
Provide information on the birth weight of babies born in 2002 in a certain Local Health District (LHD). In particular, what are the minimum and maximum weights, the average weight, and how do these weights vary. Also, within what estimated range would you expect a typical baby’s weight to lie?
Tasks – Part A Submission
Complete the following tasks
1) Download and save your data.
2) Download the Project Part A cover sheets, name and save this file as
“Family Name_First Name_Part_A_Campus”.
3) Enter your Sample Number on page 2 of the Part A coversheets.
4) Statistical Tasks
Using bwt data explore the birth weights of the LHD children, by using Excel to
• Construct a frequency histogram or polygon
• Calculate the summary statistics
Note: bwt data is measured in grams (gms)
5) Written Task
Using the instructions given on page four of the Part A coversheets, introduce your data and the results of your preliminary investigation of birth weights for children in the LHD in 2002.
This should be one to two pages and 300 to 500 words.
Use an appropriate style, without statistical jargon and equations, to clearly communicate your results.
6) Complete Coversheets 1 and 2, then save and submit Part A of the project by the due date Tuesday 22nd November 2016.
Marking Criteria – Part A
Read the marking criteria carefully and consider them when preparing your Part A Submission.
See the marking and feedback sheet, page 3 Part A coversheets, for allocation of marks.
Note: you will use these criteria to self-mark Part A of the project – however, your mark for Part A will be based on successful submission of an acceptable attempt.
Statistical Calculation
• To obtain full marks your graph must be correct, including correct labels on both axes and a title. Marks will be deducted if:
• Graph incorrect (eg, gaps between classes of non-zero frequency in a histogram for continuous data) • Excel, or similar, is not used
• Axes incorrectly or not labelled
• No title
• Inappropriate classes are used
• Scale on axes distorts graphs.
• To obtain full marks for the summary statistics copy the output table of the Descriptive Statistics command in Data Analysis. You may delete unnecessary statistics in this table; you may also include other statistics, for example quartiles.
• Marks will be deducted if this table is incorrect, so check:
• Your sample size
• Whether you are calculating sample statistics or population parameters.
Written Task – Report
• 300 - 500 words and 1 to 2 pages - marks will be deducted if this is greatly exceeded.
• To obtain full marks this must:
• Be well structured
• Clearly communicate the results of the Excel output in language appropriate for your audience
• Include appropriate graph and summary statistics.
• Provide information on average birth weight of children, how the weights vary and any pattern to these weights.
• Marks will be deducted if:
• There is little or no comment on, or interpretation of, the Excel output
• Unnecessary statistical jargon and equations appear
• It is confusing or not readable
• It is handwritten
• For each major spelling and/or grammatical error half a mark will be deducted, up to a maximum of two marks.
• Also up to two marks may be deducted for poor structure and/or presentation.
GET ANSWERS / LIVE CHAT