HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION HI6007 Group Assignment Due Friday 5pm week 11 WORTH 30% (Maximum 5 students in the group) 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)

Oct 03, 2017

SOLUTION.PDF## Get Answer To This Question

- Dr. Ding3.The initial model to consider is a first-order model which includes all sevenpredictor variables. Use statistical techniques learned in this class to analyze the model. Things to be included...SolvedDec 14, 2019
- This project gives you the chance to use the statistical techniques and concepts covered in Chapters 7-9, and Chapter 14. Overview: The U.S. Department of Agriculture maintains a nutrient database for...SolvedDec 09, 2019
- 10 2 EDUC 478: Introduction to Quantitative Research Methods Regression Handout Use the Student Engagement Dataset for this exercise 1. We are interested in investigating which variables are good...SolvedDec 09, 2019
- Directions: Answer each question below in its entirety. Submit your answers through Canvas by the due date. Your submission should be a Word document. Please round to the nearest hundredth in your...SolvedDec 07, 2019
- Answer the following questions. 1. In 1990 Congress passed the Oil Pollution Act requiring tankers to have thicker hulls to prevent oil spills. Data were collected on 42 major oil spills recording the...SolvedDec 02, 2019
- Week 7 Homework overview This week we'll be learning how to build a regression model with a classification (yes/no, 1/0) variable as our dependent variable. We will use a technique called "logistic...SolvedNov 30, 2019
- Outline The project is to use a multiple regression analysis to analyze a data set that is of interest to you. If you have a strong interest in two group or analysis of variance you can do that with...SolvedNov 27, 2019
- Research Project for 3341 The project is to use a multiple regression analysis to analyze a data set that is of interest to you. If you have a strong interest in two group or analysis of variance you...SolvedNov 27, 2019
- You must submit 1 word document with your screenshots and answers. You should also submit the file where you conducted your statistical analysis (Excel, R, Python, etc.)...SolvedNov 26, 2019
- ROCKINGHAM NATIONAL BANK VISA CARD SURVEY Company Background Rockingham National Bank, located in Chicago, is attempting to expand the market for its Visa card. It is examining certain target groups...SolvedNov 21, 2019

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.