fin10002 financial statistics assignment 2 major assignment

More from Swinburne University

• Giving to Swinburne
• Current students
• Staff login
• Arts, Humanities and Social Sciences
• Built Environment and Architecture
• Engineering
• Film and Television
• Games and Animation
• Information Technology
• Media and Communication
• Trades and Apprenticeships
• Study online
• Transition to university from VCE
• Direct entry into university
• Returning to study
• Vocational Education and Training at Swinburne
• Early Entry Program
• University entry requirements
• Transferring to Swinburne
• Recognition of prior learning in the workplace
• Study Abroad in Melbourne
• Study support for indigenous students
• Guaranteed pathways from TAFE
• Short courses
• University certificates
• Pre-apprenticeships
• Apprenticeships
• Associate degrees
• Bachelor degrees
• Double degrees
• Certificates
• Traineeships
• Trade short courses
• Doctor of Philosophy
• Master degrees
• Graduate diploma courses
• Graduate certificate courses
• Studying outside of Australia
• Study on campus
• Loans and discounts for local students
• Course fees for international student
• Fees for local students
• Student Services and Amenities Fee
• Scholarship conditions
• Scholarships for international students
• How to apply as a local student
• How to apply for a research degree
• How to apply as an international student
• Apply as an asylum seeker or refugee
• How to enrol
• Understanding your university offer
• Course planner
• Setting up your class timetable
• Enrol as a PhD or master degree student
• Why study in Australia?
• Plan your arrival in Melbourne
• Arriving in Melbourne
• Things to do in Melbourne
• Getting around Melbourne
• Money, living costs and banking in Australia
• International student stories
• Student email, password and Wi-Fi access
• Your student ID card and Swinburne login
• Student discounts and concessions
• Special consideration and extensions
• Accommodation
• Study and learning support
• Health and wellbeing
• Support for international students
• Independent advocacy for service
• Indigenous student services
• Financial support and advice
• AccessAbility services
• Legal advice for students
• Spiritual Wellbeing
• Assault reporting and help
• Asylum seeker and refugee support
• Care leaver support
• LGBTIQ+ community support
• Childcare for the Swinburne community
• Support for Students Guidelines: Policies, Procedures and Frameworks
• Industry-linked projects
• Internships
• Student stories
• Professional Degrees
• Industry study tours
• Get paid to podcast
• Real industry experience stories
• Overseas exchange
• Overseas study tours
• Overseas internships
• Students currently overseas
• Improve your employability
• Career services
• Professional Purpose program
• Partner Stories
• Hosting students with disabilities
• Work with our accreditation placement students
• Benefits of working with our students
• Apprenticeships and traineeships
• Workshops, events and outreach programs
• Work experience
• Knox Innovation, Opportunity and Sustainability Centre
• Australian Synchrotron Science Education
• PrimeSCI! science education
• Student projects
• Meet our facilitators
• Meet our consultants
• Meet our leadership and management teams
• Hybrid working solutions
• Training needs analysis
• Why partner with Swinburne
• 4 simple steps to setting up a partnership
• Achievements and success stories
• Research engagement
• Facilities and equipment
• Achievements and recognition
• Iverson Health Innovation Research Institute
• Social Innovation Research Institute
• Space Technology and Industry Institute
• Innovative Planet Research Institute
• Research centres, groups and clinics
• Research platforms and initiatives
• Research facilities and equipment
• Indigenous research projects
• Animal research
• Biosafety and Defence
• Data management
• Funding from tobacco companies
• Human research
• Intellectual property
• Find an expert

Financial Statistics

This unit provides students with an introduction to statistics within a financial context. Students will gain an appreciation of what statistical methods can achieve, as well as skills in preparing, analysing and interpreting business data and statistical analysis. Students will also learn how to apply analytical tools to visualise and analyse data. The focus of the unit is on data science as an analytical and decision-making tool, in a variety of business contexts, with a major emphasis on interpretation and application.

Learning outcomes

Students who successfully complete this unit will be able to:

• Identify and apply commonly used techniques for data collection and analysis
• Apply fundamental concepts of probability and probability distributions to problems in business decision-making
• Apply statistical inference methods to conduct and explain the results of hypothesis testing
• Apply simple regression analysis to explain the relationship between variables to draw inferences about relationships
• Apply technological tools to analyse data for decision-making purposes

Teaching methods

Swinburne Online

• Descriptive Statistics
• Probability and Probability Distributions
• Sampling and Estimation
• Hypotheses Testing
• Correlation and Linear Regression
• Data Analytics using Power BI and Python

Study resources

Reading materials.

A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.

Assignment Help

• Academic Assignment Help
• Assignment Writers
• Custom Writing Services
• Online Assignment Help
• Effective Note-taking – Assignment Help
• Assignment Help Australia
• Write My Assignment
• Help on Assignments
• Buy Assignment Online
• Best Assignment Helper
• Assignment Paper Help
• College Assignment Help
• Help with Assignments Online
• Get Assignment Help
• Homework Assignment Help
• Thesis Writing Services
• Online Assignment Writer
• Collect material
• Perth Assignment Help
• Brisbane Assignment Help
• Adelaide Assignment Help
• Gold Coast Assignment Help
• Geelong Assignment Help
• Newcastle Assignment Help
• Sydney Assignment Help
• Melbourne Assignment Help
• Hobart Assignment Help
• Swinburne Assignment Help
• Monash Assignment Help
• Latrobe University Assignment Help
• Monash Assignments
• Coles Assignment Help
• Melbourne University Assignment
• CQU Assignment Help
• NMIT Assignments
• RMIT Assignments
• How to Write an Essay
• Creating an Essay Structure
• Essay Marking Schemes
• How To Write An Essay Plan
• Interpreting Your Essay
• Writing An Essay Title
• Writing A Critical Evaluation
• Argumentative Essay
• Critical Essay
• Essay Writing Help on Comparison Essay
• College Essay
• Deductive Essay
• Essay Writer
• Admission Essay
• Online Essay Help
• Do My Essay Online
• Evaluative Essay
• History Essay Help
• Research Essay Help
• Urgent Essay Help
• Top Quality Essay
• Top Essay Writing Companies
• Cheap Essay Writing Help
• Professional Essay Help
• Cheap Essay Writer
• Essay Writers Online
• Need Help Writing Essay
• Essay Homework Help
• Write Essay Online
• Comparison Essay
• Definition Essay
• Narrative Essay
• Personal Essay
• College Essay Help
• Essay Writing Help
• Assignment Writer Sydney
• Assignment Writer Brisbane
• Assignment Writer Melbourne
• Assignment Writer Perth
• Essay Writer Sydney
• Essay Writer Melbourne
• Essay Writer Perth
• Essay Writer Australia
• Essay Assignment Help
• Dissertation Writing Assignment Help
• Cheap Assignment Help
• Creating An Appendix
• Assignment Help Tutors
• Assignment Assistance Australia
• Student Assignment Help
• Last Minute Assignment Help
• Urgent Assignment Help
• Assignment Provider
• Do My Assignment Help
• Make My Assignment For Me
• Solve My Assignment
• Custom Assignment Writing
• How to Write a Dissertation – Assignment Help
• Quality Assignment Help
• Write My Assignment For Me
• Assignment Writing Tips
• Buy Assignment
• Article Writing Service

Assignment Help UK

• Animation Assignment Help
• Coursework Help

Leadership Assignment Help

• Network Planning Assignment Help
• Dissertation Proposal Writing Help

Report Writing Help

• My Assignment Help
• Microsoft PowerPoint Presentation
• Pecha Kucha Presentation Help
• Pestel Analysis Assignment Help
• University Assignment Help

Video Presentation Assignment Help

Homework help, auditing assignment help.

• Business Accounting Assignments
• Management Accounting Assignment Help
• Professional Accounting Assignment Help
• Economics Globalization Assignments
• Micro Economics Assignments
• Macro Economics Assignments
• Business Economics Assignments
• Managerial Economics Assignments
• Principle Of Finance Assignments
• Financial Management Assignment Help
• Financial Accounting Assignments
• Introduction Corporate Finance Assignments
• Entrepreneurship Assignment Help

Business Assignment Help

• Project Management Assignment
• Supply Chain Management
• Business Management Assignment Help
• Human Resource Assignment Help
• Operation Management Assignment
• Leadership Assignment
• Change Management Assignment Help
• Contract Law
• Constitutional Law
• Corporate Law
• Criminal Law
• Commercial Law
• International Law
• Property Law Assignment
• Taxation Law Assignment
• Tort Law Assignment
• Engineering Assignment Help UK
• Civil Engineering
• Computer Engineering
• Mechanical Engineering
• Software Engineering
• Online Engineering Assignment Help

CDR Writing

• CDR Assignment Help

Marketing Assignment Help

• Social Media Marketing Help
• Digital Marketing Assignment
• 4ps Of Marketing Assignment Help
• Pestel Analysis Assignment
• woolworths Assignment Help
• Costco Assignment Help
• Pricing Strategy Assignment
• Sales Promotion Assignment
• Porters Five Forces assignment
• Solve Accounting Assignment
• Bitcoin Assignment Help
• Lehman Brothers and Enron Scandal Auditing Assignment
• IT Management Assignment Help
• Healthcare Management Help
• Decision Making Assignment

Project Management Assignment Help

Artificial intelligence assignment help.

• Sample Assignments
• Assignment details

Give us a Feedback

• Make a Payment

Plagiarism Checker

• Privacy policy
• Refer a Friend
• Submit Documents & Earn
• Terms of service

Word Counter

• Get a Quote
• Student Login

FIN10002 Financial Statistics - Assignment Help

Assignment help on financial tasks, assessment 2: major assignment.

For this assessment, you need to produce a report by generating responses to eight tasks presented below. Note the assessment will be submitted in two instalments.

For some of these sections, you will need to use Excel and Python to generate statistical output (statistical analyses and graphs). The report should be presented in the form of a business report to a senior manager who cannot be assumed to have any knowledge of statistical methods . Microsoft Word, Excel, Python, Presentation software (PowerPoint, Sway or similar) and Video software (e.g., PowerPoint can do both, Adobe Spark Video, Premier or similar) should be used to complete this assessment. Your statistical calculations should be carried out using Excel and Python only. You will submit the Excel file, a zipped file containing the Python files and a pdf version of the report as soft copies via the submission folder in Canvas.

Assessment details

You will need to download the Excel dataset ‘Online Sales in USA.xlsx' from Canvas. The data set contains online transactions from October 20 to end of September 2021. There are 143,194 transactions in this data set and ten (10) columns variables as follows:

• Qty_Ordered
• Payment Method

You will use this data set to generate responses to the following eight tasks which are contained in the two Parts.

Get Your Customize Task on any subject starting 10$ /Page

Part A Weight 12%

This part of the assignment relates to the first 3 tasks.

Using the Excel file, ‘Online Sales in USA.xlsx' from Canvas to perform these tasks.

1.    Select a random sample

Select a random sample of size 120 transactions from the 143,194 transactions found in the Online Sales in USA.xlsx file. You will use this sample data to complete tasks 2 to 8.

2.    Descriptive statistics

Use data summary methods to describe the returns in your sample using nine

variables – items 2 to10 above. Do not perform the task on Order Id .

Use an appropriate graphical and summary statistical technique , chosen according to the type of variable (note that less appropriate/inappropriate techniques will receive fewer/no marks).

All nine (9) variables must have at least one table and graph produced by Excel. Why at least two table, as some variable can have a frequency table and a descriptive statistics table.

Also, for any four (4) must also have a table and graph generated by Python. They can be the same as the graphs generated in Excel. Thus, four variables will have at least, two tables and two graphs – one set from Excel and the other set from Python

Choose your techniques from:

Tabular Techniques : frequency tables and grouped frequency tables Summary Statistics : mode, median, mean, standard deviation, range, coefficient of variation and interquartile range

Graphical Techniques : pie chart, bar graph, histogram, frequency polygon.

(See topics 1 and 2)

Do not draw an ogive curve, stem plot, or a box plot in this assignment and do not draw 3-D graphs.

• For a nominal or an ordinal variable draw a graph and present a frequency table in
• For a ratio or an interval, variable draw a graph and a summary statistics table, including summary statistics appropriate to the type of distribution
• Try to use variation in drawing graphs e.g., pie chart/bar chart or histogram/polygon.
• Do not draw two different graphs for the same variable. You can draw the same type of graph for two variables.
• Do not include any information that you will not include in your discussion such as
• Display and describe one variable at a

3.    Dashboard

Construct a dashboard in Excel like the one below. Note yours will have different data as it is based upon your sample. However, you must have the same charts as below. Do not develop your own different combinations of variables. Note the slicers should work.

Submit a report summarizing the information for this task. The report will contain how you obtained your random sample and a summary of each variable. The sample will be contained in the appendix. A brief description of each variable and graphs and summary tables will be in the report.

This information will be used as part of your part B submission. Note the full structured report will be presented in Part B submission

You will submit the Excel file, python code and both a pdf version of the report.

Part B Weight 18%

You need to expand on your Part A submission by producing a report by generating responses to the additional four tasks presented below. For some of these sections, you will need to use Excel to generate statistical output (statistical analyses and graphs). The report should be presented in the form of a business report to a senior manager

  You will submit the Excel file, python code and both a pdf version of the report

4.    Confidence intervals

Estimate the following quantities, using 95% confidence intervals. Explain the meaning of your confidence intervals.

• The average price for the Men’s Fashion only
• The average age for customers from the Midwest only .

For this task produce the calculations in both Excel and Python for your data.

Compare both intervals with their respective true means by calculating the actual population mean from the full 143,194 transactions, and comparing the true population mean to the sample mean and confidence interval (note: it is not usual to do this, so you are asked to do this for the purpose of this assignment).

Your confidence interval should start with ‘We are 95% confident that…”. This section should take half a page or less.

NB: Please make sure you provide sufficient information in the appendix for your confidence interval calculations to be replicated, so they can be checked.

5.    Hypothesis testing

• It is often felt that the customers in the South are more likely to place larger orders than their Northeast Thus, the average quantity ordered for South customers is more than the average quantity ordered for Northeast customers . Investigate this contention by carrying out an appropriate hypothesis test.
• It is often felt that the average total spent per transaction would be different between the two specified genders. Test if there is a difference in average total spent for males and

In both cases assume equal variances and a significance level of 0.05.

Only report a non-technical explanation of your methodology and your findings in the main section of the report. The computations and output should be placed in an appendix, including the test statistic, p-value, and degrees of freedom. This should take half a page or less.

6.    Correlation and regression

In this section, you will investigate the relationship between age and total amount spent . Using these two variables develop a regression model to predict credit score from the estimated salary of the customer.

Make sure that you undertake a full regression analysis, with appropriate discussion and include:

• a scatterplot and a brief discussion
• an estimate of the linear regression model
• the coefficients of correlation and determination
• a test of the hypothesis that there is no linear relationship

between age and the total amount spent.

Ensure your scatterplot includes a line of best fit. Also, make sure you describe the relationship between the variables using R and R-square and interpret the slope, coefficients and the results of the hypothesis test. Use a significance level of 0.05. Need to submit both outputs.

7.    Conclusion

Provide a brief, concise summary of all your findings and briefly mention any limitations in your findings.

Make sure you do not give tables or graphs here.

8.    Video - Presentation of results

Provide a concise summary presentation in video form showing yourself and the results (via PowerPoint or similar software package). It should be concise summary of findings within 5 to 8 minutes maximum

Presentation for report

The report should be presented in the form of a business report to a senior manager who cannot be assumed to have any knowledge of statistical methods .

Make your report informative but concise and use a non-technical style. Do not just quote statistics or analysis results but explain what they mean. In general, do not include in the report formulae, calculations, definitions of statistical terms or discussions on how graphs are constructed. Where appropriate all these items should be included in the appendices.

It is important that the values which have been calculated are correctly analysed, discussed and interpreted , and that a written description of the main features of the tables and graphs that have been constructed is included. The emphasis in this assignment is on interpretation and analysis , not just the computation of statistics and construction of graphs. It will be assumed that all computations have been correctly performed and that graphs have been properly constructed. Nevertheless, marks will be deducted if these are inaccurate or incorrect.

The presentation is an important feature of a business report. The guide to the presentation that follows gives a general outline to report writing.

Executive Summary

• Report only the highlights of the
• Entice an Executive to read
• Essentially a lively summary of the main
• No longer than one page ; this is not counted in the word count and must be on a separate page from the rest of the report

Introduction

• State the purpose of the report e. what you will discuss in the report
• Outline the contents of the Report
• Provide a brief description of the methodology
• Describe the source of the data and state its location in the
• This should contain information about what we expect to read in the This should take about half a page.
• Contains a thorough yet non-technical description of all the findings (graphs and tables will be included only where they help this discussion).
• Details the results that were highlighted in the Executive Summary
• Do not include any calculations here but include appropriate graphs, results and tables which are needed to support your
• Report the findings and results of your
• Essentially an expansion of the executive summary written from the point of view that the Executive Summary has not been
• End with a discussion of the limitations of your analysis (e.g. reference to sample size if small, or comment on the data if it is old).
• Must be referred to in the main body of the

2.    Must contain your selection of random numbers and related random data.

• Include the raw data, charts and tables that are not essential , but support the ANALYSIS section.
• Include your EXCEL output for descriptive statistics, confidence intervals, hypothesis testing and regression. Include Python code and output for tasks 2, 4 and 6
• Include any other relevant

Please make sure the information in the appendix is sufficient for all calculations to be replicated , so they can be checked e.g., if you include the output for your confidence intervals, please show how this output was used to calculate the confidence intervals. Same for tasks 5 and 6 – show the output in the appendix Graphs must be in the Main body along with relevant tables and discussion. Graphs presented only in the appendices will not score any marks for graphs.

Keep the appendices to a moderate size. Your Excel and Python work confirmation will be checked in the Appendices. The emphasis in this assignment is on interpretation and analysis, not just the computation of statistics and construction of graphs. Make your report informative but concise and use a non-technical style. Do not just quote statistics or results of analyses but explain what they mean. In general, do not include formulae, calculations, definitions of statistical terms, or discussions on how graphs are constructed. Where appropriate these may be included in the appendices.

Submission details

This assessment will be submitted in softcopy only..

The softcopy will be submitted via Canvas in the Major Assignment submission. You are to submit both the report in pdf format, the excel file, your video and a zip file containing the python files.

Make sure that your student id and name is in the footer of the assignment .

Breathe a Sign of Relief with our Academic Assistance: Get instant help, 100% personalized and accurate solutions that make your study life better.

Expert's Answer

Related assignment questions, statistics assignment help.

• Statistics and Research Methods Assignment Help
• MA508 Business Statistics – Assignment Help
• Statistics Questions – Assignment Solution
• HI6007 Statistics for Business Decisions Assignment Help
• BEO2255 Applied Statistics For Business – Assignment 1
• BEO2255 Applied Statistics For Business – Assignment 2

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

• (+1) 812 6514131
• [email protected]

Your future, our responsibilty submit your task on time.

Get Professional Help at Low Prices!

Get  Online

Assignment Help Services

Get Instant Help through WhatsApp

Assignment studio - your partner in academic success, for students in uk.

For Students in USA

Popular Services

Dissertation help, thesis help, research paper help, popular subjects, law assignment help, engineering assignment help, accounting assignment help, economics assignment help, assignment help on companies, finance assignment help, nursing assignment help, it assignment help, database assignment help, programming assignment help, social media assignment help, sample assignment solutions, essay writing samples, literature review samples, case study samples, marketing report samples, worldwide services, united kingdom, united states, united arab emirates, submit documents & earn, refer & earn, order a new assignment, quick links, terms & conditions, refund policy, privacy policy, refer & earn upto 4000$.

Our Globally Trusted Assignment Help Service Delivers Tailored Solutions with Expert Guidance, Timely Delivery, and Unmatched Quality for Students in the UK, Australia, and USA!

Contact Details

101, gower street,wc1e 6aa, london, united kingdom, +44 7308 518706, brooklyn 11216, new york, united states, +1 8126514131, australia office, 533 little collin street, melbourne, australia.

Assignment Studio © 2024 All rights reserved.

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.

Get 1-On-1 Customized Essay Assistance

Order Now and Get 40% Off

Get 1-On-1 Customized Research Proposal Assistance

Get 1-on-1 customized dissertation assistance, get 1-on-1 customized thesis assistance, order now and get 25% off for september-october only.

From World's No.1 Assignment Help Company

FIN1002 financial statistics

Assignment Objectives of this assignment

To provide students with the opportunity to:

• combine statistical analysis and report writing skills to prepare a concise, non-technical business report,
• draw a random sample to complete statistical analysis,
• develop and enhance computing skills, specifically the use of the built-in functions in MS Excel and MS Word,
• apply statistical techniques to a data set, and
• reinforce taught concepts including descriptive statistics, sampling and estimation, hypothesis testing, correlation and regression.

There are seven variables in this data set and 1000 cases, including an ID number for each cases.. Download this data from the Blackboard.

In the assignment we use data about Banking supplied by Ordinary People’s Bank.

• ID: case number
• TYPE: Type of account (C:Cheque, S:Savings and V:Visa)
• SEX: Gender (F:Females and M:Males)
• AGE: Age of the account holder in years
• BALANCE: Account balance
• OPEN: Account open (1:Open and 0:Not Open)
• TRANSACTIONS: Total transaction in whole dollars

Most of your statistical calculations should be carried out using Excel only and you will use Microsoft Word and Excel to complete this assignment.

• Select a Random Sample

Select a random sample of size 50 from the given 1000 cases. You will use this sample data to complete tasks 2 to 6. Since repeat cases may occur when you draw random numbers and each case can be included only once in your sample, some of you may end up with a sample size less than 50. In such a situation do not draw another sample to acquire 50 values. You will continue to work on your sample only, even though your sample is smaller than 50.

Explain how you obtained your sample in the appendix and provide a list of your data.

• Descriptive Statistics

Use appropriate data summary methods to describe the bank data in your sample using the six variables. Use an appropriate graphical and/or summary statistical technique, chosen according to the type of variable These techniques will be chosen from:

Tabular Techniques: Frequency tables and Grouped frequency tables.

Graphical Techniques : Pie chart, Bar graph, Histogram, Frequency Polygon.

Summary Statistics: Mode, Median, Mean, Standard Deviation, Range, Coefficient of

Variation and Interquartile Range.

NB: You will need to choose the most appropriate technique(s) for each variable being analysed. Less appropriate/inappropriate techniques will receive fewer/no marks. Do not draw Ogive curve, Stem plot or a box plot in this assignment.

There are six variables all together to be analysed.

For a nominal or an ordinal variable draw a graph and present a frequency table in percentages.

For a ratio or an interval variable draw a graph and a summary statistics table.

Try to use variation in drawing graphs eg pie chart/ bar chart or histogram/polygon as much as possible. Do not draw two different graphs for the same variable.

3. Confidence intervals

Estimate the following quantities, using 95% confidence intervals. Explain the meaning of your confidence intervals.

(i) The average age of account holders for the open accounts only. (ii) The average total transaction dollars for all accounts.

Compare these intervals with their respective true means calculated from the full dataset in the main section of the report.

The computations and output should be placed in an appendix.

4. Hypothesis Testing

• It is often felt that female account holders have different account balances on average than male account holders. For this hypothesis only consider OPEN accounts . Investigate this contention by carrying out an appropriate hypothesis test.
• It is often felt that the average transaction dollars differ for Visa and non-visa accounts. Use ACCOUNT TYPE for this test .

Only report a non-technical explanation of your methodology and your findings in the main section of the report. The computations and output should be placed in an appendix.

5. Correlation and Regression

In this section you will investigate the relationship between the transaction dollars and age of the account holders for OPEN accounts only.

Using these two variables develop a regression model to predict average transaction dollar from their age. Make sure that you undertake a full regression analysis, with appropriate discussion and include:

• a scattergram and a brief discussion
• an estimate of the linear regression model
• the coefficients of correlation and determination
• a test of the hypothesis that there is no linear relationship between transaction dollars and the age of an account holder.

.The computations and output should be placed in an appendix .

This assignment counts 10% towards the final score.

Presentation 4

Executive Summary 4

Introduction 2

Descriptive statistics 12

Confidence intervals 6

Hypothesis Tests 6 Correlation and Regression 8

Conclusion and Limitations 4

Appendix with EXCEL outputs 4

Include only relevant Excel output in the report, the rest should be placed in the appendices. MARKS AND SUBMISSION INSTRUCTIONS:

• This assignment contributes 15% to the final assessment students are expected to submit genuine attempts at the assignment, before a pass grade or above can be awarded for the subject.

due assignment Feb 18th by 6 pm(AEST).

• This assignment must have the correct cover page (available on the FIN10002 web page) with your ID, family name and given name
• Submit your completed assignment electronically via the given portal.
• The penalty for late submission of assignments is 20% of awardable marks per day
• Marks will be awarded for presentation. Assignments must be word processed and include page numbers . Students are to use MS-Excel to perform the data analysis. All relevant Excel output, referred to but not included in the report itself, is to be placed in an appendix.
• Students must work independently on this assignment and submit only their own work.
• Assignment maximum lengths:

5 single-sided A4 pages , plus cover sheet, Executive Summary and appendices. Executive Summary and appendices are not included in the page count.

• Each student must keep a copy of their assignments for their own records.

Detailed instructions will be provided in your lectures about completing this assignment. Some Excel work will be demonstrated in some lectures to help you complete your calculations and project writing.

PRESENTATION OF A BUSINESS REPORT

The report should be presented in the form of a business report to a senior manager who cannot be assumed to have any particular knowledge of statistical methods.

Make your report informative but concise and use a non-technical style. Do not just quote statistics or analysis results but explain what they mean. In general, do not include in the report formulae, calculations, definitions of statistical terms or discussions on how graphs are constructed. Where appropriate these may be included in the appendices.

It is important that the values which have been calculated are correctly analysed, discussed and interpreted , and that a written description of the main features of the tables and graphs that have been constructed is included. The emphasis in this assignment is on interpretation and analysis , not just the computation of statistics and construction of graphs. It will be assumed that all computations have been correctly performed and that graphs have been properly constructed. Nevertheless, marks will be deducted if these are inaccurate or incorrect.

PRESENTATION

Presentation is an important feature of a business report. The guide to presentation that follows gives a general outline to report writing.

Executive Summary

 Report only the highlights of the findings

 Entice an Executive to read on

 Essentially a lively summary of the main conclusions

 No longer than one page , is not counted in the page count and must be on a separate page from the rest of the report.

Introduction

 State the purpose of the Report, ie what you will discuss in the report

 Outline the contents of the Report

 Provide a brief description of the methodology

 Describe the source of the data and state its location in the report.

 Contains a thorough yet non-technical description of all the findings (graphs and tables will be included only where they help this discussion).

 Details the results that were highlighted in the Executive Summary

 DO NOT INCLUDE ANY CALCULATIONS HERE but include appropriate graphs and tables which are needed to support your discussions

 Report the findings and results of your work

 Essentially an expansion of the EXECUTIVE SUMMARY written from the point of view that the Executive Summary has not been read.

 End with a discussion of the limitations of your analysis.

 MUST be numbered and referred to in the main body of the report

 A place for the raw data, charts and tables that are not essential for, but support, the ANALYSIS section.

 Computer outputs

 Any other relevant calculations

BUT keep the appendices to a moderate size. Marks are only given for the report itself. Your EXCEL work confirmation will be checked in the Appendices.

• MassiveMark Playground
• Transliteration Playground
• Professional Practice Test
• Our Services
• Assignmenthelp Services
• Custom Writing help
• Free Assignment Samples
• Free Homework Help Samples
• Terms of Use
• Refund Policy