Business Assignment Help

UK Assignment Help

Business Assignment Help


You must use MS Excel for this assignment

Task 1 10 marks
The data for Task 1 in the data file for Assignment represents the starting costs in thousands of dollars) for different kind of business.
 1. Find mean, median, mode, range, variance and standard deviation separately for every type of business
2 marks)
 2. For every business type construct 
a. frequency and relative frequency distributions starting from class 0 to 30 (3 marks)
 b. a relative frequency histogram (3 marks)
 3. Discuss the results obtained in parts 1 and 2 (2 marks) 
4. Test if there significant difference in the starting costs for these types of business. (3 marks)
Task 2 20 marks 
The data for Task 2 in the data file for Assignment represents the following variables for franchisees of All Greens Pty Ltd: annual sales ($’000), the floor area (sq.ft.’000), inventory ($’000), advertising expenditure ($’000), the size of the area where the business operates (number of families, ‘000) and the
number of competitors in the area. 
1. Present the MS Excel output and write down the estimated regression equation (3 marks)
 2. How well the model fits the data? (2 marks) 
3. Test the hypothesis that there is no significant relationship between the dependent and any of the
independent variables (2 marks)
4. Interpret individual slope coefficients (3 marks)
 5. Construct a 95% confidence interval for the slope coefficients of individual variables (3 marks) 
6. Test the estimated slope coefficients for individual variables for significance (3marks)
 7. Remove all insignificant variables and re-estimate the model (1 marks)
 8. Using the model from part (g), predict annual sales for a franchisee with 1,000 sq ft floor area, $150,000 inventory, $5,000 spent on advertising, 5,000 families in the area of operation and 2 competitors. (3 marks)
project management assignment help, business management assignment help, business management assignment, management assignment help services, strategic management assignment help, management accounting assignment, management homework help, marketing management assignment help, human resource assignment help, human resource management assignment help, managerial accounting assignment help, management accounting assignment help, financial management assignment help, it management assignment help, project management homework help, hospitality management assignment help, hr management assignment help, operations management homework help, brand management assignment help, database management homework help


Submit Works

Drop File To Upload Or
Assignment Help Australia

Our Top Experts

Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders