Question
You must use MS Excel for this assignment The data for Task 1 in the data file for Assignment represents the starting costs in thousands
You must use MS Excel for this assignment
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
- frequency and relative frequency distributions starting from class 0 to 30
- (3 marks)
- 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.
- Present the MS Excel output and write down the estimated regression equation (3 marks)
- How well the model fits the data? (2 marks)
- Test the hypothesis that there is no significant relationship between the dependent and any
- of the independent variables (2 marks)
- Interpret individual slope coefficients (3 marks)
- Construct a 95% confidence interval for the slope coefficients of individual variables
- (3 marks)
- Test the estimated slope coefficients for individual variables for significance (3marks)
- Remove all insignificant variables and re-estimate the model (1 marks)
- 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)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667dc7a9c7e0a_145667dc7a9b6f01.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started