BUMAN201A: Business Maths and Statistics - TAFE NSW – Higher Education - Report Writing Assessment Answer

Subject Code: BUMAN201A

Report Writing Assessment Answer

Assignment Task: BUMAN201A Structure of the assessment This project will require students to apply statistical analysis and calculations to data and analyse the results of these calculations in a business setting. This assignment is to be presented as a report of no more than 8 pages A4 pages plus the appendices. The report should include all references and resources used in its compilation. All calculations for task 1, 2, 3 and 4 must be performed and presented using MS Excel and Word. The report shall include four sections to represent the four different tasks. Students must also submit an excel file with their calculations. This file must have formulas in the appropriate cells, and not data entered solutions. No marks will be awarded for written calculations. Task 1 Using the Excel data - ‘Sales’ sheet 1. Generate an appropriate table and graph for each of the two categorical variables of Region and Product. Make sure your graphs look professional and include in the table percentages with two decimal places. 2. Generate an appropriate table and graph for each of the 3 numerical variables. Make sure your graphs look professional. 3. Generate an appropriate row and column table in Excel to show the relationship between Representative, Region and Product, with Product in the Column. Show in percentages with two decimal places. 4. Use Excel to determine the total amount and the average for all the 3 numerical variables. 5. Comment on the data you have created. As the manager of this business, how could you use this data? Task 2 Using the Excel data - ‘Weight of Cereal’ sheet You are the production manager for Cereal Pops. Your production line produces 1-kilogram boxes of cereal for sale at supermarkets all over Australia. Your company has a target that at least 95% of its boxes will contain between 994 and 1006 grams of cereal. Assume the distribution of the weight of boxes is normal. 1) Calculate the average and standard deviation of the cans that have been measured. You should use excel formulas for this. 2) What is the probability that a box will weigh between 994 and 1006 grams? 3) What is the probability that a box will weigh less than 990 or more than 1010 grams? 4) What is the probability of a box weighing less than 984 grams? 5) What is the probability of a box weight over 1014 grams? 6) Has the company met its target? What are the consequences of not meeting this target? How can you use this data in your business? Task 3 Use the Excel Data ‘Hours of Extra Tuition’ Student Services wants to undertake a full analysis of the relationship between hours of extra tuition completed during the semester and the final Management exam mark. a) Undertake a full correlation analysis of the relationship between hours of extra tuition completed during the semester and the final Management exam mark. b) Develop the linear regression model of the relationship between the hours of extra tuition completed and the final Management exam mark. Include in the report a full detailed analysis concerning the model that has been fitted to the data. c) Predict the expected final Management exam mark when a student has completed 4 extra hours of tuition during the semester. Predict the final exam Maths and Stats mark if a student completed 10 extra hours of tuition during the semester. d) Comment on the reliability of this predicted final exam Mark. e) Suggest 3 other factors that may influence the final Maths and Stats exam mark. Task 4  Using the Census Data and Census Tables available on the Australian Bureau of Statistics abs.gov.au, select a Census Data, Quick Stats and the suburb of your choice (notify the teacher as soon as possible of your choice to ensure no duplications). a) Copy and paste the Frequency Tables for the following variables and Construct appropriate graphs for each of them. (6 marks) • Marital Status • Residential Status • Gender • Employment Status • Education • Country of Birth Assessment 2: 4 b) Using the Frequency Table for Grouped Age, locate the Age groups where Q1, Median and Q3 are located. Highlight the appropriate groups in the data table for each. Give an estimate of each of Q1, Median and Q3 and explain what each of them means in relation to the Age of the sample. c) What shape is the data for Age? d) The data from the Australian Census of 2016 is now available from the Australian Bureau of Statistics. Determine 6 statistical snapshot facts that indicate some of the major demographic changes in Australia in recent years.

This Report Writing Assessment has been solved by our Report Writing experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.