Assessment 3: Individual Written Report
Start Assignment
• Due No due date
• Points 40
• Submitting a text entry box or a file upload
Assessment Details:
Given a data set that replicates the industry/world, students will be required to perform a wide range of statistical analysis covered in the course, with focus on the analysis of relationships between variables.
The response to the assignment must be provided in the form of a business report with no more than 10 pages (excluding cover page). The structure of your business report must include:
1. A Title
2. An Executive Summary
3. An Introduction
4. Analysis
5. Conclusions
Group Project Data:
Individual Assignment Instructions – 2022.docx Download Individual Assignment Instructions – 2022.docx
IndividualBusStats.xlsx Download IndividualBusStats.xlsx
Report Template.docx Download Report Template.docx
HE_Assignment_cover_sheet.docx Download HE_Assignment_cover_sheet.docx
Hard copies will not be accepted. Your work should be submitted via Canvas using Turnitin.
You can submit the documents separately (cover sheet, Report, Excel), or you can combine the coversheet and the word document into one single document, and submit together with the Excel file.
Applying for extension: If you are seeking an extension of seven (7) calendar days or less (from the original due date), you must apply and submit this form by at least one (1) working day before the assessment deadline using the following online form. In this instance, the assessment task is due on Wednesday 26 October 2022 by 23:59 PM therefore any assessment extensions must be submitted by 23:59 PM Tuesday 25 October 2022. If you need an extension of time beyond seven (7) days or if you have missed the one (1) working day requirement to submit this request, you should apply for SPECIAL CONSIDERATION https://www.rmit.edu.au/students/student-essentials/assessment-and-results/special-consideration. No exceptions are possible to this requirement. If you apply to the Special Consideration Unit please advise them that you are not eligible for an extension via your Course Coordinator and the reason (application date has passed, applying for more than 7 days, or extension application was not granted). Eligibility is focused on unexpected circumstances that have significantly impacted your ability to complete the assessment task by the prescribed date. You can only apply for extension if you satisfy the eligibility criteria. Your application will be strengthened by documentary evidence of your circumstances.
Late work will be penalised using RMIT protocols as noted in the ECON1030 course guide.
I declare that in submitting all work for this assessment I have read, understood and agree to the content and expectations of the Assessment declaration.
Common Queries on Assignment
General:
What are the relevant lecture topics covered in the final assessment?
This assessment focuses on the relationship between variables. Thus, the relevant lecture topics are: the 2nd half of Topic 9, Topic 10 and Topic 11. You also need skills you learned in Topic 1.
Before starting with the Excel:
There are two worksheets (public and private) in the dataset, you need to first create a dummy variable for public (1) and private (0) in the new column and combine these two worksheets into a new worksheet;
There are three categorical variables (gender, degree, married) in the dataset, you need to create dummy variables “0” and “1” for each of the variable.
Do I need to format a number on Excel that appears in exponential notation?
You don’t have to, but you are more likely to interpret the exponential notation correctly if you convert it to a number.
To convert an exponential notation to a number:
Select the cell with the numbers and right-click on them and click Format Cells
Go to the Number tab and click ok.
For example,
2.00E+05 =2×10^5=200000
2.00E-05 =2×10^(-5)= 0.00002 ~ 0
Do I need to remove outliers from the dataset?
No, you will not remove outliers.
How do I read t-value from Table E.3/E.4 if the degree of freedom (df) is larger than 120?
For any df>120, read t-values from the last row eg ∞.
Rubric
Rubric
Rubric_Individual_2021S1_V1
Rubric_Individual_2021S1_V1
Criteria Ratings Pts
This criterion is linked to a learning outcomeStatistical Analysis and Interpretation (32 pts) 32 to >28.0 Pts
Outstanding
The statistical analysis is accurate and complete (using appropriate formula and inference theory). Interpretation of statistical findings are precise, and understandable in Statistical and English language. A balanced display of numbers, graphs, and words, organized in a clear and readable way. 28 to >24.0 Pts
Very Good
The statistical analysis is mostly accurate but with minor flaws. The interpretation of statistical findings are mostly correct but with minor gaps, and understandable in Statistical and English language. A balanced display of statistical numbers, graphs, and words, but with minor flaws in clarity and coherence. 24 to >19.0 Pts
Good
The statistical analysis are partially accurate with some flaws. The interpretation of statistical findings is partially appropriate, but some gaps in both interpretation and results communication. An appropriate display of statistical numbers, graphs, and words, but with some flaws in clarity and coherence. 19 to >15.5 Pts
Pass
The statistical analysis are partially accurate with some major flaws for sub-questions. The interpretation of statistical findings is partially appropriate, but some gaps in both interpretation and results communication. An display of statistical numbers, graphs, and words, but with some apparent flaws in clarity and coherence. 15.5 to >0 Pts
Unsatisfactory
The statistical analysis are mostly incorrect with significant flaws. Interpretation of statistical findings is irrelevant to statistical theories and incorrect. An unbalanced display of statistical numbers, graphs, and words and poorly organised.
32 pts
This criterion is linked to a learning outcomeProfessional Report – Executive Summary (2.5 pts) 2.5 to >2.0 Pts
Outstanding/Very Good
Demonstrated thorough and in-depth understanding of an overview of key essential information comprising a report: context to the topic, scope of the investigation, methodology, and key findings and recommendations. 2 to >1.5 Pts
Good
Demonstrated a good understanding of an overview of key essential information comprising a report: context to the topic, scope of the investigation, methodology, and key findings and recommendations. 1.5 to >1.0 Pts
Pass
Demonstrated adequate understanding an overview of key essential information comprising a report: context to the topic, scope of the investigation, methodology, and key findings and recommendations. 1 to >0 Pts
Unsatisfactory
Failed to demonstrate elemental understanding an overview of key essential information comprising a report: context to the topic, scope of the investigation, methodology, and key findings and recommendations.
2.5 pts
This criterion is linked to a learning outcomeProfessional Report- Introduction (2.5 pts) 2.5 to >2.0 Pts
Outstanding/Very Good
Demonstrated thorough and in-depth understanding of three key areas: context of the topic; what the topic is & why it is important; the aims/objectives of the report. 2 to >1.5 Pts
Good
Demonstrated good understanding of three key areas: context of the topic; what the topic is & why it is important; the aims/objectives of the report. 1.5 to >1.0 Pts
Pass
Demonstrated adequate understanding of three key areas: context of the topic; what the topic is & why it is important; the aims/objectives of the report. 1 to >0 Pts
Unsatisfactory
Failed to demonstrate understanding of three key areas: context of the topic; what the topic is & why it is important; the aims/objectives of the report.
2.5 pts
This criterion is linked to a learning outcomeProfessional Report – Format (3 pts) 3 to >2.0 Pts
Outstanding/Very Good
Properly formatted with page numbering, informative heading and sub-headings, labelled graphs and tables (with proper titles) 2 to >1.5 Pts
Good
Minor flaws in formatting 1.5 to >1.0 Pts
Pass
Some flaws in formatting 1 to >0 Pts
Unsatisfactory
Poorly formatted
3 pts
Total points: 40
For this short paper activity, you will learn about the three delays model, which explains…
Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…
As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…
Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…
The behaviors of a population can put it at risk for specific health conditions. Studies…