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, 2019

SOLUTION.PDF## Get Answer To This Question

- Include your SAS code and necessary output. (Do not need all output. Only provide output related to your answer for questions) Use the data in Problem 7 in chapter 5. (Data “EX0507.txt” is listed...SolvedJan 27, 2022
- Homework 4 involves data collected from a survey study by Urban, Smith, Wilson, and Cipher XXXXXXXXXXUndergraduate nursing students were surveyed and administered several questionnaires. Two of these...SolvedJan 26, 2022
- Refer to Table 11.13 on attitudes toward legalized abortion. For the response Yt(1=support legalization, 0=oppose.for question t (t=1, 2, 3.and for gender g (1=female, 0=male., consider the model...SolvedDec 29, 2021
- Table 9.19 is based on a study with British doctors.a. For each age, find the sample coronary death rates per 1000 person-years for nonsmokers and smokers. To compare them, take their ratio and...SolvedDec 29, 2021
- A study used the 1998 Behavioral Risk Factors Social Survey to consider factors associated with women’s use of oral contraceptives in the United States. Table 5.13 summarizes effects for a logistic...SolvedDec 29, 2021
- Table 2.11 refers to a retrospective study of lung cancer and tobacco smoking among patients in several English hospitals. The table compares male lung cancer patients with control patients having...SolvedDec 29, 2021
- Used cars are often sold wholesale at auctions, and from these sales, retail sales prices are recommended.The following table gives the recommended prices in 2009 for a four-door manual transmission...SolvedDec 29, 2021
- 1. Mr. Alpha: “looking at the data, I see that the amount of pies we sell varies from market to market and quarter to quarter. How good is your model at explaining that variation? Is there any way to...SolvedDec 29, 2021
- INFS 830: Decision Support SystemsAssignment 2Due 10/12/2017Dataset: The dataset represents 10 years XXXXXXXXXXof clinical care at 130 US hospitals. It includes over 50 features representing...SolvedDec 27, 2021
- Review the Statistics and Data Analysis for Nursing Research chapters that you read as a part of the Week 7 Learning Resources. As you do so, pay close attention to the examples presented—they provide...SolvedDec 27, 2021

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.