BUS201: Sydney Companies in Mind - Business Management Assignment Help

Assignment Task :

Business Management:

part 1

a. Prepare appropriate summary statistics on each variable and comment on each of these.

b. Use Excel to draw up the histograms of a number of rooms cleaned for each company. Comment on the shape of the histograms and compare the two companies.

c. Use a PivotTable to summarise the performance of the number of crews by looking at the sum of rooms cleaned by each crew size for each company. Compare the two companies by using the output of the pivot table.

part 2:

For the company chosen in 2, your boss wants you to fit a simple linear regression model to the data. Incorporate appropriate output in your report. y = Number of Rooms cleaned x = Number of Crews a. Justify the choice of explanatory and dependent variables. b. Estimate the regression equation between these variables. i. State and interpret the slope coefficient ii. State and interpret the R2 value from this. Iii Give a final summary of your findings from this regression.

This Business management assignment help has been solved by our Experts at onlineassignmentbank. 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.