Finance and Management

BUS103 Business Statistics Assessment

28 April 2023 15:46 PM | UPDATED 12 months ago

BUS103 Business Statistics Assessment :

BUS103 Business Statistics Assessment
BUS103 Business Statistics Assessment

BUS103 Business Statistics

ASSIGNMENT QUESTIONS

Marks 100 (Weighting 30%)

(use EXCEL to analyse the data) Please answer the following five questions in Excel and Word document

Q1. The travel expenses for a company are given below. Construct a pie chart and a bar chart for this data. (Marks = 10+10)

 ItemPercent
Airlines41
Lodging25
Meals12
Car rentals18
Other4

Q2. A company has determined that there are seven possible defects for one of its product lines. Construct a histogram for the following defect frequencies and in the graph show the line for cumulative frequency percentage. (Marks = 20)

Defect CodeFrequency
A10
B70
C15
D90
E8
F4
G3

Q3. Three subcontractors A, B and C supplied 58, 70 and 72 parts, respectively, to a plant during the last week. Of the parts supplied by subcontractor A, only 4 were defective. From the parts supplied by subcontractor B, 60 were good parts; from those supplied by subcontractor C, only 6 were defective. Set up a cross table for the data and draw a bar chart. (Marks = 20)

Q4. Determine the Descriptive Statistics of the given dataset (in Excel document) on wage, occupation, sector, union membership, education, experience, age and gender. Discuss the results of the Descriptive Statistics (answer this in a separate word document). Also, perform a Multivariate Analysis (multiple regression) with wage as dependent and experience, occupation and gender as independent variables. (Marks = 10+10+10)

Q5. From the given data set (in Excel document), test (t-Test: Paired Two Sample for Means) whether there is any significant difference of income for students in Melbourne and Sydney? Assume: hypothesized mean difference of the variable is 0 and acceptable level of error is 5%. (Marks = 10)

Visit:https://auspali.info/

Also visit:https://www.notesnepal.com/archives/767